You can append _PARENT before any fields that you need to reference outside the Path to many that you set in your import. Note that ALL fields referenced anywhere in the import (mappings, import configuration, scripts, etc.) will be affected when One to many is set to Yes (advanced). For example, let’s say your import data looks like this: { “exampleField”: “value”,… Continue reading Reference fields outside the “Path to many” in import settings
Category: Celigo
Error in NetSuite Item to Magento Product Add/Update flow
An error message is displayed while running the NetSuite item to Magento Product Add/Update flow as shown. {“message”:”Error occurred during \”custom_attributes\” processing.Attribute \”category_ids\” has invalid value.The \”string\”value’s type is invalid.The \”int[]\” type was expected.Verify and try again.”} This can be resolved by adding the category id in the result tab of the saved search. Map… Continue reading Error in NetSuite Item to Magento Product Add/Update flow
Change the data type of the data in Celigo
We can change the data type of data in the mapping side of the Celigo. First, Click the setting of the mapping data field then assign the data type to data (Desired data type)
SuiteScript hook
A flow in integrator.io is mainly composed of sources and destinations. One type of source, an export, fetches data from the source applications, then breaks it into smaller pages before passing it into the next step in the flow, such as an import. Imports process the pages coming in, then send the data into the target… Continue reading SuiteScript hook
MySQL DB and Kafka DB
MySQL DB – can store passbook data, user wallet transactions, and the wallet balance of users using tables and relationships. Passbook Data: You can create a table called “passbook” to store passbook-related information. Each row in this table represents an entry in the passbook for a specific transaction or event. User Wallet Transactions: To track… Continue reading MySQL DB and Kafka DB
error: “Failed to Export Item. Please select at least one website for this item.”
This error is raised in the Export preview of NetSuite Item to Magento Product Add/Update flow. Solution: Add custom label for website properly in the result tab of the corresponding saved search as it is case sensitive.
Debug Connection
Click on the Connections option at the bottom Then under the Actions Select Debug connection
Mongo DB
Mongo DB – platform that helps to store, retrieve, manage unstructured or semi structured data in JSON format called BSON (Binary JSON). Users: You can create a collection called “users” to store user-related information. Each user can be represented as a document within this collection. Transactions: For tracking transactions, you can create a separate collection… Continue reading Mongo DB
Create a dynamic lookup in Celigo
Click the mapping button in the center of the import step. The Edit mapping window opens. Click the Settings button next to the field you are mapping. The Settings window opens. In the Field mapping type section, click Lookup. Select Dynamic search in the Options section. Enter the Relative URI. Select an HTTP method. Enter the Resource identifier path. Enter a unique value in the Name field so that you can identify… Continue reading Create a dynamic lookup in Celigo
Create multiple item fulfilment in the NetSuite using Celigo
Create export for read the sales order details from the NetSuite and create lookup to get the shipment details from the shipbob(third party). In the response mapping of the lookup, assign the data to lineDetailsLookup In the Import side, click the one to many option yes and mention the response mapping in the path field… Continue reading Create multiple item fulfilment in the NetSuite using Celigo