Category: Celigo

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

Each integrator.io connection has its own concurrency setting, which controls the maximum number of concurrent requests the connection can make. To view or edit your settings for a connection: Go to Connections, then expand the options under Actions. 2. Select the Edit connection pane. 3. Modify the Concurrency level by using the drop-down list. The concurrency level in integrator.io should match… Continue reading Set concurrency limits in integrator.io

We can append _PARENT before any fields that you need to reference outside the Path to many that you set in your import. Note that ALL fields referenced anywhere in the import (mappings, import configuration, scripts, etc.) will be affected when One to many is set to Yes (advanced). For example, let’s say your import data looks like this: { “exampleField”: “value”,… Continue reading How can I reference fields outside the “Path to many” in my import settings?

This feature allows you to identify existing records when importing records. It analyzes data files and datasets to identify similar or existing records in the destination application and react accordingly. You can use this for imports from relational databases and HTTP or REST APIs. Step A: Import your records Records are normally imported through create,… Continue reading Identify existing records when importing records

As a standard, integrator.io does not support lookup responses greater than 5 MB. However, there is an alternative solution for large single-record or unchanged datasets returned by a JSON lookup. This workaround is valid for use cases like retrieving all Project Ids from a source and then retrieving all the project details for a specific Project… Continue reading Can integrator.io handle a lookup response greater than 5MB

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

Transform Rules is an integrator.io feature that helps you transform your large Export or Import JSON/XML data to a much smaller JSON structure that is much more readable and easier to understand. You can use this feature to: flatten the complex JSON structure. provide meaningful field names. select a limited set of fields for processing… Continue reading Transformation Rules in Celigo