Architect - recovery json from data action

[DanielG1]

Hello.

Refering to this post:

Data Action returning JSON in success template

Hi all, We love the new JSON functions in architect, but there is one more piece of the puzzle that would make it especially useful. If there is a way to return the raw result from a data action, then in architect we can parse thru arbitrary JSON objects, ie nested arrays which we currently cannot. So far I tried creating an output template like the below but it always returns the default value zero. How do I return $value back to the success template? Any help is appreciated! { "translat…

I can not accomplished what is proposed. I need to get raw json from data action to architect and i can not find the way.

Some help?

below screnshots with contract and configuration section of the data action.

tnx

[Erik_Hanssens]

Hello Daniel,

I managed to do it by passing a string value
I wanted the first result:

• in the data action, the response is set as $.data[0]
• in the flow, I am converting the string into a json object by JsonParse(Task.firstMatchStr)

In you case, you can set the rawResult into a string output and convert it to json in the flow.

With kind regards,

Erik

[Jan_Heinonen]

I use the following to get the object as a string, and then in Architect I can convert it to a JSON Object again

Response template

{
"translationMap": {},
"translationMapDefaults": {},
"successTemplate": "{"jsonObject": "$esc.jsonString("${rawResult}")" }"
}

[DanielG1]

Still not working, even putting the data you said

[DanielG1]

any idea? what i´m doing wrong?

[SimonBrown]

Not formatted correctly.

You need to wrap response in double quotes and escape them in the response box to form valid json response.

"successTemplate": " { \"jsonObject\": \"$esc.jsonString(${rawResult}\" } "

I recently did same to get raw data from gc api as still not option for nested arrays in data actions.

Onto the next stage trying to work out the architect json functions with the none real world appalling example usage.

[DanielG1]

I will try, thanks Simon!