Error While reading specific element value from XML, when XML has namespace

[kaustubh.aras28 (Kaustubh Aras)]

I wish to get value of Element “name” which is inside “homecity”. (see the xml below)

Here is what I’ve tried -

1. Read XML using Read Text File activity and stored the output in “xmlContent” variable.
2. Used the Parse method to parse the xmlContent from Step 1, assigned to a XDoc variable of XDocument type.
3. Used, XDoc.XPathSelectElement(“//homecity/name”).Value and assigned this to a “cityName” variable.
   NOTE: Have also tried Deserializing XML. And, when I remove the xmlns="http://www.your.example.com/xml/person" from person and "xmlns="http://www.your.example.com/xml/cities" from homecity, it works.

After executing this getting Runtime execution error -

Source - Assign (Step 3)
Message - Object reference not set to an instance of an object
Exception Type: System.NullReferenceException

Here is the xml which I’m using -

<person xmlns="http://www.your.example.com/xml/person">
    <name>Rob</name>
    <age>37</age>
    <homecity xmlns="http://www.my.example.com/xml/cities">
        <name>London</name>
        <lat>123.000</lat>
        <long>0.00</long>
    </homecity>
</person>

Any suggestions on this would be of great help. Thanks!

[ppr (Peter Preuss)]

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types) - Help / Community - UiPath Community Forum

[ppr (Peter Preuss)]

@kaustubh.aras28

Used, XDoc.XPathSelectElement(“//homecity/name”)

here we would work with a namespace manager

Reading all the tags of an XML and take them to excel

@Fabian_DDD I do feel that a XPath Approach is better for the retrieval Setting up a NamespaceManager with a Config Datatable: [grafik] for the default namespace with empty prefix “def” is assigne as prefix the retrieval is configured as another datatable (could also be externalize into an excel) [grafik] I did also for a deeper nested element for demo purpose After all preperation it is iterating over the retrieval config and retrieves the specfied values. et voila: [grafik] So this …

[kaustubh.aras28 (Kaustubh Aras)]

@ppr - Thanks, Peter!

But I don’t wish to have the namespaces added to data sheet. Is there anyway I can get the element value from the given xml (mentioned in my question) or anyway to just ignore the namespaces and read the rest of the xml.

[ppr (Peter Preuss)]

@kaustubh.aras28

don’t wish to have the namespaces added to data sheet.

it is not about to setup a config and namespaces to a config table. It was about to show you the essentials on how to setup up the namespace manager needed for the XPathSelectElement

@kaustubh.aras28

Is there anyway I can get the element value from the given xml (mentioned in my question)

we had shown you two approaches and did answer how to handle XML Namespaces

@kaustubh.aras28

ignore the namespaces and read the rest of the XML

not really recommended, as we can properly handle the Namespaces

A Variation with XPath:

[kaustubh.aras28 (Kaustubh Aras)]

Thanks a lot Peter for your assistance, it helped and worked!

Cheers!

[ppr (Peter Preuss)]

Perfect, so the topic can be closed by:

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…