{ "name": "הכנסת כמה סוגי מוצרים ותשלומים במורנינג", "flow": [ { "id": 1, "module": "json:ParseJSON", "version": 1, "parameters": { "type": "" }, "filter": { "name": "Bundle", "conditions": [] }, "mapper": { "json": "[\n {\n \"date\": \"2023-09-05\",\n \"type\": 2,\n \"price\": \"1500\",\n \"bankName\": \"בנק לאומי\",\n \"currency\": \"ILS\",\n \"chequeNum\": \"123456\",\n \"bankBranch\": \"001\",\n \"bankAccount\": \"12345678\"\n },\n {\n \"date\": \"2023-09-05\",\n \"type\": 1,\n \"price\": \"200\",\n \"currency\": \"ILS\"\n },\n {\n \"date\": \"2023-09-05\",\n \"type\": 3,\n \"price\": \"300\",\n \"cardNum\": \"1234\",\n \"currency\": \"ILS\"\n },\n {\n \"date\": \"2023-09-05\",\n \"type\": 4,\n \"price\": \"500\",\n \"currency\": \"ILS\"\n }\n]" }, "metadata": { "designer": { "x": 0, "y": 0, "name": "Bundle " }, "restore": { "parameters": { "type": { "label": "Choose a data structure" } } }, "parameters": [ { "name": "type", "type": "udt", "label": "Data structure" } ], "expect": [ { "name": "json", "type": "text", "label": "JSON string", "required": true } ] } }, { "id": 2, "module": "builtin:BasicAggregator", "version": 1, "parameters": { "feeder": 1 }, "mapper": { "date": "{{1.date}}", "type": "{{1.type}}", "price": "{{1.price}}", "bankName": "{{1.bankName}}", "currency": "{{1.currency}}", "chequeNum": "{{1.chequeNum}}", "bankBranch": "{{1.bankBranch}}", "bankAccount": "{{1.bankAccount}}", "cardNum": "{{1.cardNum}}" }, "metadata": { "designer": { "x": 300, "y": 0 }, "restore": { "expect": { "__IMTTARGET__": { "nested": { "type": { "mode": "chose" }, "currency": { "mode": "chose" }, "appType": { "mode": "chose", "label": "Empty" }, "subType": { "mode": "chose", "label": "Empty" }, "cardType": { "mode": "chose", "label": "Empty" }, "dealType": { "mode": "chose", "label": "Empty" } } } }, "extra": { "feeder": { "label": "Bundle - Parse JSON [1]" }, "target": { "label": "Custom" } } }, "expect": [ { "name": "__IMTTARGET__", "type": "collection", "label": "Plugins", "spec": [ { "name": "id", "type": "text", "label": "Id" } ] }, { "name": "__IMTTARGET__", "type": "collection", "label": "Payment rows", "spec": [ { "name": "date", "type": "text", "label": "Payment date", "required": true }, { "name": "type", "type": "select", "label": "Payment method", "required": true, "validate": { "enum": [ 0, 1, 2, 3, 4, 5, 10, 11 ] } }, { "name": "price", "type": "number", "label": "Item price", "required": true }, { "name": "currency", "type": "select", "required": true, "validate": { "enum": [ "ILS", "USD", "EUR", "GBP", "JPY", "CHF", "CNY", "AUD", "CAD", "RUB", "BRL", "HKD", "SGD", "THB", "MXN", "TRY", "NZD", "SEK", "NOK", "DKK", "KRW", "INR", "IDR", "PLN", "RON", "ZAR", "HRK" ] } }, { "name": "currencyRate", "type": "number", "label": "Currency rate relative to ILS, If not set - decided by the rates of requested payment date." }, { "name": "bankName", "type": "text", "label": "Bank name (required when using Cheques)" }, { "name": "bankBranch", "type": "text", "label": "Bank branch (required when using Cheques)" }, { "name": "bankAccount", "type": "text", "label": "Bank account (required when using Cheques)" }, { "name": "chequeNum", "type": "text", "label": "Cheque number (required when using Cheques)" }, { "name": "accountId", "type": "text", "label": "Payer account (PayPal / Payment App / Other)" }, { "name": "transactionId", "type": "text", "label": "Transaction ID (PayPal / Payment App / Other)" }, { "name": "appType", "type": "select", "label": "Payment app type", "validate": { "enum": [ 1, 2, 3 ] } }, { "name": "subType", "type": "select", "label": "Other payment sub types", "validate": { "enum": [ 1, 2 ] } }, { "name": "cardType", "type": "select", "label": "Credit card type", "validate": { "enum": [ 1, 2, 3, 4, 5 ] } }, { "name": "cardNum", "type": "text", "label": "Credit card's last 4 digits" }, { "name": "dealType", "type": "select", "label": "Credit card deal type", "validate": { "enum": [ 1, 2, 3, 4, 5 ] } }, { "name": "numPayments", "type": "number", "label": "Credit card's payments count (1-36)" }, { "name": "firstPayment", "type": "number", "label": "Credit card's first payment" } ] } ] } }, { "id": 5, "module": "json:ParseJSON", "version": 1, "parameters": { "type": "" }, "mapper": { "json": "[\n {\n \"price\": 1250,\n \"vatType\": 1,\n \"currency\": \"ILS\",\n \"quantity\": 1,\n \"description\": \"בדיקה 1\"\n },\n {\n \"price\": 1250,\n \"vatType\": 1,\n \"currency\": \"ILS\",\n \"quantity\": 1,\n \"description\": \"בדיקה 2\"\n }\n]" }, "metadata": { "designer": { "x": 600, "y": 0, "name": "Bundle " }, "restore": { "parameters": { "type": { "label": "Choose a data structure" } } }, "parameters": [ { "name": "type", "type": "udt", "label": "Data structure" } ], "expect": [ { "name": "json", "type": "text", "label": "JSON string", "required": true } ] } }, { "id": 6, "module": "builtin:BasicAggregator", "version": 1, "parameters": { "feeder": 5 }, "mapper": { "price": "{{5.price}}", "vatType": "{{5.vatType}}", "currency": "{{5.currency}}", "quantity": "{{5.quantity}}", "description": "{{5.description}}" }, "metadata": { "designer": { "x": 900, "y": 0 }, "restore": { "extra": { "feeder": { "label": "Bundle - Parse JSON [5]" }, "target": { "label": "Custom" } } } } }, { "id": 3, "module": "app#green-invoice-y563os:addDocument", "version": 1, "parameters": { "__IMTCONN__": 1897832 }, "mapper": { "description": "קבלה עבור {{1.`customer name`}} : \n{{formatDate(now; \"MM/YYYY\")}}", "remarks": "{{1.Remarks}}", "emailContent": "היי {{1.`customer name`}} מצורף קבלה לחודש {{formatDate(now; \"MM/YYYY\")}}", "type": 320, "date": "{{now}}", "lang": "he", "currency": "ILS", "vatType": 0, "signed": true, "attachment": true, "client": { "name": "{{1.`customer name`}}\nמספר עוסק: {{1.`Company number`}}", "country": "IL", "add": false }, "income": "{{6.array}}", "payment": "{{2.array}}", "linkedDocumentIds": [ "{{1.`id - transaction invoice`}}" ] }, "metadata": { "designer": { "x": 1200, "y": 0, "name": "קבלה" }, "restore": { "parameters": { "__IMTCONN__": { "label": "My Morning Sandbox connection ( )", "data": { "scoped": "true", "connection": "app#green-invoice-y563os" } } }, "expect": { "type": { "mode": "chose", "label": "חשבונית מס / קבלה" }, "lang": { "mode": "chose", "label": "Hebrew (עברית)" }, "currency": { "mode": "chose", "label": "שקל" }, "vatType": { "mode": "chose", "label": "Default (Based on business type)" }, "discountAmountType": { "mode": "chose", "label": "Empty" }, "rounding": { "mode": "chose" }, "signed": { "mode": "chose" }, "attachment": { "mode": "chose" }, "client": { "nested": { "emails": { "mode": "chose" }, "add": { "mode": "chose" }, "self": { "mode": "chose" } } }, "income": { "mode": "edit", "items": [ { "currency": { "mode": "chose", "label": "שקל" }, "vatType": { "mode": "chose", "label": "Included (VAT included in the price)" } }, { "currency": { "mode": "chose", "label": "שקל" }, "vatType": { "mode": "chose", "label": "Included (VAT included in the price)" } } ] }, "payment": { "mode": "edit" }, "linkedDocumentIds": { "mode": "chose", "items": [ null ] }, "linkType": { "mode": "chose", "label": "Empty" }, "plugins": { "mode": "chose" } } }, "parameters": [ { "name": "__IMTCONN__", "type": "account:app#green-invoice-y563os2,app#green-invoice-y563os", "label": "Connection", "required": true } ], "expect": [ { "name": "description", "type": "text", "label": "Document's description" }, { "name": "remarks", "type": "text", "label": "Document's remarks" }, { "name": "footer", "type": "text", "label": "Text that appears in footer" }, { "name": "emailContent", "type": "text", "label": "Custom extra text appearing in email sent to customer" }, { "name": "type", "type": "select", "required": true, "validate": { "enum": [ 10, 100, 200, 210, 300, 305, 320, 330, 400, 405, 500, 600, 610 ] } }, { "name": "date", "type": "date", "label": "Document date" }, { "name": "dueDate", "type": "date", "label": "Document payment due date" }, { "name": "lang", "type": "select", "label": "Language", "required": true, "validate": { "enum": [ "he", "en" ] } }, { "name": "currency", "type": "select", "label": "Primary currency", "required": true, "validate": { "enum": [ "ILS", "USD", "EUR", "GBP", "JPY", "CHF", "CNY", "AUD", "CAD", "RUB", "BRL", "HKD", "SGD", "THB", "MXN", "TRY", "NZD", "SEK", "NOK", "DKK", "KRW", "INR", "IDR", "PLN", "RON", "ZAR", "HRK" ] } }, { "name": "vatType", "type": "select", "label": "Vat type for this document", "validate": { "enum": [ 0, 1, 2 ] } }, { "name": "discountAmount", "type": "number", "label": "Discount amount" }, { "name": "discountAmountType", "type": "select", "label": "Discount amount type", "validate": { "enum": [ "sum", "percentage" ] } }, { "name": "rounding", "type": "boolean", "label": "Round the amounts?" }, { "name": "signed", "type": "boolean", "label": "Digital sign the document?" }, { "name": "attachment", "type": "boolean", "label": "Attach the document in the email sent to recipient?" }, { "name": "client", "type": "collection", "spec": [ { "name": "id", "type": "text", "label": "Client ID" }, { "name": "name", "type": "text", "label": "Client name" }, { "name": "emails", "type": "array", "label": "Client emails where we will send links to download the created document", "spec": { "type": "text", "name": "value" } }, { "name": "taxId", "type": "text", "label": "Client tax id" }, { "name": "address", "type": "text", "label": "Client address" }, { "name": "city", "type": "text", "label": "Client city" }, { "name": "zip", "type": "text", "label": "Client zip code" }, { "name": "country", "type": "text", "label": "Client 2-letter ISO country code" }, { "name": "phone", "type": "text", "label": "Client phone" }, { "name": "fax", "type": "text", "label": "Client fax" }, { "name": "mobile", "type": "text", "label": "Client mobile" }, { "name": "add", "type": "boolean", "label": "Add a temporary client to the clients' list?" }, { "name": "self", "type": "boolean", "label": "Is this a self-invoice?" } ] }, { "name": "income", "type": "array", "label": "Income rows", "spec": [ { "name": "catalogNum", "type": "text", "label": "Catalog number" }, { "name": "description", "type": "text", "label": "Item description", "required": true }, { "name": "quantity", "type": "number", "label": "Quantity", "required": true }, { "name": "price", "type": "number", "label": "item price", "required": true }, { "name": "currency", "type": "select", "label": "currency", "options": [ { "label": "שקל", "value": "ILS" }, { "label": "דולר", "value": "USD" }, { "label": "אירו", "value": "EUR" }, { "label": "ליש״ט", "value": "GBP" }, { "label": "יין יפני", "value": "JPY" }, { "label": "פרנק שוויצרי", "value": "CHF" }, { "label": "יואן סיני", "value": "CNY" }, { "label": "דולר אוסטרלי", "value": "AUD" }, { "label": "דולר קנדי", "value": "CAD" }, { "label": "רובל", "value": "RUB" }, { "label": "ריאל ברזילאי", "value": "BRL" }, { "label": "דולר הונג קונגי", "value": "HKD" }, { "label": "דולר סינגפורי", "value": "SGD" }, { "label": "באט תאילנדי", "value": "THB" }, { "label": "פזו מקסיקני", "value": "MXN" }, { "label": "לירה טורקית", "value": "TRY" }, { "label": "דולר ניו זילנדי", "value": "NZD" }, { "label": "כתר שבדי", "value": "SEK" }, { "label": "כתר נורבגי", "value": "NOK" }, { "label": "כתר דני", "value": "DKK" }, { "label": "וון דרום קוריאני", "value": "KRW" }, { "label": "רופי הודי", "value": "INR" }, { "label": "רופי אינדונזי", "value": "IDR" }, { "label": "זלוטי", "value": "PLN" }, { "label": "לאו רומני", "value": "RON" }, { "label": "ראנד דרא\"פ", "value": "ZAR" }, { "label": "קונה", "value": "HRK" } ], "required": true }, { "name": "currencyRate", "type": "number", "label": "Currency rate relative to ILS, If not set - decided by the rates of requested document date." }, { "name": "vatRate", "type": "number", "label": "VAT rate of the item" }, { "name": "itemId", "type": "text", "label": "The ID of the item to attach as income" }, { "name": "vatType", "type": "select", "label": "Item vat type calculation", "options": [ { "label": "Default (VAT will be added based on the business type)", "value": 0 }, { "label": "Included (VAT included in the price)", "value": 1 }, { "label": "Exempt (VAT free)", "value": 2 } ], "required": true } ] }, { "name": "payment", "type": "array", "label": "Payment rows", "spec": [ { "name": "date", "type": "text", "label": "Payment date", "required": true }, { "name": "type", "type": "select", "label": "Payment method", "options": [ { "label": "ניכוי במקור", "value": 0 }, { "label": "מזומן", "value": 1 }, { "label": "צ׳ק", "value": 2 }, { "label": "כרטיס אשראי", "value": 3 }, { "label": "העברה בנקאית", "value": 4 }, { "label": "פייפאל", "value": 5 }, { "label": "אפליקציית תשלום", "value": 10 }, { "label": "אחר", "value": 11 } ], "required": true }, { "name": "price", "type": "number", "label": "Item price", "required": true }, { "name": "currency", "type": "select", "label": "currency", "options": [ { "label": "שקל", "value": "ILS" }, { "label": "דולר", "value": "USD" }, { "label": "אירו", "value": "EUR" }, { "label": "ליש״ט", "value": "GBP" }, { "label": "יין יפני", "value": "JPY" }, { "label": "פרנק שוויצרי", "value": "CHF" }, { "label": "יואן סיני", "value": "CNY" }, { "label": "דולר אוסטרלי", "value": "AUD" }, { "label": "דולר קנדי", "value": "CAD" }, { "label": "רובל", "value": "RUB" }, { "label": "ריאל ברזילאי", "value": "BRL" }, { "label": "דולר הונג קונגי", "value": "HKD" }, { "label": "דולר סינגפורי", "value": "SGD" }, { "label": "באט תאילנדי", "value": "THB" }, { "label": "פזו מקסיקני", "value": "MXN" }, { "label": "לירה טורקית", "value": "TRY" }, { "label": "דולר ניו זילנדי", "value": "NZD" }, { "label": "כתר שבדי", "value": "SEK" }, { "label": "כתר נורבגי", "value": "NOK" }, { "label": "כתר דני", "value": "DKK" }, { "label": "וון דרום קוריאני", "value": "KRW" }, { "label": "רופי הודי", "value": "INR" }, { "label": "רופי אינדונזי", "value": "IDR" }, { "label": "זלוטי", "value": "PLN" }, { "label": "לאו רומני", "value": "RON" }, { "label": "ראנד דרא\"פ", "value": "ZAR" }, { "label": "קונה", "value": "HRK" } ], "required": true }, { "name": "currencyRate", "type": "number", "label": "Currency rate relative to ILS, If not set - decided by the rates of requested payment date." }, { "name": "bankName", "type": "text", "label": "Bank name (required when using Cheques)" }, { "name": "bankBranch", "type": "text", "label": "Bank branch (required when using Cheques)" }, { "name": "bankAccount", "type": "text", "label": "Bank account (required when using Cheques)" }, { "name": "chequeNum", "type": "text", "label": "Cheque number (required when using Cheques)" }, { "name": "accountId", "type": "text", "label": "Payer account (PayPal / Payment App / Other)" }, { "name": "transactionId", "type": "text", "label": "Transaction ID (PayPal / Payment App / Other)" }, { "name": "appType", "type": "select", "label": "Payment app type", "options": [ { "label": "ביט", "value": 1 }, { "label": "פפר-פיי", "value": 2 }, { "label": "פיי-בוקס", "value": 3 } ] }, { "name": "subType", "type": "select", "label": "Other payment sub types", "options": [ { "label": "ביטקוין", "value": 1 }, { "label": "שווה כסף", "value": 2 } ] }, { "name": "cardType", "type": "select", "label": "Credit card type", "options": [ { "label": "Isracard (ישראכרט)", "value": 1 }, { "label": "Visa (ויזה)", "value": 2 }, { "label": "Mastercard (מאסטרקארד)", "value": 3 }, { "label": "American Express (אמריקן אקספרס)", "value": 4 }, { "label": "Diners (דיינרס)", "value": 5 } ] }, { "name": "cardNum", "type": "text", "label": "Credit card's last 4 digits" }, { "name": "dealType", "type": "select", "label": "Credit card deal type", "options": [ { "label": "רגיל", "value": 1 }, { "label": "תשלומים", "value": 2 }, { "label": "קרדיט", "value": 3 }, { "label": "חיוב נדחה", "value": 4 }, { "label": "אחר", "value": 5 } ] }, { "name": "numPayments", "type": "number", "label": "Credit card's payments count (1-36)" }, { "name": "firstPayment", "type": "number", "label": "Credit card's first payment" } ] }, { "name": "linkedDocumentIds", "type": "array", "label": "Linked document IDs", "spec": { "type": "text", "name": "value" } }, { "name": "linkedPaymentId", "type": "text", "label": "Linked payment ID" }, { "name": "linkType", "type": "select", "label": "Reference type (applicable only when using linkedDocumentIds)", "validate": { "enum": [ "link", "cancel" ] } }, { "name": "plugins", "type": "array", "label": "Plugins", "spec": [ { "name": "id", "type": "text", "label": "Id" } ] }, { "name": "maxPayments", "type": "uinteger", "label": "Max payments" } ] } } ], "metadata": { "instant": false, "version": 1, "scenario": { "roundtrips": 1, "maxErrors": 3, "autoCommit": true, "autoCommitTriggerLast": true, "sequential": false, "confidential": false, "dataloss": false, "dlq": false, "freshVariables": false }, "designer": { "orphans": [] }, "zone": "eu1.make.com" } }