Author: Magi Thomas

We create lookup in Celigo for get the line item details. Each line item stored in array format. Using the following code, we can read the line items in runtime using each loop. “lines”: [     {{#each record.lineDetailsLookup}}     {       “productID”:”{{this.Item_Name}}”,       “requestedQuantity”:”{{this.Item_Qty}}”     }{{#unless @last}},{{else}}{{/unless}}    {{/each}}     ]

Step 1: Installed the Bundle integrator.io Step 2 : Click the connection option and enter the details : Name ,Authorization type and Account ID Step 3 : Click save and authorize button Step 4 : Click Allow button .It automatically create the connection to NetSuite

Sub records hold information about a parent record and are meaningful only within that context. The sub record must be created, edited, removed, or viewed from its standard NetSuite record. These  sub records must be configured and mapped  in integrator.io. You can map sub records imported into NetSuite natively through integrator.io. When transformed, the JSON… Continue reading NetSuite sub records to JSON

Flow Builder allows you to create and customize a flow to transfer data from one platform to another. You can use Flow Builder to export and combine data from multiple applications, and import data into multiple applications. Building a simple flow requires a minimum of three steps: Choose source and destination applications – Select the applications you’re… Continue reading Custom flow in Celigo

The reports are separate for integrator.io Sandbox and Production environments. To create a Sandbox report, for example, you must first be working in your Sandbox environment. Select Tools > Reports from the left navigation menu. In the header row of the Flow events report results list, click + Run report. In the resulting Run report pane, customize the required settings for your report: Integration – All… Continue reading Create a report of flow events

A ‘Reports’  option in the ‘Tools’ menu allows you to produce a list of all events that have run through one or more flows for a specified time period. Each report is available for download for up to 30 days from the creation date. To make it easier to find a report, click the ‘Filter’ button where available on… Continue reading View a report of flow events

All Celigo flows use the corn style of scheduling. Cron schedules have five positions referenced by five asterisks: * * * * * Minute (0-59) Hour (0-23) Day of the month (1-31) Month (1-12) Day of the week (0-6) Position Description Minute The first position is for the minute. This is in 15 minute intervals… Continue reading Cron Schedule in Celigo

1.Click on the calendar icon against the flow.  2.Pick the schedule as per your needs. . Presets can be used for the average user with default options. . For more specific scheduling, corn expression can also be set.   . Save and close

Handlebars is a simple templating language. Handlebars templates look like regular text with embedded handlebars expressions. Code that appears between the curly braces {{field}} are known as “expressions” in Handlebars. Handlebars expressions may be used for: Mapping Export and Import application fields; Performing dynamic arithmetic calculations on the values being exported; Performing dynamic encoding and… Continue reading Handlebars in Celigo

The following export types are available to help support common integration patterns: All: Exports all data, always. Delta: Exports data changed since the last time the flow ran. If you want to reference the lastExportDateTime or the currentExportDateTime field without using a Delta export type, you can create the field manually.  Once: Exports data that has not already been… Continue reading Export Types of Integrator.io