Composite method imports records depending on the existence or absence of records in the destination application. Composite requests require you to define how to create new records, identify existing records, and update existing records. Different options available in Composite method are: Create new records & update existing records: dynamically create new records or update existing… Continue reading Composite Method in HTTP import
Category: Celigo
Invalid JSON error when using a handlebars expression
Review the retry data returning the invalid JSON error. Sometimes values returned can contain certain characters, such as quotation marks (“), which, when inserting them via a handlebar into your HTTP request body, causes the JSON to be invalid. Use the jsonSerialize handlebar function in your HTTP request body on the field in question. For example, if… Continue reading Invalid JSON error when using a handlebars expression
Dollar sign notation ($.company) in field mapping?
Q. In my integration, I see references to elements within a $ object in the import mapping, like the following: {{#if $.company}} {{$.company}} {{else}} {{$.first_name}} {{$.last_name}}{{/if}} What does $ mean here? I looked for a transform and elsewhere to identify it, but it doesn’t seem to appear before the import. A. NetSuite uses $ as the equivalent of the familiar JavaScript keyword this, in… Continue reading Dollar sign notation ($.company) in field mapping?
Set up an FTP connection in Celigo
File Transfer Protocol (FTP) is a standard communication protocol used for the transfer of files from a server to an application or a computer. You can grab existing JSON, XML, CSV, and other files to upload them into a second application (such as Amazon Seller Central) or add files to the server from an application.… Continue reading Set up an FTP connection in Celigo
Upgrade Integration App Edition
The editions available for pre-built Shopify-NetSuite Integration App are: Starter Standard Premium The set of flows available in each edition are different. In order to upgrade from starter to standard or premium edition of the integration app, you can click the “Request Upgrade” option available under the Subscription section on the Integration App settings page.… Continue reading Upgrade Integration App Edition
Manually Sync Amazon settlement report to NetSuite
There are chances that the Settlement report got missed to be processed by the Celigo flow. Then we have to upload the settlement report manually and run the flow which will create the settlement transactions in NetSuite. Login into the Amazon seller central account and download the settlement report in Flat file v2 format. In… Continue reading Manually Sync Amazon settlement report to NetSuite
Error: Numeric instance is lower than the required minimum (minimum: 1, found: 0)
Code: “requestedQuantity”: {{#if this. Item_Qty}}{{{this.Item_Qty}}}{{else}}0{{/if}} Using the above code , Celigo tried to assign 0 to the ‘requestedQuantity’ in the Client system. But, ‘requestedQuantity’ field set as minimum required ‘1’ quantity. So, it shows an error. Error: { “errorCode”: “311”, “errorDescription”: [ “[Path ‘/lines/5/requestedQuantity’] Numeric instance is lower than the required minimum (minimum:… Continue reading Error: Numeric instance is lower than the required minimum (minimum: 1, found: 0)
Delete LastPass Credentials
Use the following steps to delete your LastPass credentials for a specific website: Open the LastPass folder Celigo shared with you (Company Name). Right-click on the site you want to remove from LastPass. Click Delete. This will move the site to the LastPass Deleted Items folder. Click Advanced Options in the left navigation menu, and click View deleted items. This opens… Continue reading Delete LastPass Credentials
How to share credentials with Celigo using LastPass
To access LastPass through the web portal, navigate to the LastPass home page at lastpass.com. When using the web portal in your first-time sharing credentials through LastPass, you may need to generate sharing keys in order to activate account sharing. The following steps explain how to generate access keys, which you will need to do only… Continue reading How to share credentials with Celigo using LastPass
Find active tickets in Celigo
We can find your recently submitted support tickets by logging into Celigo’s Help Center. Select your profile avatar. Select My Activities. Then we can get the details of the submit tickets