Read XML files and get data - Namespaces

[andnesper (Andreas Persson)]

I’m trying to read several XML invoices to extract data. I have done as the XML instruction from UiPath explain. Every line of my XML invoice starts with cbc: or cac: and i use the “Descendants” to reach the Namespaces, but in the Output I’m getting nothing, it is just empty.

Anyone know why this happend?

[vivek_shiv (Vivek Shivankar)]

Hi,

Can you change Element() to Elements() if there are multiple xml tag.
Try to reach the exact value basis on xml tag name.

If it not work please share your program, Will work on it.

Thanks

[Ananthu (Ananthakrishnan K)]

Hi Andnesper,
Could you just explain how to use descendants in XML to reach a name space? I have a similar requirement.

Thanks and regards
Ananthu

[andnesper (Andreas Persson)]

Hello,

You could try this:

cac = “urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2”

cec=“urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2”

cbc=“urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2”

Then refer to the line you want:

netAmount= xmlDoc.Descendants(cac+“LegalMonetaryTotal”).Descendants(cbc+“TaxExclusiveAmount”).FirstOrDefault().Value

“LegalMonetaryTotal” is the area where you want to pick the value/text from. While “TaxExclusiveAmount” will be the specific line.

Hope this was to some help

[Ananthu (Ananthakrishnan K)]

Hi,
Thanks for your help . But, it’s still throwing an error. I have attached the error screen shot for you reference. Kindly let me know if you have an alternate solution.

My xml files contains tags in the below format.
tns:xxxx
ssdh:yyyy
ssdh:zzzz
ssdh:wwww
Value
ssdh:wwww
ssdh:zzzz
ssdh:yyyy
tns:xxxx

I have to retrieve the value and print it in a message box.

Thanks and regards,
Ananthu
IMG_20180628_100840_875|690x323

[andnesper (Andreas Persson)]

@andnesper

cac = “urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2”

Did you try to change the “cac” to one ssdh for example?

See if this could help:

Get XML element value (with namespaces)

Hello, try to use “{ }” or if it’s dynamic which is like, “is dynamic ” <ab:xlvalue>Str</ab:xlvalue> XNamespace ab = "http://your-url"; XElement tempElement = doc.Descendants(ab + "xlvalue").FirstOrDefault(); this way it will look for an xmlns:ab=… section in your document to find out which namespace URI “ab” refers to. You can get it by finding the attribute value for XNamespace.Xmlns + “ab” let us knwo if this is the answer you are looking for

Activities - Deserialize XML

Using Deserialize XML Acitvity

Hi , Please find below tutorials on XML handling [UiPath Tutorials For Beginners - XML Parsing] [Uipath Tutorials For Beginners XML Validations part-2]

[Ananthu (Ananthakrishnan K)]

Thanks Andrew! It worked.

Do you know how to access the fourth or third recurrence of a descendant and extract it’s values?

Like, instead of FirstorDefault() is there any function to access the second or third occurrence of that particular descendant…

Thanks and regards,
Ananthu

[andnesper (Andreas Persson)]

I’m not sure. I struggle with the same issue right now.

Do you have any reference in the XML file that you could use?

[Ananthu (Ananthakrishnan K)]

Hi Andrew!
I got it resolved. Thanks

Regards,
Ananthu

[andnesper (Andreas Persson)]

Great! Could you share how you did it?

[Ananthu (Ananthakrishnan K)]

Ya sure Andrew! Will send it later tonight.

Regards,
Ananthu

[Ananthu (Ananthakrishnan K)]

Hey Andrew,
Sorry for the delay ! I got caught up with some work. I have attached my workflow. Kindly let me know if you need any help.
Looping multiple xml tags.xaml (7.4 KB)

Thanks and regards,
Ananthu