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, click here.

See below how the functions are grouped according to what they perform.

COMPARISON

The functions of this group make comparisons of booleans inputs. Click here to read about:

  • AND

  • NOT

  • OR

  • XOR

NUMERICAL

The functions of this group treat numbers. Click here to read about:

  • 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. Click here to read about:

  • EQUALTO

  • GREATERTHAN

  • GREATERTHANEQUAL

  • IF

  • LESSTHAN

  • LESSTHANEQUAL

  • ISOBJECT

  • ISARRAY

  • ISBOOLEAN

  • ISSTRING

  • ISNUMBER

  • ISNULL

  • SWITCHCASE

DATE

The functions of this group treat, generate and convert dates. Click here to read about:

  • FORMATDATE

  • NOW

  • SUMDATE

  • TOISODATE

  • DIFFDATE

FILE

The functions of this group make queries to metadata and make validations in files. Click here to read about:

  • FILEEXISTS

  • FILESIZE

JSON

The functions of this group make operations in JSON objects. Click here to read about:

  • JSONPATH

  • TOJSON

  • UNESCAPEJSON

  • GETELEMENTAT

  • LASTELEMENT

  • ARRAYTOOBJECT

  • OBJECTTOARRAY

  • NEWEMPTYOBJECT

MATH

The functions of this group make math operations. Click here to read about:

  • 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. Click here to read about:

  • 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. Click here to know better:

  • BASEDECODE

  • BASEENCODE

  • UUID

  • TOBOOLEAN

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" ) }}
}
Did this answer your question?