Reading XML soup response with more than 1 namespace

[mahmoud.zaky]

Hello All,
I am working on project now start with call soap API and read specific attribute from response I can read all response but can not read specific attribute my response XML look like below:

I want to read only “value3” attribute only so I tried below but return “Object reference not set to an instance of an object.”

and for name space declaration

Thanks in advance

[ppr (Peter Preuss)]

@mahmoud.zaky
have a look here:

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 …

[mahmoud.zaky]

thanks for your reply but i tried to make above solution with no luck as i am still new in uipath and its the first time to handle XML

[ppr (Peter Preuss)]

No Problem, just share with us a sample xml as text and we will help you based on this

[mahmoud.zaky]

Thank you for your patience and kindly find below txt file contains sample XML
test.xml (435 Bytes)

[ppr (Peter Preuss)]

@mahmoud.zaky
find starter help (show casing dedicated access and loop over the result element) here:
XMLDemo.xaml (6.7 KB)

in case of retrieval issues following trick helps to find out the needed things:

xDoc.Root.Descendants()(X).Name - play with X=index and find out the needed namespace for a particular element

[mahmoud.zaky]

really thanks for your support working fine