nested loops TXMLMap How to extract these values ?

Six 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
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
Six 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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now