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 math functions make math operations and 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.

ABS

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to return the absolute value of a number.

Syntax

ABS(number)

Let's say you need the absolute value of the number in the example below:

{

“a”: -34

}

{

“abs”: {{ ABS( message.a ) }}

}

The return of this function will be 34.0.

CEIL

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to return the smallest (closer to the negative infinite), greater or equal number to the argument value and equal to a whole math number.

Syntax

CEIL(number)

{

“a”: 12.885

}

{

"ceil": {{ CEIL( message.a ) }}

}

The return of this function will be 13.0.

DIVIDE

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to divide a number by the other.

Syntax

DIVIDE(numerator, denominator)

{

“a”: 10

}

{

"divide": {{ DIVIDE( message.a, 2 ) }}

}

The return of this function will be 5.0.

LOG

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to divide a number by the other.

Syntax

LOG(value, base)

{

“a”: 8

}

{

"log": {{ LOG( message.a, 2 ) }}

}

The return of this function will be 3.0.

MAX

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to declare the greater value between two provided numbers.

Syntax

MAX(num1, num2)

{

“a”: 8

}

{

"max": {{ MAX( message.a, 2 ) }}

}

The return of this function will be 8.0.

MIN

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to declare the smallest value between two provided numbers.

Syntax

MIN(num1, num2)

{

“a”: 8

}

{

"min": {{ MIN( message.a, 2 ) }}

}

The return of this function will be 2.0.

MOD

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to return the rest of the division operation.

Syntax

MOD(numerator, denominator)

{

“a”: 8

}

{

"mod": {{ MOD( message.a, 2 ) }}

}

The return of this function will be 0.0.

MULTIPLY

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to multiply n values.

Syntax

MULTIPLY(num1, num2, ..., numN)

{

“a”: 8

}

{

"mult": {{ MULTIPLY( message.a, 2 ) }}

}

The return of this function will be 16.0.

POW

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to bring the exponential.

Syntax

POW(num1, exp)

{

“a”: 2

}

{

"pow": {{ POW( message.a, 2 ) }}

}

The return of this function will be 4.0.

ROUND

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to return the closest number to the argument, with the ties rounded to the positive infinite.

Syntax

ROUND(num1)

{

“a”: 12.345

}

{

"round": {{ ROUND( message.a ) }}

}

The return of this function will be 12.0.

SQRT

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to extract the square root of the number.

Syntax

SQRT(num1)

{

“a”: 4

}

{

"sqrt": {{ SQRT( message.a ) }}

}

The return of this function will be 2.0.

SUBTRACT

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to subtract a number from another.

Syntax

SUBTRACT(num1, num2)

{

“a”: 10

}

{

"sub": {{ SUBTRACT( message.a, 2 ) }}

}

The return of this function will be 8.0

SUM

By using Double Braces, you can combine the function with the access to the input JSON element of a component.

The function is applied to sum n values.

Syntax

SUM(num1, num2, ..., numN)

{

“a”: 8

}

{

"sum": {{ SUM( message.a, 2 ) }}

}

The return of this function will be 10.0.

You can also read about these functions:

Did this answer your question?