The look-up target (property take) is using the same syntax as the column mapping. It supports however a limited sets of functions, including taking values as-is, transforming them or using fixed values.
|
Note: Enrichment take element does not support Auto expressions! You can use SQL expression though if you need the greatest flexibility. |
Due to this, it is possible to use the following combinations:
Taking value from a column without transforming it
{
"in": "Car",
"key": "CarRegistrationId",
"take": "Address"
}
Taking value from a column with a transform (for example uppercase)
{
"in": {
"name": "Car",
"transform": "Uppercase"
},
"key": "CarRegistrationId",
"take": "Address"
}
|
Note: It makes no sense to use fixed values for non-fallback values. If the value is fixed and is not-null, all subsequent look-up items will always be ignored. |