nested loops TXMLMap How to extract these values ?

Five Stars

nested loops TXMLMap How to extract these values ?

Hello Community,

 

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

 

talend.png

 

tRestclient GET message :

 

<content type="application/xml">
<mSmiley Tongueroperties>
<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>

</mSmiley Tongueroperties>

<mSmiley Tongueroperties>
<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>
</mSmiley Tongueroperties>

<mSmiley Tongueroperties>
<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>

</mSmiley Tongueroperties>
</content 

talend2.png

 

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

talend3.png

Do you have any solutions for this please ? 

thank's

 

Highlighted
Thirteen Stars

Re: nested loops TXMLMap How to extract these values ?

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

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

Manohar B
Five Stars

Re: nested loops TXMLMap How to extract these values ?

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

finally I used tExtractXMLField.