Omnistudio Formulas and Functions

Use operators and functions to create formulas for Omnistudio Data Mappers and Integration Procedures.

Use data types and operators to represent values and simple expressions. Include functions to perform conditional operations and to evaluate and manipulate numbers, dates and times, strings, lists and arrays, and JSON objects.

• Supported Data Mapper and Integration Procedure Data Types
  Understand data types to determine the kinds of values you can use with operators and pass to functions. Data types also define the kinds of values that functions can return. Topics related to data types include constants that have special meaning and error cases that you can encounter.
• Supported Data Mapper and Integration Procedure Operators
  Use operators to develop more complex formulas for Omnistudio Data Mappers and Integration Procedures. For example, operators can perform logical, comparison, or mathematical operations on values in expressions. Operators are evaluated according to a strict precedence.
• Supported Data Mapper and Integration Procedure Functions
  Use functions to evaluate and manipulate data in formulas for Omnistudio Data Mappers and Integration Procedures. For example, functions can perform conditional operations that take different actions depending on the values you pass them. They can invoke queries and other functions, and they can operate on numbers, dates and times, strings, lists and arrays, and JSON objects.
• Sample Apex Code for Custom Functions
  Develop Apex classes to implement custom functions for use with Omnistudio Data Mappers and Integration Procedures. A sample Apex class implements three methods that can be called as custom functions in Omnistudio formulas. The class includes code that passes a list to a custom function.