How to create payloads (strings merged/concatenated from array objects) from Excel data?

No $keys() gives an array of all keys of a object,. Unless only one is returned. To force that to an array, [$keys()] would `force a single result to a single array, it would not affect a array with multiple values.

To get values of payload
$$.payload.*

Or if you are in map of an array of objects the context in loop is $
$$.payload.($.property_name)

$.* would return an array of all values from the object, in a map of an array of objects.

1 Like