The functions were created to:
speed up the creation of your integrations even more;
decrease the complexity of your pipelines;
simplify data conversions and transformations during the flow of your pipelines.
The functions are available for components that support Double Braces expressions. To know how to provide information to the components using this resource, read the article Double Braces and Input Data.
See below how the functions are grouped according to what they perform.
COMPARISON
The functions of this group make comparisons of booleans inputs. To learn more, read the article Comparison Functions:
AND
NOT
OR
XOR
NUMERICAL
The functions of this group treat numbers. To learn more, read the article Numerical Functions:
FORMATNUMBER
TODOUBLE
TOINT
TOLONG
CONDITIONAL
The functions of this group return a value according to the criteria you establish. For logical tests and conditions, operators will be used in these functions. To learn more, read the article Conditional Functions:
EQUALTO
GREATERTHAN
GREATERTHANEQUAL
IF
LESSTHAN
LESSTHANEQUAL
ISOBJECT
ISARRAY
ISBOOLEAN
ISSTRING
ISNUMBER
ISNULL
SWITCHCASE
DATE
The functions of this group treat, generate and convert dates. To learn more, read the article Date Functions:
FORMATDATE
NOW
SUMDATE
TOISODATE
DIFFDATE
FILE
The functions of this group make queries to metadata and make validations in files. To learn more, read the article File Functions:
FILEEXISTS
FILESIZE
JSON
The functions of this group make operations in JSON objects. To learn more, read the article JSON Functions:
JSONPATH
TOJSON
UNESCAPEJSON
GETELEMENTAT
LASTELEMENT
REMOVEAT
ARRAYTOOBJECT
OBJECTTOARRAY
NEWEMPTYOBJECT
NEWEMPTYARRAY
MATH
The functions of this group make math operations. To learn more, read the article Math Functions:
ABS
CEIL
DIVIDE
LOG
MAX
MIN
MOD
MULTIPLY
POW
ROUND
SQRT
SUBTRACT
SUM
STRING
The functions of this group make string treatments, operations and conversions. To learn more, read the article String Functions:
CAPITALIZE
CONCAT
ESCAPE
INDEXOF
JOIN
LASTINDEXOF
LEFTPAD
LOWERCASE
MATCHES
NORMALIZE
REPLACE
RIGHTPAD
SPLIT
SUBSTRING
TOSTRING
UPPERCASE
CONTAINS
UTILITIES
The functions of this group make diverse operations, which don't fit any of the previous categories. To learn more, read the article Utilities Functions:
BASEDECODE
BASEENCODE
UUID
TOBOOLEAN
SIZE
Functions combination
Let's say you need to remove spaces and guarantee the standard value is sent if it's absent:
{
"name": "John",
"type": " PP "
}You can use a function to assign a standard value when the element isn't provided in the input and to remove the spaces if the value exists:
{
"name": {{ message.name }},
"type": {{ DEFAULT( TRIM(message.type), "LP" ) }}
}