When creating the JSON files the JSON data is enclosed in square brackets. The opening and closing square brackets are the defining characteristics of a JSON row structure. When we group the export data, the data passes through the rest of the flow in row structure. These square brackets can be removed by using the below… Continue reading Exclude the JSON row structure from files
Author: Aishwarya M J
Handlebar syntax for curly braces
{{ }} – Handlebars double-braces will URL encode characters that are able to be URL encoded. The double-braces themselves do not display in output (escaped). For example, you could use double-braces for an HTTP URI. This would automatically perform the URL encoding for any escaped characters (such as <, > , or space). In the… Continue reading Handlebar syntax for curly braces
Lookup Caches in Celigo
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
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
Roles and Permissions for Estimated Landed Cost
To enable estimated landed cost for roles: Go to Setup > Users/Roles > Manage Roles. On the role record, check the Enable Estimated Landed Cost box: By default, the prebuilt custom forms and records for Estimated Landed Cost are enabled for the following standard roles: CEO and CFO Accountant and Accountant (Reviewer) Warehouse Manager 3. To enable other… Continue reading Roles and Permissions for Estimated Landed Cost
Permission to Access Inbound Shipment on a Custom Role
Scenario User with custom role is unable to access Inbound Shipment. Solution Navigate to Setup > Users/Roles > Manage Roles Custom Role: Click Edit Click Permissions tab Click Lists subtab Permission: Select Inbound Shipment Level: Select Full Click Add Click Save Note: Changes apply after a user with the role logs out, then logs back in.
Create self-signed SSL certificates for AS2 connections
Use the following steps to generate a self-signed SSL certificate using the OpenSSL utility: Run the below OpenSSL command to generate your private key and public certificate. openssl req -newkey rsa:2048 -nodes -keyout domain.key -x509 -days 365 -out domain.cer You will be prompted to add identifying information about your organization to the certificate. Since a self-signed… Continue reading Create self-signed SSL certificates for AS2 connections
How to Create a Standalone Copy of a Non-Standalone Invoice
Scenario When generating a copy of an Invoice created from a Sales Order, it would function as if it was also created from the Sales order. The copied Invoice would be linked to the Sales Order and the GL Impact would not affect the Inventory Asset account. Users have the option to create a completely… Continue reading How to Create a Standalone Copy of a Non-Standalone Invoice
Integration Lifecycle Management (ILM) in Celigo
Integration Lifecycle Management features help you build and manage your integration’s software development lifecycle by supporting version control, release management, and git-style features to push, merge and commit changes. You can consider these guidelines when planning your integration management. Build or update an integration, preferably in sandbox environment. Create a clone to test changes to… Continue reading Integration Lifecycle Management (ILM) in Celigo
NetSuite – EDI for B2B Manager Integration
EDI is a platform that modernizes traditional B2B EDI data integrations by providing a standardized REST/JSON API endpoint for EDI transactions. It helps suppliers sell products wholesale. When these wholesalers (trading partners) create purchase orders, EDI converts the EDI X12/EDIFACT format to a JSON canonical structure and integrates it with NetSuite. The following built-in flows… Continue reading NetSuite – EDI for B2B Manager Integration