XPath expressions with namespaces

[lena2505 (Lena E)]

Hi there!
I am currently facing a problem when trying to execute XPath expressions in UiPath using “execute XPath” activity. Output always states “Execute XPath: Namespace Manager or XsltContext needed. This query has a prefix, variable, or user-defined function.”

The xml files from which data has to be extracted use namespaces, e.g.: (german invoice format standard ZUGFeRD)

Does someone know how to add the namespace to enable XPath expressions?

Example XPath expression: “//ram:Name”

Thanks in advance!
Kind regards

[J0ska]

Maybe this can help?

Execute xpath in studio

This is my test xml, which mirrors the original. TestXml.xml (352 Bytes) Of course, the nscase variable is of type xnamespace, is it correct to have the hardcoded namespace value? Or can this vary and is it better to retrieve it dynamically? [image] Appreciate your help.

[ppr (Peter Preuss)]

we can do it by using 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 …

[lena2505 (Lena E)]

thank you guys, I was able to figure it out