topic Re: Loop not working on REST service output in Talend Studio

Loop not working on REST service output

Anonymous — Sat, 16 Nov 2024 09:33:36 GMT

Hi -

I am trying to execute a REST client that returns looped row data. I want to input this data to a database.

However it seems that the tXML item is not looping the data element

Re: Loop not working on REST service output

Anonymous — Wed, 05 Jul 2017 15:37:38 GMT

Your XML structure does not look like it has any legitimate XML loops

Re: Loop not working on REST service output

Anonymous — Wed, 05 Jul 2017 15:53:05 GMT

There is a loop on the main. should I do the same for the output?

Re: Loop not working on REST service output

Anonymous — Wed, 05 Jul 2017 16:05:36 GMT

That is not a loop. That is a default configuration that Talend uses. The XML structure does not look like it supports loops properly.

Re: Loop not working on REST service output

Anonymous — Wed, 05 Jul 2017 16:34:07 GMT

That is not the default, I had to configure it to get the body message.

How would a loop example look, as my main states loop for the root element?

Re: Loop not working on REST service output

Anonymous — Wed, 05 Jul 2017 17:08:58 GMT

What I meant was this (circled) is a default Talend config......

In order to return multple rows you will need to put that "loop" config on an element which is the parent of a looping section.

However, it doesn't look like your XML is looping. I would expect something like below from a looping xml....

<root>
<cmdb_id></cmdb_id>
<status></status>
<datas>
<data>
<bytes_in></bytes_in>
<bytes_out></bytes_out>
<bytes_total></bytes_total>
<ip></ip>
</data>
</datas>
</root>

Look at the "datas" (sorry, a bad plural for data) element. It contains a complex type that is looping. A loop needs a container in good XML.