Unable to get data from XML

[ronanpeter]

First off, make sure you are passing the correct TypeArgument to your ForEach loop:

Then start by just trying to access the parent node of the XML so just write your

ForEach Item In xmlDoc.Elements

Write Line > Element.tostring

That should export the entire XML to the output panel.

Then start adding added definition to your In argument

xmlDoc.Elements(namespacevar+“ElementName”).Elements(namespacevar2+“ElementName”).Elements

This will pass a number of system.xml.linq.XElement variables to your for each loop and doing it one by one ensures easy troubleshooting.

Within elements you will have attributes and these attributes have values in quotation marks. if you are trying to access these values directly then it will be something like this passed into the for each:

xmlDoc.Elements(namespacevar+“ElementName”).Elements(namespacevar2+“ElementName”).Attributes

Then in your For Each action pane:

item.value.ToString

You may find a site like this useful to provide your XML tree structure in a more easily understood format for this task: https://codebeautify.org/xmlviewer