Solution : When the import or export side system in downtime. The system cannot get the connection to perform their operations. So, it displays connection error in Celigo. This is an auto solved problem. It resolves when we run again the flow.
Category: Celigo
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
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
Import NetSuite Line Items
A Sales Order has a one-to-many relationship with Items. It is like a sublist, or a list of lines within a record. HOW TO MAP LINE ITEMS You can access line items using the sublist name. In import mapping, each sublist is populated in the format Sublist Name : Field Name, such as Items : Department. Select… Continue reading Import NetSuite Line Items
CELIGO
Celigo is an integrator platform. An iPaaS, or integration Platform as a Service, is a platform that standardizes how applications are integrated into an organization, making it easier to automate business processes and share data across applications. By leveraging iPaaS technologies, growing companies can eliminate manual processes and reduce dependency on spreadsheets and email, while… Continue reading 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
Error: A contact record with this name already exists. Every contact record must have a unique name
//Info: NFCC-25 This was an error that occurred while importing the referral file into Netsuite via the Celigo integration.Mapping was performed on contact record fields such as Name, Address, External ID, and so on. We later discovered that the External Id we were attempting to map to the contact record had already been used in… Continue reading Error: A contact record with this name already exists. Every contact record must have a unique name
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
Celigo Error: Invalid country reference key
This error is generated within a unique circumstance: The flow was developed for an earlier NetSuite bundle that had the Address subrecord set by default. This Address as a subrecord default import setting was later removed in a bundle update. The sandbox or production environment’s bundle was upgraded to the latest version. With the current… Continue reading Celigo Error: Invalid country reference key