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
Author: Magi Thomas
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
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
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
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
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” }
How to hard-code values in Celigo
In Celigo ,we can give the direct values to mapping field other than saved search values is known as hard code . Firstly , click the settings icon of the mapping field. Then click the Hard-Coded option in the Field mapping Type. Enter the value in the textbox of Enter default value. Then save it… Continue reading How to hard-code values in Celigo
Passing the data in HTTP response of XML format to the NetSuite– Celigo
After the import step go to the response mapping and create a mapping for the _json field to response field as the following The HTTP response looks like the following Then in the field mapping add the path to this value in HTTP response and map it with the field in which we need to… Continue reading Passing the data in HTTP response of XML format to the NetSuite– 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