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

[schneich]

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

[Anonymous]

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

 

[schneich · Accepted solution]

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...

 

[Anonymous]

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