Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Your XML structure does not look like it has any legitimate XML loops
There is a loop on the main. should I do the same for the output?
That is not a loop. That is a default configuration that Talend uses. The XML structure does not look like it supports loops properly.
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?
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.