Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@Ma2018,did you verified below link for loops in tXMLMap?
https://help.talend.com/reader/ixBASPZJ7IvqUQVupZwWbg/EFuE5Nul595D24TRwbFnbw
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.