--- schema_version: "1" id: a994074f8f68030290b69f4af0a589d139cf6e3f4b79ef10ec7c9f1bbd574ac8 title: Supported Data Mapper and Integration Procedure Functions collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/os_omnistudio_data_mapper_and_integration_procedure_functions.md canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_functions.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: f6e3293b86513ed5e2a0fc05cd3f85015255d58775da7956e3129dc3a57b16d6 description: 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. products: - Omnistudio release: "264" --- # 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](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-omnistudio-264-0-0-production-enus/f526eaa8-ae05-487a-8944-4bb99b0b78ac/images/icon_note.png) 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](https://help.salesforce.com/s/articleView?id=xcloud.os_create_a_formula_or_aggregate_in_an_omniscript_23115.htm&release=264.0.0&type=5 "Create expressions to set calculated values and evaluate data across multiple fields using a Formula or Aggregate element. For example, if you are accepting information for a qualifying life event you may want to create a formula that determines if the date entered for the qualifying life event is within thirty days of today's date."). 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](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_data_types.htm&release=264.0.0&type=5 "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."). 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](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_data_mapper_and_integration_procedure_data_types.htm&release=264.0.0&type=5 "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."). ## 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`