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

 

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.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.