{ "name": "Submit parent form in Gravity from Make.com (Integromat)", "flow": [ { "id": 124, "module": "ftp:TriggerNewFile", "version": 8, "parameters": { "folder": "/sent", "account": 151697, "maxResults": 5, "XXXXXXXXXXXXXX": true }, "mapper": {}, "metadata": { "designer": { "x": 0, "y": 300 }, "restore": { "parameters": { "account": { "data": { "scoped": "undefined", "connection": "undefined" }, "label": "AMEX Bank Gate" } } }, "parameters": [ { "name": "account", "type": "account:ftp", "label": "Connection", "required": true }, { "name": "maxResults", "type": "uinteger", "label": "Maximum number of returned files" }, { "name": "isToManageDataWithinSharedConnection", "type": "boolean", "label": "Manage data within the shared connection", "required": true }, { "name": "folder", "type": "folder", "label": "Folder", "required": true } ] } }, { "id": 148, "module": "util:SetVariable2", "version": 1, "parameters": {}, "filter": { "name": "Contains GL9999?", "conditions": [ [ { "a": "{{124.fileName}}", "b": "GL9999", "o": "text:contain:ci" } ] ] }, "mapper": { "name": "Split filename to get the date", "scope": "roundtrip", "value": "{{split(124.fileName; \"_\")}}" }, "metadata": { "designer": { "x": 300, "y": 300, "name": "Fetch file name" }, "restore": { "scope": { "label": "One cycle" } }, "expect": [ { "name": "name", "type": "text", "label": "Variable name", "required": true }, { "name": "scope", "type": "select", "label": "Variable lifetime", "required": true, "validate": { "enum": [ "roundtrip", "execution" ] } }, { "name": "value", "type": "any", "label": "Variable value" } ], "interface": [ { "name": "Split filename to get the date", "type": "any", "label": "Split filename to get the date" } ] } }, { "id": 150, "module": "util:SetVariable2", "version": 1, "parameters": {}, "mapper": { "name": "Report's Day", "scope": "roundtrip", "value": "{{substring(148.`Split filename to get the date`[5]; 6; 8)}}" }, "metadata": { "designer": { "x": 600, "y": 300, "name": "Report's day" }, "restore": { "scope": { "label": "One cycle" } }, "expect": [ { "name": "name", "type": "text", "label": "Variable name", "required": true }, { "name": "scope", "type": "select", "label": "Variable lifetime", "required": true, "validate": { "enum": [ "roundtrip", "execution" ] } }, { "name": "value", "type": "any", "label": "Variable value" } ], "interface": [ { "name": "Report's Day", "type": "any", "label": "Report's Day" } ] } }, { "id": 94, "module": "util:SetVariable2", "version": 1, "parameters": {}, "mapper": { "name": "Report's Month", "scope": "roundtrip", "value": "{{substring(148.`Split filename to get the date`[5]; 4; 6)}}" }, "metadata": { "designer": { "x": 900, "y": 300, "name": "Report's month" }, "restore": { "scope": { "label": "One cycle" } }, "expect": [ { "name": "name", "type": "text", "label": "Variable name", "required": true }, { "name": "scope", "type": "select", "label": "Variable lifetime", "required": true, "validate": { "enum": [ "roundtrip", "execution" ] } }, { "name": "value", "type": "any", "label": "Variable value" } ], "interface": [ { "name": "Report's Month", "type": "any", "label": "Report's Month" } ] } }, { "id": 95, "module": "util:SetVariable2", "version": 1, "parameters": {}, "mapper": { "name": "Report's Year", "scope": "roundtrip", "value": "{{substring(148.`Split filename to get the date`[5]; 0; 4)}}" }, "metadata": { "designer": { "x": 1200, "y": 300, "name": "Report's year" }, "restore": { "scope": { "label": "One cycle" } }, "expect": [ { "name": "name", "type": "text", "label": "Variable name", "required": true }, { "name": "scope", "type": "select", "label": "Variable lifetime", "required": true, "validate": { "enum": [ "roundtrip", "execution" ] } }, { "name": "value", "type": "any", "label": "Variable value" } ], "interface": [ { "name": "Report's Year", "type": "any", "label": "Report's Year" } ] } }, { "id": 28, "module": "google-drive:uploadAFile", "version": 4, "parameters": { "__IMTCONN__": 151652 }, "filter": { "name": "CSV file contains data?", "conditions": [ [ { "a": "{{length(124.data)}}", "b": "50", "o": "number:greater" }, { "a": "{{contains(124.fileName; \"GL9999\")}}", "b": "", "o": "exist" } ] ] }, "mapper": { "data": "{{124.data}}", "title": "{{95.`Report's Year`}}-{{94.`Report's Month`}}-{{150.`Report's Day`}}_{{148.`Split filename to get the date`[3]}}_{{148.`Split filename to get the date`[6]}}", "select": "value", "convert": true, "filename": "{{124.fileName}}", "folderId": "/XXXXXXXXXXXXXXXXXXXXXXXX", "targetType": "application/vnd.google-apps.spreadsheet", "destination": "team", "sharedDrive": "XXXXXXXXXXXXXXXXXXXXXXXX", "useDomainAdminAccess": false }, "metadata": { "designer": { "x": 1500, "y": 300, "name": "Upload + convert to gSheet" }, "restore": { "expect": { "select": { "label": "Select from the list" }, "folderId": { "path": [ "XXXXXXXXXXXXXXXXXXXXXXXX" ] }, "targetType": { "label": "application/vnd.google-apps.spreadsheet" }, "destination": { "label": "Google Shared Drive" }, "sharedDrive": { "label": "Finance - IT - Automated" }, "useDomainAdminAccess": { "label": "No" } }, "parameters": { "__IMTCONN__": { "data": { "scoped": "undefined", "connection": "undefined" }, "label": "My Google Restricted connection" } } }, "parameters": [ { "name": "__IMTCONN__", "type": "account:google-restricted", "label": "Connection", "required": true } ], "expect": [ { "name": "select", "type": "select", "label": "Enter a Folder ID", "required": true, "validate": { "enum": [ "map", "value" ] } }, { "name": "title", "type": "text", "label": "New File Name" }, { "name": "filename", "type": "filename", "label": "File Name", "required": true }, { "name": "data", "type": "buffer", "label": "Data", "required": true }, { "name": "convert", "type": "boolean", "label": "Convert a File", "required": true }, { "name": "destination", "type": "select", "label": "New Drive Location", "required": true, "validate": { "enum": [ "drive", "share", "team" ] } }, { "name": "useDomainAdminAccess", "type": "select", "label": "Use Domain Admin Access", "required": true, "validate": { "enum": [ true, false ] } }, { "name": "sharedDrive", "type": "select", "label": "Shared Drive", "required": true }, { "name": "folderId", "type": "folder", "label": "New Folder Location", "required": true }, { "name": "targetType", "type": "select", "label": "Target Google File Type", "required": true } ], "advanced": true } }, { "id": 64, "module": "datastore:DeleteAllRecords", "version": 1, "parameters": { "datastore": 4092 }, "mapper": {}, "metadata": { "designer": { "x": 1800, "y": 300, "name": "Flush old temp data" }, "restore": { "parameters": { "datastore": { "label": "Expenses to be created" } } }, "parameters": [ { "name": "datastore", "type": "datastore", "label": "Data store", "required": true } ] } }, { "id": 32, "module": "google-sheets:getSheetContent", "version": 2, "parameters": { "__IMTCONN__": 151670 }, "mapper": { "range": "P3:P500", "sheetId": "{{28.name}}", "spreadsheetId": "{{28.id}}", "includesHeaders": false, "valueRenderOption": "FORMATTED_VALUE", "dateTimeRenderOption": "FORMATTED_STRING" }, "metadata": { "designer": { "x": 2100, "y": 300 }, "restore": { "expect": { "spreadsheetId": { "mode": "edit" }, "includesHeaders": { "mode": "chose" }, "valueRenderOption": { "mode": "chose", "label": "Formatted value" }, "dateTimeRenderOption": { "mode": "chose", "label": "Formatted string" } }, "parameters": { "__IMTCONN__": { "data": { "scoped": "undefined", "connection": "undefined" }, "label": "My Google connection" } } }, "parameters": [ { "name": "__IMTCONN__", "type": "account:google", "label": "Connection", "required": true } ], "expect": [ { "name": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "range", "type": "text", "label": "Range", "required": true }, { "name": "includesHeaders", "type": "boolean", "label": "Table contains headers", "required": true }, { "name": "valueRenderOption", "type": "select", "label": "Value render option", "validate": { "enum": [ "FORMATTED_VALUE", "UNFORMATTED_VALUE", "FORMULA" ] } }, { "name": "dateTimeRenderOption", "type": "select", "label": "Date and time render option", "validate": { "enum": [ "SERIAL_NUMBER", "FORMATTED_STRING" ] } }, { "name": "sheetId", "type": "any", "label": "Sheet", "required": true } ], "interface": [ { "name": "__IMTLENGTH__", "type": "uinteger", "label": "Total number of bundles" }, { "name": "__IMTINDEX__", "type": "uinteger", "label": "Bundle order position" }, { "name": "__ROW_NUMBER__", "type": "number", "label": "Row number" }, { "name": "__SPREADSHEET_ID__", "type": "text", "label": "Spreadsheet ID" }, { "name": "__SHEET__", "type": "text", "label": "Sheet" }, { "name": "0", "type": "text", "label": "P" } ] } }, { "id": 34, "module": "builtin:BasicAggregator", "version": 1, "parameters": { "feeder": 32 }, "filter": { "name": "Remove invalid names (too short)", "conditions": [ [ { "a": "{{length(32.`0`)}}", "b": "6", "o": "number:greater" } ] ] }, "mapper": { "0": "{{32.`0`}}" }, "metadata": { "designer": { "x": 2400, "y": 300 }, "restore": { "feeder": { "label": "Google Sheets - Get Range Values [32]" }, "mapper": { "label": [ null ] }, "target": { "label": "Custom" } } } }, { "id": 29, "module": "util:SetVariable2", "version": 1, "parameters": {}, "mapper": { "name": "Names without duplicates", "scope": "roundtrip", "value": "{{distinct(34.array)}}" }, "metadata": { "designer": { "x": 2794, "y": 294, "name": "De-duplicate" }, "restore": { "expect": { "scope": { "label": "One cycle" } } }, "expect": [ { "name": "name", "type": "text", "label": "Variable name", "required": true }, { "name": "scope", "type": "select", "label": "Variable lifetime", "required": true, "validate": { "enum": [ "roundtrip", "execution" ] } }, { "name": "value", "type": "any", "label": "Variable value" } ], "interface": [ { "name": "Names without duplicates", "type": "any", "label": "Names without duplicates" } ] } }, { "id": 49, "module": "builtin:BasicFeeder", "version": 1, "parameters": {}, "mapper": { "array": "{{29.`Names without duplicates`}}" }, "metadata": { "designer": { "x": 3128, "y": 304, "name": "For each name de-duplicated name found..." }, "restore": { "expect": { "array": { "mode": "edit" } } }, "expect": [ { "mode": "edit", "name": "array", "spec": [], "type": "array", "label": "Array" } ] } }, { "id": 50, "module": "wordpress:SearchUser", "version": 2, "parameters": { "__IMTCONN__": 151708 }, "mapper": { "limit": "1", "search": "{{49.value}}" }, "metadata": { "designer": { "x": 3447, "y": 302, "name": "Link name to a Wordpress ID" }, "restore": { "parameters": { "__IMTCONN__": { "data": { "scoped": "undefined", "connection": "undefined" }, "label": "My WordPress connection" } } }, "parameters": [ { "name": "__IMTCONN__", "type": "account:wordpress2", "label": "Connection", "required": true } ], "expect": [ { "name": "search", "type": "text", "label": "Search term" }, { "name": "limit", "type": "uinteger", "label": "Limit", "required": true } ], "interface": [ { "name": "__IMTLENGTH__", "type": "uinteger", "label": "Total number of bundles" }, { "name": "__IMTINDEX__", "type": "uinteger", "label": "Bundle order position" }, { "name": "id", "type": "uinteger", "label": "User ID" }, { "name": "firstName", "type": "text", "label": "First name" }, { "name": "lastName", "type": "text", "label": "Last name" }, { "name": "email", "type": "email", "label": "Email" }, { "name": "description", "type": "text", "label": "Description" }, { "name": "locale", "type": "text", "label": "Locale" }, { "name": "name", "type": "text", "label": "Name" }, { "name": "nickname", "type": "text", "label": "Nickname" }, { "name": "username", "type": "text", "label": "Username" }, { "name": "url", "type": "url", "label": "URL" }, { "name": "slug", "type": "text", "label": "Slug" }, { "name": "roles", "type": "array", "label": "Roles" }, { "name": "registeredDate", "type": "date", "label": "Registered date" }, { "name": "meta", "spec": [], "type": "collection", "label": "Metadata (custom fields)" } ] } }, { "id": 131, "module": "builtin:BasicRouter", "version": 1, "mapper": null, "metadata": { "designer": { "x": 3925, "y": 291 } }, "routes": [ { "flow": [ { "id": 55, "module": "gravity-forms:makeApiCall", "version": 1, "parameters": { "__IMTCONN__": 151742 }, "filter": { "name": "A name match was found?", "conditions": [ [ { "a": "{{50.`__IMTLENGTH__`}}", "o": "number:greater", "b": "0" } ] ] }, "mapper": { "url": "entries/?form_ids[0]=47&search={\"field_filters\": [{\"key\":12,\"value\":\"{{50.id}}\",\"operator\":\"is\"}]}", "method": "GET", "headers": [ { "key": "Content-Type", "value": "application/json" } ] }, "metadata": { "designer": { "x": 4289, "y": 180, "name": "Check if form exists already" }, "restore": { "parameters": { "__IMTCONN__": { "label": "My Gravity Forms Basic connection", "data": { "scoped": "undefined", "connection": "undefined" } } }, "expect": { "method": { "mode": "chose", "label": "GET" }, "headers": { "mode": "chose", "items": [ null ] }, "qs": { "mode": "chose" } } }, "parameters": [ { "name": "__IMTCONN__", "type": "account:gravity-forms2", "label": "Connection", "required": true } ], "expect": [ { "name": "url", "type": "text", "label": "URL", "required": true }, { "name": "method", "type": "select", "label": "Method", "required": true, "validate": { "enum": [ "GET", "POST", "PUT", "PATCH", "DELETE" ] } }, { "name": "headers", "type": "array", "label": "Headers", "spec": [ { "name": "key", "type": "text", "label": "Key" }, { "name": "value", "type": "text", "label": "Value" } ] }, { "name": "qs", "type": "array", "label": "Query String", "spec": [ { "name": "key", "type": "text", "label": "Key" }, { "name": "value", "type": "text", "label": "Value" } ] }, { "name": "body", "type": "any", "label": "Body" } ] } }, { "id": 73, "module": "builtin:BasicRouter", "version": 1, "mapper": null, "metadata": { "designer": { "x": 4593, "y": 168 } }, "routes": [ { "flow": [ { "id": 74, "module": "datastore:AddRecord", "version": 1, "parameters": { "datastore": 4092 }, "filter": { "name": "Form exists", "conditions": [ [ { "a": "{{55.body.entries[].workflow_step_status_495}}", "b": "pending", "o": "text:equal:ci" } ] ] }, "mapper": { "key": "", "overwrite": false, "data": { "Employee name": "{{50.firstName}} {{50.lastName}}", "WordPress ID": "{{50.id}}", "Gravity Form Entry ID": "{{55.body.entries[].id}}", "CSV File ID": "{{28.id}}" } }, "metadata": { "designer": { "x": 5072, "y": -41, "name": "Save to data store" }, "restore": { "parameters": { "datastore": { "nested": [ { "name": "key", "label": "Key", "type": "text", "help": "You assign a unique key that can be used later to retrieve the record. If you leave this field blank, a key will be generated." }, { "name": "overwrite", "label": "Overwrite an existing record", "type": "boolean", "help": "This option is only effective if you specify a custom key under which the record shall be saved.", "required": true, "default": false }, { "name": "data", "type": "collection", "label": "Record", "spec": [ { "name": "Employee name", "label": null, "type": "text", "required": false, "multiline": false }, { "name": "WordPress ID", "label": null, "type": "text", "required": false, "multiline": false }, { "name": "Gravity Form Entry ID", "label": null, "type": "number", "required": false }, { "name": "CSV File ID", "label": null, "type": "text", "required": false, "multiline": false } ] } ], "label": "Expenses to be created" } }, "expect": { "overwrite": { "mode": "chose" } } }, "parameters": [ { "name": "datastore", "type": "datastore", "label": "Data store", "required": true } ], "expect": [ { "name": "key", "type": "text", "label": "Key" }, { "name": "overwrite", "type": "boolean", "label": "Overwrite an existing record", "required": true }, { "name": "data", "type": "collection", "label": "Record", "spec": [ { "name": "Employee name", "type": "text", "label": null }, { "name": "WordPress ID", "type": "text", "label": null }, { "name": "Gravity Form Entry ID", "type": "number", "label": null }, { "name": "CSV File ID", "type": "text", "label": null } ] } ] } } ] }, { "flow": [ { "id": 118, "module": "json:CreateJSON", "version": 1, "parameters": { "type": 11809, "space": "" }, "filter": { "name": "Not pending", "conditions": [ [ { "a": "{{55.body.entries[].workflow_step_status_495}}", "o": "text:notequal:ci", "b": "pending" } ] ] }, "mapper": { "Employee name": "{{50.firstName}} {{50.lastName}}", "WordPress ID": "{{50.id}}", "Gravity Form Entry ID": "{{55.body.entries[].id}}", "CSV File ID": "{{28.id}}" }, "metadata": { "designer": { "x": 4933, "y": 295, "name": "JSON to add a submission" }, "restore": { "parameters": { "type": { "nested": [ { "name": "Employee name", "label": null, "type": "text", "default": null, "required": false, "multiline": false }, { "name": "WordPress ID", "label": null, "type": "text", "default": null, "required": false, "multiline": false }, { "name": "Gravity Form Entry ID", "label": null, "type": "number", "default": null, "required": false }, { "name": "CSV File ID", "label": null, "type": "text", "default": null, "required": false, "multiline": false } ], "label": "AMEX Import Tool" }, "space": { "label": "Empty" } } }, "parameters": [ { "name": "type", "type": "udt", "label": "Data structure", "required": true }, { "name": "space", "type": "select", "label": "Indentation", "validate": { "enum": [ "tab", "2", "4" ] } } ], "expect": [ { "name": "Employee name", "type": "text", "label": null }, { "name": "WordPress ID", "type": "text", "label": null }, { "name": "Gravity Form Entry ID", "type": "number", "label": null }, { "name": "CSV File ID", "type": "text", "label": null } ] } }, { "id": 119, "module": "gravity-forms:makeApiCall", "version": 1, "parameters": { "__IMTCONN__": 151742 }, "mapper": { "url": "forms/47/submissions", "body": "{{118.json}}", "method": "POST", "headers": [ { "key": "Content-Type", "value": "application/json" } ] }, "metadata": { "designer": { "x": 5242, "y": 304, "name": "Submit a form entry (full)" }, "restore": { "expect": { "qs": { "mode": "chose" }, "method": { "mode": "chose", "label": "POST" }, "headers": { "mode": "chose", "items": [ null ] } }, "parameters": { "__IMTCONN__": { "data": { "scoped": "true", "connection": "gravity-forms2" }, "label": "My Gravity Forms Basic connection" } } }, "parameters": [ { "name": "__IMTCONN__", "type": "account:gravity-forms2", "label": "Connection", "required": true } ], "expect": [ { "name": "url", "type": "text", "label": "URL", "required": true }, { "name": "method", "type": "select", "label": "Method", "required": true, "validate": { "enum": [ "GET", "POST", "PUT", "PATCH", "DELETE" ] } }, { "name": "headers", "spec": [ { "name": "key", "type": "text", "label": "Key" }, { "name": "value", "type": "text", "label": "Value" } ], "type": "array", "label": "Headers" }, { "name": "qs", "spec": [ { "name": "key", "type": "text", "label": "Key" }, { "name": "value", "type": "text", "label": "Value" } ], "type": "array", "label": "Query String" }, { "name": "body", "type": "any", "label": "Body" } ] } }, { "id": 120, "module": "gravity-forms:makeApiCall", "version": 1, "parameters": { "__IMTCONN__": 151742 }, "mapper": { "url": "entries?form_ids[0]=47", "method": "GET", "headers": [ { "key": "Content-Type", "value": "application/json" } ] }, "metadata": { "designer": { "x": 5555, "y": 298, "name": "Get latest entry" }, "restore": { "expect": { "qs": { "mode": "chose" }, "method": { "mode": "chose", "label": "GET" }, "headers": { "mode": "chose", "items": [ null ] } }, "parameters": { "__IMTCONN__": { "data": { "scoped": "true", "connection": "gravity-forms2" }, "label": "My Gravity Forms Basic connection" } } }, "parameters": [ { "name": "__IMTCONN__", "type": "account:gravity-forms2", "label": "Connection", "required": true } ], "expect": [ { "name": "url", "type": "text", "label": "URL", "required": true }, { "name": "method", "type": "select", "label": "Method", "required": true, "validate": { "enum": [ "GET", "POST", "PUT", "PATCH", "DELETE" ] } }, { "name": "headers", "spec": [ { "name": "key", "type": "text", "label": "Key" }, { "name": "value", "type": "text", "label": "Value" } ], "type": "array", "label": "Headers" }, { "name": "qs", "spec": [ { "name": "key", "type": "text", "label": "Key" }, { "name": "value", "type": "text", "label": "Value" } ], "type": "array", "label": "Query String" }, { "name": "body", "type": "any", "label": "Body" } ] } }, { "id": 108, "module": "datastore:AddRecord", "version": 1, "parameters": { "datastore": 4092 }, "mapper": { "key": "", "overwrite": false, "data": { "Employee name": "{{50.firstName}} {{50.lastName}}", "WordPress ID": "{{50.id}}", "Gravity Form Entry ID": "{{55.body.entries[].id}}", "CSV File ID": "{{28.id}}" } }, "metadata": { "designer": { "x": 5848, "y": 290, "name": "Save to data store" }, "restore": { "parameters": { "datastore": { "nested": [ { "name": "key", "label": "Key", "type": "text", "help": "You assign a unique key that can be used later to retrieve the record. If you leave this field blank, a key will be generated." }, { "name": "overwrite", "label": "Overwrite an existing record", "type": "boolean", "help": "This option is only effective if you specify a custom key under which the record shall be saved.", "required": true, "default": false }, { "name": "data", "type": "collection", "label": "Record", "spec": [ { "name": "Employee name", "label": null, "type": "text", "required": false, "multiline": false }, { "name": "WordPress ID", "label": null, "type": "text", "required": false, "multiline": false }, { "name": "Gravity Form Entry ID", "label": null, "type": "number", "required": false }, { "name": "CSV File ID", "label": null, "type": "text", "required": false, "multiline": false } ] } ], "label": "Expenses to be created" } }, "expect": { "overwrite": { "mode": "chose" } } }, "parameters": [ { "name": "datastore", "type": "datastore", "label": "Data store", "required": true } ], "expect": [ { "name": "key", "type": "text", "label": "Key" }, { "name": "overwrite", "type": "boolean", "label": "Overwrite an existing record", "required": true }, { "name": "data", "type": "collection", "label": "Record", "spec": [ { "name": "Employee name", "type": "text", "label": null }, { "name": "WordPress ID", "type": "text", "label": null }, { "name": "Gravity Form Entry ID", "type": "number", "label": null }, { "name": "CSV File ID", "type": "text", "label": null } ] } ] } } ] } ] } ] }, { "flow": [ { "id": 132, "module": "datastore:AddRecord", "version": 1, "parameters": { "datastore": 4092 }, "filter": { "name": "No user found", "conditions": [ [ { "a": "{{50.`__IMTLENGTH__`}}", "b": "0", "o": "number:equal" } ] ] }, "mapper": { "key": "", "data": { "CSV File ID": "", "WordPress ID": "", "Employee name": "INVALID RECORD", "Gravity Form Entry ID": "" }, "overwrite": false }, "metadata": { "designer": { "x": 4287, "y": 612, "name": "Save to data store (invalid record)" }, "restore": { "expect": { "overwrite": { "mode": "chose" } }, "parameters": { "datastore": { "label": "Expenses to be created", "nested": [ { "help": "You assign a unique key that can be used later to retrieve the record. If you leave this field blank, a key will be generated.", "name": "key", "type": "text", "label": "Key" }, { "help": "This option is only effective if you specify a custom key under which the record shall be saved.", "name": "overwrite", "type": "boolean", "label": "Overwrite an existing record", "default": false, "required": true }, { "name": "data", "spec": [ { "name": "Employee name", "type": "text", "label": null, "required": false, "multiline": false }, { "name": "WordPress ID", "type": "text", "label": null, "required": false, "multiline": false }, { "name": "Gravity Form Entry ID", "type": "number", "label": null, "required": false }, { "name": "CSV File ID", "type": "text", "label": null, "required": false, "multiline": false } ], "type": "collection", "label": "Record" } ] } } }, "parameters": [ { "name": "datastore", "type": "datastore", "label": "Data store", "required": true } ], "expect": [ { "name": "key", "type": "text", "label": "Key" }, { "name": "overwrite", "type": "boolean", "label": "Overwrite an existing record", "required": true }, { "name": "data", "spec": [ { "name": "Employee name", "type": "text", "label": null }, { "name": "WordPress ID", "type": "text", "label": null }, { "name": "Gravity Form Entry ID", "type": "number", "label": null }, { "name": "CSV File ID", "type": "text", "label": null } ], "type": "collection", "label": "Record" } ] } } ] } ] } ], "metadata": { "instant": false, "version": 1, "scenario": { "roundtrips": 1, "maxErrors": 3, "autoCommit": false, "autoCommitTriggerLast": true, "sequential": false, "confidential": false, "dataloss": false, "dlq": false }, "designer": { "orphans": [], "notes": [ { "id": 143, "text": "", "filter": true }, { "id": 64, "text": "", "filter": true }, { "id": 10, "text": "The first search through the Master Permissions List is to check whether the user has a record there. If yes, then this will be a renewal request (1 is returned). If no record (bundle) is found, then it will a first time request (0 is returned).", "filter": false } ] }, "zone": "eu1.make.com" } }