Generate Xpath

[agathiyanv (Agathiyan)]

In my XML file , each tag is coming with expanded nms prefixs and I need to extract the data from the xml.
But Execute Xpath activity is not accepting these Xpath and I don’t know how to extract the data.

[omer.ozturk (Ömer Öztürk)]

Hi @agathiyanv,

In this video, he talks about the xml and xpath relationship, and then shows how to run XPath on UiPath. It might work for you.

How to write Xpath and EXECUTE Xpath expression in UiPath | RPA LEARNERS

Kind Regards

[agathiyanv (Agathiyan)]

I have an issue with this Execute Xpath activity. It won’t allow the nms perfix and extended nms prefix

[ppr (Peter)]

it’s about XML Namespaces which need to be handled

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] Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</productVersion>] } xDoc.Descendants(xnsDefault + "productVersion").First().Value "123" xDoc.…

and for XPath we can use the 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 …

in some cases, we can work with the local name only like

Execute xpath in studio

it was necessairy to fix the xml (some tags were not properly closed) Analysis: [grafik] so we do know which namespace we have to configure [grafik] and we can do the retrieval with the following options: [grafik] XPath: [grafik] or with the usage of a namespace manager currently I am working on a custom library (Reply XMLToolBox Activities) to dynamize it and making it more easy. But there are some XML specifics to handle as well. So we would recommend for XML Beginers to configure…

[agathiyanv (Agathiyan)]

How we can handle the name space while passing the Xpath in Execute Xpath Activity?

[ppr (Peter)]

Kindly note: our first and second suggested approaches did not used the Execute XPath Activity

@agathiyanv

How we can handle the name space while passing the Xpath in Execute Xpath Activity?

the docu gives us not any hint on this and also the internal implementation is unclear / hidden for us

Execute XPath

feel free to provide a feedback to UiPath team by posting a feedback on this here

As mentioned as the third option and depending on your XML structures you can check if setting up a statement with the local-name() approach will serve.

We assume that you are aware of / had researched the concept of the XML Namespaces. In case further help is needed then please share with us the XML data and a description of the expected output with us.

[agathiyanv (Agathiyan)]

how to work with xml tag which is associated by its namespaces.I was reading about some post to use “//*” but I am not sure how to use this in ExecuteXpath activity.