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" ) }}

}