The new lookup caches functionality enables builders to create in-memory lookups that can be easily repurposed throughout their flows. With lookup caches, you can: Create in-memory lookups that can be reused across multiple flows. Load and maintain reference data manually or within flows through a new integrator.io API Store and retrieve data using a key-value pattern. Set… Continue reading Lookup Caches in Celigo
Tag: Celigo
Diff checker for Celigo AI responses
Diff Checker in Celigo’s AI Prompt Window, enables users to review changes quickly and efficiently. This feature highlights removed lines in red and added lines in green, similar to GitHub’s diff checker. Diff Checker is accessible within both the Flow-Builder and Playground views. The following editors are supported in both the Flow-Builder and Playground views: Handlebars… Continue reading Diff checker for Celigo AI responses
Celigo platform 2025.1.1 release notes
The January 2025.1.1 Release introduces significant advancements across the Celigo platform, reflecting our commitment to equip builders with innovative tools to create powerful workflows and integrations. With a focus on AI enhancements, connectivity improvements, platform upgrades, and marketplace advancements, this release scales automations and accelerates business efficiencies for builders. AI code assistant for GraphQL Ready to accelerate your use of GraphQL?… Continue reading Celigo platform 2025.1.1 release notes
Errors while converting special characters from JSON to EDI
Q: While performing a JSON to EDI conversion, I am unable to convert special characters and a “<” symbol appears as “<”. What is the workaround? A: You are requested to use {{{[ ]}}} in the Definition File while converting the JSON element to EDI. The following code snippet illustrates how to use {{{ }}} when… Continue reading Errors while converting special characters from JSON to EDI
NetSuite invoices to invoices (810)
An Account Receivables (AR) analyst of an eCommerce manufacturer/supplier wants invoices created in NetSuite against successfully shipped orders to sync directly to the EDI Source system and notified of the payment and records are closed. On a scheduled basis the flow gets the invoices from NetSuite since the last flow run. The flow creates an… Continue reading NetSuite invoices to invoices (810)
Purchase order change requests (860) to NetSuite sales orders (update)
On a scheduled basis, the flow gets the purchase order change request transactions from the source and updates the sales order in NetSuite. The flow looks for the purchase order details from the purchase order ID, trading partner, and ISAID fields. The flow only updates the purchase order details on the NetSuite sales order and… Continue reading Purchase order change requests (860) to NetSuite sales orders (update)
Understand the AS2 connection
Understand AS2 connections Before you begin To be able to create an integration with your trading partner through an AS2 connection, you will have to have traded the necessary info with them, like the certificates and IDs. You and your trading partner will also need to come to an agreement on which algorithms to use… Continue reading Understand the AS2 connection
PreMap hook to convert EDI JSON to objects in order to map
function preMap(options) { const result = options.data.map(function(record) { const errors = []; const formattedRecord = {}; // Existing mappings formattedRecord.syntaxIdentifier = record[“SYNTAX IDENTIFIER”] && record[“SYNTAX IDENTIFIER”][“Syntax identifier”] ? record[“SYNTAX IDENTIFIER”][“Syntax identifier”] : null; formattedRecord.syntaxVersionNumber = record[“SYNTAX IDENTIFIER”] && record[“SYNTAX IDENTIFIER”][“Syntax version number”] ? record[“SYNTAX IDENTIFIER”][“Syntax version number”] : null; formattedRecord.sender = record[“INTERCHANGE SENDER”] && record[“INTERCHANGE… Continue reading PreMap hook to convert EDI JSON to objects in order to map
File Definition Rule to parse NetSuite Invoice JSON to EDI format
{ “_id”: “66ebff0507368eaa45cc3eba”, “lastModified”: “2024-09-27T07:48:31.520Z”, “name”: “Samios”, “sandbox”: true, “description”: “Invoice”, “version”: “1”, “format”: “delimited/edifact”, “skipEmptyEndColDelimiter”: true, “delimited”: { “rowSuffix”: “‘”, “rowDelimiter”: “n”, “colDelimiter”: “+” }, “rules”: [ { “maxOccurrence”: 1, “required”: true, “skipRowSuffix”: true, “elements”: [ { “name”: “UNA”, “value”: “UNA:+.?” } ] }, { “maxOccurrence”: 2, “required”: true, “elements”: [ { “name”: “UNB”,… Continue reading File Definition Rule to parse NetSuite Invoice JSON to EDI format
Post Map in celigo
post map The post map hook is invoked on a page of records after the records are mapped from source to destination structures. This hook can be used to validate, update, or ignore records before they are submitted to the destination application. Changes made to source records in this hook will persist only for the… Continue reading Post Map in celigo