Results mapping

Results mapping is similar to response mapping, but instead of returning the response after an import, results mapping allows you to merge the resulting records returned by a lookup step in your flow back into the source record. Click + on the lookup step, and click the mappings button to the right. The field mappings you define… Continue reading Results mapping

Published
Categorized as Celigo

How can debug a flow in Celigo

Before you can review the debug logs, you must turn on the debugger for your flow step. Perform the following actions to start collecting debug logs for a flow step. Open the flow step you want to debug. Click View debug logs in the upper right corner of the flow step. Click Start debug to turn on the debugger.… Continue reading How can debug a flow in Celigo

Published
Categorized as Celigo

Merging Fields using transformation in Celigo

Fields may be merged , creating a list of values from the arrays in the record. In the example below, the items 1,2,3 and the prices 10, 20, 30 have been transformed into a merged record of items and their relative prices Pre-Transform Transform Mappings Post-Transform {          “itemsNames”: [“item1”,     “item2”, “item3”],         “prices”:… Continue reading Merging Fields using transformation in Celigo

Published
Categorized as Celigo

How get the HTTP response and Parsed Output in Import

In Import ,change the toggle option ‘Preview’ to ‘Send’ and click the Send option .Then we get the HTTP response in XML format(If HTTP request is XML format) and Parsed Output in JSON format

Published
Categorized as Celigo

How we can apply a transform In Celigo

Use the following steps to apply a transform to a flow step. In Flow Builder, click + to select the transform icon. The Define transformation advanced field editor (AFE) opens. In the Rules section of the AFE, use the extract drop-down menu to select a field from your export data, then in the generate text box, enter the field name that you want… Continue reading How we can apply a transform In Celigo

Published
Categorized as Celigo

Delete Unwanted Fields In Celigo Using Transformation

The following example demonstrates how to remove unwanted fields from an object. Here, the age and address fields have been removed for the record. Pre-Transform Transform Mappings Post-Transform {     “name”: “Estrella”,     “age”: 50,     “Address”: “123 Anywhere    St.”  } {     “name”: “Estrella”  }

Published
Categorized as Celigo

Convert XML data of HTTP response to JSON format in Celigo

In celigo , From Pitney Bows provide the data in XML format .We need to convert this data to JSON format to store NetSuite. If HTTP Response like : <response><products> We store “response/products ” in the ‘Path to records in HTTP response body’ of Non Standard API response patterns tab. Select XML in the ‘Override… Continue reading Convert XML data of HTTP response to JSON format in Celigo