CSV_TO_JSON_ARRAY function

Parameters: (String propertyName, String csvList) 

Returns: JSON Array 

Converts a comma-separated string into an array of JSON objects, where each value becomes an object with the specified property name.

You can generate the CSV list manually or from a lookup, using the "Concatenate CSV" option for the Multiple Match Action within a lookup mapping.

Example:

Given asset_list = "ast-123,ast-456"

CSV_TO_JSON_ARRAY('value', asset_list)

Returns: 

[ 
   { "value": "ast-123" },
    { "value": "ast-456" } 
]