Author: Magi Thomas

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

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

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

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”  }

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

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