topic Re: tXMLMap doesn't seem to loop (??) in Talend Studio

tXMLMap doesn't seem to loop (??)

Jacco_De_Zwart — Tue, 31 May 2022 11:32:36 GMT

Hi there,

I have created a tRestClient call to an API server. The call works fine and it returns a result as expected. But when I look at the Body of the response, it is filled with data.

When I pass the response to the tXMLMap component to extract the individual fields, I only get one result-row.

Why do I get just one result row ?

The Job looks like this :

The tRestClient is configured like this and works :

The tXMLMap component looks like this :

This is the execution result :

What dit

What did I miss ?

Thanks in advance.

Jacco

Re: tXMLMap doesn't seem to loop (??)

SMR040 — Tue, 31 May 2022 14:16:39 GMT

Are you trying to output it as a normal field or as a xml/json? If you want the output as a field you might be better of with a tExtractJSONFields where you should set the loop correctly.

If you are trying to output it as xml/json then you should create a document structure on the output side of the tXMLMap.

Re: tXMLMap doesn't seem to loop (??)

Jacco_De_Zwart — Thu, 02 Jun 2022 05:54:36 GMT

@S M

thanks for the advice !! It works ! Was a bit hard to work it out, but I managed to succeed.

Thanks again !

Re: tXMLMap doesn't seem to loop (??)

SMR040 — Thu, 02 Jun 2022 09:35:28 GMT

You are welcome!

Greetings from cimt 😉