Built-in Functions

200 OK features a range of predefined functions aimed at simplifying the implementation process. These pre-built functions provide ready-to-use logic for a variety of scenarios, effectively streamlining the entire implementation process. The functions are organized into several categories such as Text, Math, Date & Time, Advanced, Logical, and Custom Functions. Users can conveniently access these functions within the Data Mapper section, making it easy to integrate them while configuring requests or handling responses. This accessibility enhances efficiency and empowers users to achieve precise outcomes effortlessly.

In 200 OK we have six types of function categories.

Text

Math

Date & Time

Advanced

Logical

Custom function

Let us see the different types of functions available in each category.

Text

Function	Description
toLowerCase	Converts the specified text to lowercase
ascii	Returns the input string after removing characters that do not fall within the normal ASCII values range.
begins	Checks if a text begins with specified characters.
capitalize	Transforms a string by capitalizing its first letter.
contains	Checks if the specified value is contained within the given path.
deDuplicate	Removes duplicate values from the array of values passed as parameters.
escapeHtml	Escapes HTML tags within the provided string.
generateRandomString	Generates a random decimal number within the specified range.
getValueFromResponseHeader	Used to get the data from the response header.
join	Concatenates a list of values using a specified separator.
reverse	Reverses the order of values within a list.
startCase	Capitalizes the first letter of each word in the input string.
stripHtml	Used to remove HTML tags from a given string.
toInt	Converts a string value to an integer.
toString	Converts any value to a string.
toUpperCase	Converts lowercase words or sentences to uppercase.
escapeMarkDown	Ensure special characters in text are displayed as literals in Markdown syntax.

Math

Function	Description
abs	Gives you the absolute value of a number without its sign.
acos	Used to find the angle (in radians) whose cosine is a given number.
asin	Used to find the angle (in radians) whose sine is a given number.
average	Calculates the arithmetic mean of a set of numbers, representing their central tendency.
ceil	Used to round a number up to the nearest integer.
generateRandom	Generates a random value within a specified range.
max	Returns the maximum value from a set of given inputs.
min	Returns the minimum value from a set of given inputs.
parseNumber	Converts a string representation of a number into its numerical value.
round	Used to round a number to the nearest integer.
sum	Calculates the total of a set of numbers by adding them together.
switch	Control statement used to select one of many code blocks to be executed based on a specified condition.
floor	Used to round a number down to the nearest integer.

Date & Time

Function	Description
addMonths	Calculates a date by adding a specified number of months to a given date.
date	Creates a date based on the provided year, month, and day inputs.
dateTimeValue	Formats the input expression as a date and time value.
dateValue	Formats the input expression as a date.
day	Returns the day of the month based on the date passed.
dayofYear	Returns the number of the day in the year based on the date passed.
formatDateTodayFormat	Returns a formatted date based on the input date and specified format.
formatDateTodayUnix	Formats the current date according to a specified format.
toTime	Modifies the time part of a datetime value according to the specified format.
toDate	Converts the input date into the specified format.
toDateTime	Converts the input date and time into the specified format.
toDateTimeUnix	converts the input Unix timestamp into the specified format.

Advanced

Function	Description
currencyRate	Returns the conversion rate based on the provided amount and conversion rate.
lookup	searches for a value in a dataset and returns the corresponding result based on predefined criteria.
invokeETL	Retrieving the ETL response within the integration channel
invokeFlow	Highlighting the automatic launch flow within the Integration Channel
md5	Generates a cryptographic hash of a given input, typically used for data integrity verification and password hashing.
sha1	Generates a cryptographic hash using the SHA-1 algorithm for a given input.
sha256	Generates a cryptographic hash using the SHA-256 algorithm for a given input.
sha512	Generates a cryptographic hash using the SHA-512 algorithm for a given input.
toJson	Converts data into a JSON (JavaScript Object Notation) format, commonly used for data interchange between systems.
exists	Checks whether a given element exists in a collection or sequence.

Logical

Function	Description
blankValue	Represents an empty or null value within a dataset.
if	Evaluates a logical test and returns one value if the test is true, and another if it is false.
isBlank	Checks whether an expression is blank and returns TRUE or FALSE accordingly.
isNull	Checks whether a given value is null.
isNumber	Checks whether a given value is a numerical value.
nullValue	checks if an expression is null and returns a substitute expression if it is. If the expression is not null, it returns the original expression value.
or	Returns true if at least one of the given conditions is true.