Handlebars in Celigo

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

Published
Categorized as Celigo

Export Types of Integrator.io

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

Published
Categorized as Celigo

Transformation Rules in Celigo

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

Published
Categorized as Celigo

How can convert data in JSON into XML in Celigo

To conversion, using this Syntax <tag> {{record. Fieldname}} </tag> For Example, JSON data: { “record”: { “id”: “259246”, “recordType”: “salesorder”, “Internal_ID”: “259246”, “Customer_Name”: “CUST0000004 Amjil Capital”, “Shipping_Address1”: “11400 Twigg Plave” } } Convert to XML: <?xml version=”1.0″ encoding=”UTF-8”?> <Orders apiKey=”b7e02d23fb3d4c13b7ceda9de5c0e59e”>     <brandIdentifier></brandIdentifier>     <Order orderID= {{record. Internal_ID}}>         <Warehouse id=”157″ />         <CustomerInfo>             <Company>… Continue reading How can convert data in JSON into XML in Celigo

Published
Categorized as Celigo

Suite Script Hook

Hooks are custom code (functions) that can run at different stages during the execution of a flow to modify the behavior of export and import processes. You can use a hook to run a stack or script in integrator.io, or you can use a Suite Script hook. To configure a Suite Script, you can create… Continue reading Suite Script Hook

Published
Categorized as Celigo

Establish connections in Celigo

Connections are established between the source and target applications before creating flows in integrator.io. A connection stores system credentials and other access information for the source or target application.  To establish a connection: Go to integrator.io. From the Resources menu, select Connections. Then, click + Create connection at the top right. Click the desired source application. 5.Provide a clear and… Continue reading Establish connections in Celigo

Published
Categorized as Celigo

Conversion of response path in Celigo

We can convert the HTTP response in celigo into different data type . It may be XML,JSON ,CSV . JSON Response path response.products.product XML Response Path response/products/product    

Published
Categorized as Celigo

Universal Connectors

Connections are established between the source and target applications before creating flows in integrator.io. A connection stores system credentials and other access information for the source or target application.  There are different type of universal connectors are available in Celigo. AS2 CONNECTIONS GRAPHQL REST FTP HTTP WRAPPER

Published
Categorized as Celigo

Map fields into source to destination

 There are three types of mapping: import, results, and response. Mapping data defines how your records are compared, merged, or transformed from one application to another. Import Mapping  :   defines how your source data relates to your import destination record data. You can also use Mapper 2.0  to configure import mappings. This article only describes… Continue reading Map fields into source to destination

Published
Categorized as Celigo