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

[aidan.moore]

Hello lovely UIPathers
I am hoping someone can guide me towards how I can extract the restAPIVersion from this deserialized XML:

Tried just about everything I can think of without success & grateful for any pointers.
Thank you!

[ppr (Peter)]

@aidan.moore
Welcome to the forum

you may have to handle XML namespaces

Have a look here

Read from xml file

@Zlotzky Setting up the quick prototype: Variables: Handling Namespace: [grafik] ElementNames to Extract - Prototype reduced set: [grafik] Read In XML [grafik] Ensure: [grafik] Retrieval of private contact element (mandatory use of the Namespace within the name) [grafik] iterating over the list of elmentnames (ExtractNames) and reading element value: [grafik] Logs: [grafik] Find starter help here: Zlotzky.xaml (6.3 KB)

Maybe you can share the XML as text with us

[ppr (Peter)]

Going ahead
Serializing the XML - output: xDoc | DataType: XDocument:

Checking if we have to handle XML namespaces

We do have:

Checking for some children:

Defining Namespace Variable

Checkin the retrieval

xDoc.Descendants(xnsDefault + "productVersion")
 GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</productVersion>] }
 xDoc.Descendants(xnsDefault + "productVersion").First().Value
 "123"
 xDoc.Descendants(xnsDefault + "productVersion").First().Attribute("build").Value
 "456"
 xDoc.Descendants(xnsDefault + "restApiVersion").First().Value
 "3.12"

[aidan.moore]

Thanks Peter!
Annoyingly I had squiggly brackets around the XNamespace until I read your solution.