Adds all numeric values (integers, floats, or decimals). Parameters can either be a field that returns a number value or a hard-coded number value. {{add number1 number2 ….}} number1: Numeric field or hard-coded integer, float, or decimal. number2: Numeric field or hard-coded integer, float, or decimal. Examples: Template: {{add “2” “5” “2”}} output: 9 Template:… Continue reading Handlebar – Add function
Category: Celigo
Provide mock response data for imports
You can enter mock response data when configuring imports instead of executing a call to retrieve live response data from an import step. The mock response data that you provide for an import applies only to that specific import, including its components such as mapping, transformation, and hooks. If no mock data has been added… Continue reading Provide mock response data for imports
Required permissions for user role in Salesforce
Each Salesforce user will only be able to access the Salesforce record types for which adequate permissions have been granted to the associated user role. Not having adequate role permissions could lead to unwanted errors when executing the data flows. Use the following steps to provide required permissions to a user in Salesforce: Login to… Continue reading Required permissions for user role in Salesforce
Salesforce-NetSuite IA (IO)
Problem: One thing I’ve wished wasn’t the case with the Integration Apps is all of the greyed-out options. In this case, I found a solution to my issue if I had access to the inbound/outbound filters, but I don’t in the IA because it is greyed out. The other issue, in this case, is the… Continue reading Salesforce-NetSuite IA (IO)
HOW TO: Generate NetSuite sales orders from Salesforce opportunities for only certain product families
To filter which opportunities generate sales orders: In Salesforce, open the Real Time Sync for the opportunity. Under the Related SObject Syncs section, search each SObject Sync for the OpportunityLineItem Open that OpportunityLineItem. In the Filter field, specify your filter. Here is an example for Product Group is not recurring
Using Javascript in Filter – Celigo
On the left pane, you can navigate to Scripts by way of “Resources -> Scripts”. Then on the Scripts page, you can create a new script, then choose insert function stub “filter”. When you have created and saved the filter, you can choose this filter script when you are defining filter using javascript option. Here… Continue reading Using Javascript in Filter – Celigo
Convert Date format in Mapping
Scenario: The date created value obtained form saved search is like 30 MAY, 2024 3:52:10 PM. However the value is being set to a system where the required date format is 30-05-2024. Solution: Apply the dateFormat handlebars in the mapping as follows to convert the format: {{dateFormat o/pformat date i/pformat timezone}} Here the o/p format… Continue reading Convert Date format in Mapping
How to Install and configure the Shopify payout reconciliation add-on?
PREREQUISITE: Ensure that you have a valid subscription license for the add-on. If you do not have a license, from your integration app, go to the Add-Ons section and click Contact Sales. You can install this add-on from the “Subscriptions” section of your Integration App. Before you set up the flow Before you run the flow,… Continue reading How to Install and configure the Shopify payout reconciliation add-on?
Celigo and different techniques in Celigo
Celigo is a prominent provider of integration solutions designed to streamline and automate business processes across various platforms. Specializing in Integration Platform as a Service (iPaaS), Celigo offers a suite of tools that enable organizations to connect their diverse applications, whether on-premises or in the cloud. The company’s flagship product, integrator.io, is a user-friendly, cloud-based… Continue reading Celigo and different techniques in Celigo
Fields missing in the NetSuite real time listener
Scenario: Few fields are missing in the real time export of NetSuite record. Solution: Edit the NetSuite listener. Check the field “Reload record before export”. When a record is saved in NetSuite there are certain fields that are not available until after the save completes, and the only way to export those fields in real-time… Continue reading Fields missing in the NetSuite real time listener