GET Attribute from XML

[Israel_Silva]

In the xml below, how to get the data inside the attribute, I’ve tried many ways and I’m not succeeding

test.xml (9.8 KB)

[Anil_G (Anil Gorthi)]

@Israel_Silva

Please check this follow the steps

Get xml attribute value and descriptor values

we would like to remind you on the XML Namespace handling similar to your other topics general flow: [grafik] Check and namespace handling: [grafik] [grafik] Retrieval: [grafik] Getting all WID types: [grafik] Getting first one’ s value [grafik] Bank_Account: [grafik] For the other retrieval just adapt and handle it similar

Cheers

[Israel_Silva]

Using the mentioned tutorial, I couldn’t find the CNPJ value in the XML, when I try to specify the element, the result is always Null

Cheers!!

[ppr (Peter Preuss)]

@Israel_Silva
Kindly note: the provided XML was incomplete we did repair for some prototyping

@Israel_Silva

get the data inside the attribute

@Israel_Silva

CNPJ value

CNPJ is an element

@Israel_Silva

when I try to specify the element, the result is always Null

we dont know the details, what was done

@Israel_Silva

Using the mentioned tutorial, I couldn’t find the CNPJ value in the XM

as discussed: it was checked and setup the default Namespace:

And when fetching the CNPJ elements the namespace is used:

So we would recommend to incorporate the namespace handling as well in your modelling

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

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

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] In some cases, we can also do: Assign Activity - xnsDefault = xDoc.Root.Name.Namespace Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</…

How to identify the quantity of items in the NFe xml

We would recommend to check first if XML Namespaces are to handle: XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types) - Help / Community - UiPath Community Forum Maybe you can share the XML as textfile with us

[Israel_Silva]

Thank you very much, in this case I need to get the second number, but when I put it in a for each it brings me a whole string:04895728000180

How do I get just the numbers without using regex, how?

[ppr (Peter Preuss)]

we would loop over the descendants return
xDoc.root.Descendants(xnsDefault + "CNPJ").
Or
Access directly the second one
Or
catch all values

Find some samples: