Hello,
I’m trying to model an process flow API which adds emails to a queue. I’ve got this all working, but i want to inform the sender that the email was correctly added, by returning the emails’ ID and status. I would like to use the response headers for this, but i’m experiencing some problems as into how i would format this correctly in SQL.
According to the documentation (https://docs.thinkwisesoftware.com/docs/sf/process_flows#enable-the-message-protocol-independent-web-service) the response headers should be formatted like this: { "Header1": [ "value1", "value2" ]
, "Header2": [ "value"] }
My question is how i should archieve a format like that in SQL? I thought i could just format my variables like a json body by selecting them in a subquery with ‘for json path’, but that results in errors. I think this feature was developed by you with supportive sql functions in mind to achieve this more easily. What is the correct way to achieve the format which Indicium accepts?
Best answer by Robbert van Tongeren
View original