Mappings

The Mappings describe how to link the Source Fields to the Target Fields. Each mapping can contain an aggregation strategy, conditionals and a default-value.

Aggregation Strategy

Allows applying window functions over a mapping that lets the values aggregate when the Target Records get created.

Possible values: ['MAX', 'MIN', 'SUM', 'AVG', 'LISTAGG']

  • Can be applied over a window of source field values by supplying a list of source fields.

  • The LISTAGG aggregation function requires the additional parameter ‘separator’.

Conditionals

List of conditions that allow mapping multiple source field to a single target field provided the conditions. Each condition contains field 1, field 2 an operator and a value. The conditions are iterated in order, and the value from the first true condition is taken on.

Each condition is evaluated as such: {field 1} {operator} {field 2}.

Default-value

If no condition is true, it falls to the default-value. If not default value is specified the value is empty.

 

Integrations Module

Create Integration

 

 

 

Topic updated: 03/2025.