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
Category: Celigo
Celigo – HTTP Sucess response to Source in Webhook Export
Go to the Advanced Section in the webhook export where we can see the following fields. Override HTTP status code for the success responses: integrator.io returns a 204 HTTP status code for all successful webhook requests by default. Select an alternate successful HTTP status code for the listener. Override HTTP response body for success responses.… Continue reading Celigo – HTTP Sucess response to Source in Webhook Export
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
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
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
Ship bob to NetSuite Integration using Celigo
Requirement The requirement is to integrate the 3PL Ship Bob with NetSuite using Celigo. Our Solution Prerequisites NetSuite account (Sandbox and Production) with administrator permissions. Access to Celigo integrator.io Access to Ship Bob (Sandbox and Production) Description of the task A.Setup Connection NetSuite Connection: The pre-built NetSuite connector in Celigo can be used to create… Continue reading Ship bob to NetSuite Integration using 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
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
Back up an integration with a snapshot
You can create snapshots when you’re making changes to an integration. A snapshot is a copy of an integration at a certain point in time. Consider it a backup of your integration that you can revert to if you run into issues. You might want to create a snapshot in the following scenarios: When you’re handing… Continue reading Back up an integration with a snapshot
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