Rest API Collections, Objects

0

Hi,
We've faced similar issue, and solved it using JSON_VALUE sql function, just a jsonpath to retrieve data which was needed.
In this case jsonpath will loke something like this: $.decisions[0].type.code

Thanks for a Tip,
Action is working but wont fill in the field, the response is returned with response body and code 200.
in this [0] should I pass some kind of id? $.decisions[0].type.code

Zero here: $.decisions[0].type.code just means first element of the array, so this will be the first decision, which is present in the array of decision as in your json example.
Have you configured target field? In my case it's a local parameter in automation, but if you need it on form, then it should be set to the attribute which should be filled in.

You could also send a screenshots how the current config looks like on your side :)

updated pic in previous msg i tried with $.decisions[0].type.code and $.[0]decisions.type.code

Make sure that Json Path you are using returns what you need. You could use this tool for example:
https://jsonpath.com/

If the data structure looks exactly like the one in example, then my proposition should work out of the box, if there are some differences try your solution out with tool above :)

Yeha you right its working good , so mebay i doing something wrong with input?
I thing even value atribute form , how i soupsed to deliver those boody in that function /rule buissenes?

Finallyyyy ;) I got it and its working , in our value i had to inplemnetent full body ( json)
name have to be 1:1 :) in column Name has to be : Response:Body
Its working thanks so much Maks!

Glad i could help ;)