Multi-select field to JSON
I need to take the individual selections of a multi-select field and use them to look up information in a reference table. These referenced look ups need to be concatenated into a string so I can use it in the body on an API request. What I really need is a "For Each" loop, but Catalytic doesn't have that option.
Example: In a multi-select field I have chosen Apples, and Orange, I need to look these up in a variety reference table. Passing Apples into the reference table returns Gala, Orange returns Cutie. I need to format the Gala and Cutie response into this JSON format:
"valueIds": [ "Gala", "Cutie" ]
I have a good idea how to do this if it was a single select field, but not with a multi-select.