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 Preuss)]

@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 Preuss)]

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

In some cases, we can also do: Assign Activity - xnsDefault = xDoc.Root.Name.Namespace

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"

About Prototyping / RnD
we recommend to work within the immediate panel as we can check and prototype very fast
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

[aidan.moore]

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