Looping XML Elements

[ppr (Peter Preuss)]

we suggest the following:

Analyze the XML Namespaces as described here:

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types)

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] In some cases, we can also do: Assign Activity - xnsDefault = xDoc.Root.Name.Namespace Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</…

then loop over all speciality elements and process the code and name

xnsDefault | XNamespace Variable

For each activity | TypeArgument: XElement |
item in xDoc.Root.Descendants(xnsDefault + "specialty")

• log message: item.Element(xnsDefault + "specialtyCode").Value
• log message: item.Element(xnsDefault + "specialtyName").Value