Built-in Functions
Last updated
Last updated
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.
Let us see the different types of functions available in each category.
Converts the specified text to lowercase
Returns the input string after removing characters that do not fall within the normal ASCII values range.
Checks if a text begins with specified characters.
Transforms a string by capitalizing its first letter.
Checks if the specified value is contained within the given path.
Removes duplicate values from the array of values passed as parameters.
Escapes HTML tags within the provided string.
Generates a random decimal number within the specified range.
Used to get the data from the response header.
Concatenates a list of values using a specified separator.
Reverses the order of values within a list.
Capitalizes the first letter of each word in the input string.
Used to remove HTML tags from a given string.
Converts a string value to an integer.
Converts any value to a string.
Converts lowercase words or sentences to uppercase.
Ensure special characters in text are displayed as literals in Markdown syntax.
Gives you the absolute value of a number without its sign.
Used to find the angle (in radians) whose cosine is a given number.
Used to find the angle (in radians) whose sine is a given number.
Calculates the arithmetic mean of a set of numbers, representing their central tendency.
Used to round a number up to the nearest integer.
Generates a random value within a specified range.
Returns the maximum value from a set of given inputs.
Returns the minimum value from a set of given inputs.
Converts a string representation of a number into its numerical value.
Used to round a number to the nearest integer.
Calculates the total of a set of numbers by adding them together.
Control statement used to select one of many code blocks to be executed based on a specified condition.
Used to round a number down to the nearest integer.
Calculates a date by adding a specified number of months to a given date.
Creates a date based on the provided year, month, and day inputs.
Formats the input expression as a date and time value.
Formats the input expression as a date.
Returns the day of the month based on the date passed.
Returns the number of the day in the year based on the date passed.
Returns a formatted date based on the input date and specified format.
Formats the current date according to a specified format.
Modifies the time part of a datetime value according to the specified format.
Converts the input date into the specified format.
Converts the input date and time into the specified format.
converts the input Unix timestamp into the specified format.
Returns the conversion rate based on the provided amount and conversion rate.
searches for a value in a dataset and returns the corresponding result based on predefined criteria.
Retrieving the ETL response within the integration channel
Highlighting the automatic launch flow within the Integration Channel
Generates a cryptographic hash of a given input, typically used for data integrity verification and password hashing.
Generates a cryptographic hash using the SHA-1 algorithm for a given input.
Generates a cryptographic hash using the SHA-256 algorithm for a given input.
Generates a cryptographic hash using the SHA-512 algorithm for a given input.
Converts data into a JSON (JavaScript Object Notation) format, commonly used for data interchange between systems.
Checks whether a given element exists in a collection or sequence.
Represents an empty or null value within a dataset.
Evaluates a logical test and returns one value if the test is true, and another if it is false.
Checks whether an expression is blank and returns TRUE or FALSE accordingly.
Checks whether a given value is null.
Checks whether a given value is a numerical value.
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.
Returns true if at least one of the given conditions is true.