topic Re: iterate on tRESTClient and join the JSON-results into one table in Talend Studio

iterate on tRESTClient and join the JSON-results into one table

schneich — Fri, 22 Sep 2023 09:01:34 GMT

Hi,

I am pulling contact-data from the Microsoft Dynamics CRM 365. In that response, there are some references on account-data. I create a list of those IDs, so that I can loop over a tRESTClient to get the details of those accounts. I want to merge the responses back into my contact-data, so that there is not the reference, but the actual name.

It is almost working fine. As you can see below, I can iterate tRESTClient_4 and get the JSON-responses in tLogRow_6. Unfortunately, in tLogRow_10, I get the data, but not in one table. How can I make the workfow wait, until all iteration is finished and then provide one table with all the data?

Any help is very much appreciated.

Chris

Re: iterate on tRESTClient and join the JSON-results into one table

Anonymous — Fri, 22 Sep 2023 09:54:57 GMT

You need to add the string column in the output schema as well on tExtractJsonFields,

Re: iterate on tRESTClient and join the JSON-results into one table

schneich — Fri, 22 Sep 2023 10:00:31 GMT

Hi @Shicong Hong ,

thank you very much for your input. I don't need the string in the output, that is why I left it out.

I found the solution myself. So simple: add a tHashOutput to gather all the data from the iteration. After that, I can process the data as needed...

Re: iterate on tRESTClient and join the JSON-results into one table

Anonymous — Fri, 22 Sep 2023 10:12:05 GMT

I misunderstood your question, no problem at all, use a tHashOutput to cache all data in memory for further processing. Thanks for your feedback and sharing!

Regards

Shong