What is a Dynamic Formula?
A dynamic formula in iPaaS.com is a C# formula designed to assist in mapping or transforming data as it moves to or from the platform.
iPaaS.com's mapping utilizes Eval Expression, a dynamic code interpreter. This allows users to create custom logic for field mappings, enabling more complex programmatic operations. For example, if you need to prefix a website's SKU with WEB, you can define the mapping for the website's SKU as "WEB" + SKU.
NOTE: iPaaS.com has three levels of functions available to you:
Core C# functions
iPaaS.com functions
Integration-specific functions which are only available on an integration
Use Cases
When dealing with parent/child mapping collections (such as products and their associated units), dynamic formulas provide flexibility. You can reference data from the parent object or access children from the parent. For instance, you can define the price of a unit using a field from its parent. Conversely, you can calculate a quantity field on the parent by referencing the Inventory Children object.
Other use cases include:
Using a dynamic formula to build out a JSON object that can be passed into a formula or function.
Build out an entire category tree with a formula.
Validate multiple conditions in combinations and then write multiple if/then statements.
Reference another field and then pull out contents to create an if/then statement based on that, for example, using a regex statement on another field to use that field's data.
Where Dynamic Formulas Are Used
Dynamic formulas can be used in the following areas:
Mapping and error filters: when adding or editing filters
Mappings and lookup translations: when adding or editing mappings
Export operations: when exporting mappings and mapping filters
Implementation Guide
For new mapping or error filters:
See Subscription Configuration: Manage Mappings.
For lookup translations:
See Subscription Configuration: Manage Translations.
For export mapping and mapping filters:
See Export Mappings.
Learning Resources
iPaaS.com uses a C# based interpreter for dynamic formulas. To get started with C# syntax, we recommend the W3Schools C# Tutorial. Focus on these essential sections: Syntax, Variables, Data Types, Operators, Strings, and if...else statements.