When exporting data from NetSuite, integrator.io provides four options for the Export type All – Export all data returned in the search each time the export is run Delta – Export all data with a date/time value for the selected field that is greater than the last time the data flow was run Once – Export any data that… Continue reading Export types in Celigo
Author: Nancy Enasu
Field mapping type indicators
Letters next to mapped values indicate the field mapping type. none – Standard: Product is a standard mapping value. L – Lookup: Country is a lookup mapping value. M – Multi-field: Transaction_date is a multi-field mapping value. H – Hard-coded: City is a hard-coded mapping value
Add condition on advanced PDF/HTML template
Apply this code to use Else if condition on advanced PDF template
Hard-coded field mapping
Use this setting if you prefer to have the same value written to the imported data field for every record, regardless of the exported value. Use empty string as hard-coded value: Populates an empty string (”) into the field Use null as hard-coded value: Populates a null data type into the field Use custom value:… Continue reading Hard-coded field mapping
Create flow in Celigo
Select the tile to create the flow Click on create flow Provide a name for the flow Click on source to add export and add the required fields , then click Next 5. Add name, export type, resource, API endpoints and Save the export 6. Click on destination and add connection and click Next 7.… Continue reading Create flow in Celigo
Date/Time format in Celigo
date/time formats help you to select or enter the appropriate format. Date/Time format Example YYYY-MM-DDTHH:mm:ssZ 2018-04-01T15:20:15-07:00 YYYY-MM-DDTHH:mm:ss 2018-04-01T15:20:15 YYYY-MM-DDTHH:mm:ss[Z] 2018-04-01T15:20:15Z YYYY-MM-DDTHH:mm:ss.SSSZZ 2018-04-01T15:20:15.000-0700 YYYY-MM-DDTHH:mm:ss.SSSSZ 2018-04-01T15:20:15.000-07:00 YYYY-MM-DD HH:mm:ss 2018-04-01 15:20:15
Set address using multi-field in Celigo mapping
To set Address : Addressee using multi-field in celigo mapping , Under setting , select field mapping type as multi-field use the expression:
Handlebars custom helper – replace
Replaces all the occurrences of the specified letter in a string with another letter. Ex: Template – {{replace cases “&” “and”}} Context – {“cases”: “these & those & some other cases”} Output – these and those and some other cases Ex: Template – {{replace $item[*].price “,” “”}} Context – 12,500 Output – 12500
Custom field with decimal number type
To create custom field with decimal number type, go to Customization > List ,Record & fields > Transaction Line fields Provide custom field name and id Type as Decimal Number Applies to – Sales item Add other required fields and save NB: Under Display, when apply formatting is checked, the numbers above 1000 appears with… Continue reading Custom field with decimal number type
Create line level custom location
To create line level custom location in sales order , follow the steps Customization > List/Records&Fields > Transaction line fields Add name , ID for the custom field Applies to – Sales Item Add required type for the field Then save it Open the Sales order to view the created location