topic Re: extract data from JSON, multiple loops with key/value pair in Talend Studio

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

Jacco_De_Zwart — Fri, 15 Nov 2024 22:36:31 GMT

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

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

Jacco_De_Zwart — Tue, 30 Aug 2022 06:09:53 GMT

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

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

Mehdi_Mhedhbi2 — Sat, 17 Sep 2022 17:00:08 GMT

any updates regarding this case ?

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

Jacco_De_Zwart — Mon, 19 Sep 2022 05:58:56 GMT

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