Re: Help to Getting values from a Json
Hey @HansenvomDeich
For this you will have to use two parse JSON actions.
Let me know if the below method works for you, if not can you send me the above json data. Hide or Replace the values that you dont want to show. [Replace them with Test data like abc]
Compose Action:
I have taken similar data like you:

Then I have initialized an empty array:

Then I have used Parse json action.
Inside that I have passed the outputs of 1st compose.
In schema I have added this:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"body": {
"type": "array"
}
},
"required": [
"body"
]
}
}
After this I used an item in compose coming from parse json.
This will create a loop.
After this I have taken another parse json action inside the loop. I have passed output of compose 2 in it.
The schema looks like below:
{
"type": "object",
"properties": {
"body": {
"type": "array",
"items": {
"type": "object",
"properties": {
"TID": {
"type": "string"
}
},
"required": [
"TID"
]
}
}
}
}
After this I have taken append to array action. And pass TID coming from parse json.
This will create a loop.
After this outside the loop I have take a compose action and passed the variable in it to show you the output:
Final Output:
Let me know if it works or not.
If this does not work, as I told you above send me your json data and replace the data with test data.
And I will be able to help.
I hope this helps 🙂