Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

nested loops TXMLMap How to extract these values ?

Hello Community,

 

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

 

0683p000009LwSA.png

 

tRestclient GET message :

 

<content type="application/xml">
<m0683p000009MAB6.pngroperties>
<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>

</m0683p000009MAB6.pngroperties>

<m0683p000009MAB6.pngroperties>
<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>
</m0683p000009MAB6.pngroperties>

<m0683p000009MAB6.pngroperties>
<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>

</m0683p000009MAB6.pngroperties>
</content 

0683p000009LwwX.png

 

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

0683p000009Lwsw.png

Do you have any solutions for this please ? 

thank's

 

Labels (4)
2 Replies
manodwhb
Champion II
Champion II

Anonymous
Not applicable
Author

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

finally I used tExtractXMLField.