Solved

Format process flow API's response headers

  • 29 August 2022
  • 3 replies
  • 91 views
B
Rank
Userlevel 1
Badge +4

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?

icon

Best answer by Robbert van Tongeren 29 August 2022, 13:40

View original
This topic has been closed for comments

3 replies

Robbert van Tongeren
Rank
Userlevel 5

Hi @BramG ,

You can do this by using a query like this, for the values you can you a concat of string_agg if you are coming from a table.

select (select json_query('["value1","Value2"]')) as header1
    ,(select json_query('["value3"]')) as header2
 for json path, without_array_wrapper

With this result:

{"header1":["value1","Value2"],"header2":["value3"]}

 

Hope this helps.

B
Rank
Userlevel 1
Badge +4

When i return the scope_identity(), indicium wants me to cast the integer value as a string, which i now did. After that, i get the following error: “Could not cast or convert from System.String to System.String[]”. Do i really have to concat these square brackets around the values or is there a cleaner solution?

Robbert van Tongeren
Rank
Userlevel 5

After having a call with Bram we discovered a small error in the query, 1 square bracket was missing, I have edited my response which is correct now.

Terms & ConditionsCookie settings