nested loops TXMLMap How to extract these values ?

Anonymous — Mon, 23 Apr 2018 22:04:18 GMT

Hello Community,

I have a problem when I'm trying to read XML from tRestclient > tXMLMap

tRestclient GET message :

<content type="application/xml">
<mroperties>
<d:FileSystemObjectType >0</d:FileSystemObjectType>
<d:Id>13</d:Id>
<d:Title>health</d:Title>
<d:c3vxId m:type="Collection(Edm.Int32)">
<d:element>198</d:element>
<d:element>101</d:element>
</d:c3vxId>

</mroperties>

<mroperties>
<d:FileSystemObjectType >1</d:FileSystemObjectType>
<d:Id>13</d:Id>
<d:Title>human</d:Title>
<d:c3vxId m:type="Collection(Edm.Int32)">
<d:element>200</d:element>
<d:element>101</d:element>
</d:c3vxId>
</mroperties>

<mroperties>
<d:FileSystemObjectType >2</d:FileSystemObjectType>
<d:Id>13</d:Id>
<d:Title>technology</d:Title>
<d:c3vxId m:type="Collection(Edm.Int32)">
<d:element>108</d:element>
<d:element>101</d:element>
</d:c3vxId>

</mroperties>
</content

the problem is that I can't loop on </d:c3vxId> because it's a child node.

Do you have any solutions for this please ?

thank's

Re: nested loops TXMLMap How to extract these values ?

manodwhb — Tue, 24 Apr 2018 06:53:16 GMT

@Ma2018,did you verified below link for loops in tXMLMap?

https://help.talend.com/reader/ixBASPZJ7IvqUQVupZwWbg/EFuE5Nul595D24TRwbFnbw

Re: nested loops TXMLMap How to extract these values ?

Anonymous — Tue, 24 Apr 2018 14:32:39 GMT

Yes, when I use the loop on the child node (d:element) it doesn't loop on the higher level (mroperties)

finally I used tExtractXMLField.

topic Re: nested loops TXMLMap How to extract these values ? in Talend Studio

nested loops TXMLMap How to extract these values ?

Re: nested loops TXMLMap How to extract these values ?

Re: nested loops TXMLMap How to extract these values ?