General functions

General functions let you fine-tune your mapping in a scenario. For example, you can select or leave out items in an array or apply conditional criteria to your mapping. Below is a list of general functions you can use in your scenarios.

Variables

executionId

Returns the ID of the current execution. Useful for logging and monitoring purposes.

Functions

get (object or array; path)

Returns the value path of an object or array. To access nested objects, use dot notation. The first item in an array is index 1.

get(array;1+1)
get(array;5.raw_name)
get(object;raw_name)
get(object;raw_name.sub_raw_name)

if (expression; value1; value2)

Returns value 1 if the expression is evaluated to be true. Otherwise, it returns value 2.

if(1=1;A;B) = A
if(1=2;A;B) = B

ifempty (value1; value2)

Returns value 1 if this value is not empty. Otherwise, it returns value 2.

ifempty(A;B) = A
ifempty(unknown;B) = B
ifempty("";B) = B

switch (expression; value1; result1; [value2; result2; …]; [else])

Evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value.

switch(B;A;1;B;2;C;3) = 2
switch(C;A;1;B;2;C;3) = 3
switch(X;A;1;B;2;C;3;4) = 4

omit (collection; key1; [key2; …])

Removes elements with the given keys from a collection. Returns a collection with the remaining elements. Useful when you want to pass a collection to an API, which expects an exact number of elements in the collection. Using this function, you can make sure your collection meets the requirements of the API.

pick (collection; key1; [key2; …])

Picks elements with the given keys from a collection. Returns a collection that contains only the picked elements. Useful when you want to pass a collection to an API, which expects an exact number of elements in the collection. Using this function, you can make sure your collection meets the requirements of the API.