extract data from JSON, multiple loops with key/value pair

[Jacco_De_Zwart]

Hi there,

I have the following JSON response of a API call.

The part marked with green is no problem to extract using tExtractJSONFields by looping through the booking entry.

But how do I retrieve the parts marked in red ? Do I need a secondary (or two) tExtractJSONFields component ?

All help is appreciated.

Thanks in advance,

Jacco

[Jacco_De_Zwart]

Additional . . . . the key/value pairs do not have to appear all the time. That means that in on JSON response a key/value pair may be present and in the other the same key/value pair may not be present

[Mehdi_Mhedhbi2]

any updates regarding this case ?

[Jacco_De_Zwart · Accepted solution]

Well, been playing around a bit and came to the following solution.

By splitting the message in to three parts, I'm able to extract all the information in the response of the API call.

This is my solution so far, until someone comes along with a better of more efficient solution.

But perhaps this can help you. Thanks for the interest.

Jacco