Loading
Feature degradation | Gmail Email delivery failureRead More
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Supported Data Mapper and Integration Procedure Functions

            You are here:

            1. Salesforce Help
            2. Docs
            3. Omnistudio

            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.

            Note
            Note These functions work with Omnistudio Data Mappers and Integration Procedures. For information about functions that you can use with Omniscript formulas and aggregates, see Create a Formula or Aggregate in an Omniscript.

            Syntax conventions and a summary of recent changes follow the table.

            Omnistudio Functions

            Supported Functions

            Conditional Functions

            IF(expression, trueResult, falseResult)

            ISBLANK(expression)

            ISNOTBLANK(expression)

            Mathematical Functions

            ABS(expression)

            ROUND(expression, precision, direction)

            SQRT(expression)

            Date and Time Functions

            ADDDAY(date, days)

            ADDMONTH(date, months)

            ADDYEAR(date, years)

            AGE(birthDate)

            AGEON(birthDate, date)

            DATEDIFF(firstDate, secondDate)

            DATETIMETOUNIX(datetime)

            DAY(date)

            EOM(date)

            FORMATDATETIME(datetime, format, timezone)

            FORMATDATETIMEGMT(datetime, timezone, format)

            HOUR(time)

            MINUTE(time)

            MONTH(date)

            NOW(format)

            SECOND(time)

            TIMEDIFF(firstTime, secondTime)

            TODAY()

            UNIXTODATETIME(timestamp)

            YEAR(date)

            String Functions

            BASE64ENCODE(data)

            CONCAT(string...)

            JOIN(string..., token)

            MAXSTRING(string...)

            SPLIT(string, token)

            STRINGINDEXOF(string, substring)

            SUBSTRING(string, startIndex, endIndex)

            TOSTRING(data)

            List and Array Functions

            AVG(list)

            FILTER(LIST(list), condition)

            LIST(expression)

            LISTMERGE(mergeKey..., LIST(list)...)

            LISTMERGEPRIMARY(mergeKey..., LIST(list)...)

            LISTSIZE(list)

            MAPTOLIST(jsonObject)

            MAX(list)

            MIN(list...)

            SORTBY(LIST(list), key..., [:DSC])

            SUM(list)

            JSON Object Functions

            DESERIALIZE(jsonString)

            RESERIALIZE(jsonString)

            SERIALIZE(jsonObject)

            VALUELOOKUP(startNode, node...)

            Invocation Functions

            COUNTQUERY(query)

            FUNCTION(class, method, input...)

            GENERATEGLOBALKEY(prefix)

            QUERY(query)

            Omnistudio Function Syntax

            Many Omnistudio functions use these parameters and conventions:

            • expression refers to a single value or to a construct that contains variables, operators, and functions. The expression must resolve to the data type of the parameter.

            • value refers to a single value that matches the data type of the parameter.

            • data refers to multiple data types. The parameter can accept a value, an expression, or a list of values. The parameter description documents the valid data types.

            • ... (ellipses) indicate parameters that accept multiple arguments as a comma-separated list of values. The arguments must match the data type of the parameter.

            • A formula can include only a single operation. It can include nested functions and operators, each of which can appear on a separate line, as can parameters and arguments. But a formula can't include two independent operations. The formula editor doesn't support line continuation characters (such as \) or termination characters (such as ;) between independent operations. For an example of the error for invalid newlines in a formula, see Supported Data Mapper and Integration Procedure Data Types.

            For more information about specifying different data types, using constants, and understanding the errors that a function can return, see Supported Data Mapper and Integration Procedure Data Types.

            Omnistudio Function Updates

            Documentation about Omnistudio functions was updated Summer '25:

            • Parameter names and syntax were changed for consistency and clarity. Unless otherwise noted, all functions have the same parameters and usage.

            • These date and time functions were added to the documentation:

              • DAY(date)

              • HOUR(time)

              • MINUTE(time)

              • SECOND(time)

              • TIMEDIFF(firstTime, secondTime)

            • The date and time TODAY() function no longer accepts a format parameter.

            • These string functions were added to the documentation:

              • JOIN(string..., token)

              • SPLIT(string, token)

            • The list and array function MAPTOLIST(jsonObject) was added to the documentation.

            • These functions were removed from the documentation:

              • BASEURL

              • InvokeIP

              • ORDERITEMATTRIBUTES

             
            Loading
            Salesforce Help | Article