How to use xpath when the xml contains namespaces ?

(0) Share

Report

Posted on by bouillons

302

I have an xml that contains namespaces and prefixes. I'd like to extract data from it using an xpath. When I try my xpath statement on the same xml from which I removed all namespaces and prefixes it works. Where can I find more information on the proper use and syntax for this scenario ?

This works:

xpath(outputs('Compose_Points_of_Sales_as_xml'),'string(/list/item[starts-with(POSNr,"0002")]/Location)')

This doesn't work:

xpath(outputs('Compose_Points_of_Sales_as_xml'),'string(/d:list/d:item[starts-with(d:POSNr,"0002")]/d:Location)')

Stephane

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

thepenguin 50 on at

Like (0)

Report
Copy link

Link copied!
Hi, I replied to your other post before I saw that you opened this thread. PA seems to be happier working with local names which is a bit annoying but gets the job done. I am by no means an expert in xml, but doing it like this works in both xpather and powerautomate:

xpath(outputs('Compose'),'//*[local-name()="properties"]/*[local-name()="POSNr" and starts-with(text(), "0002")]/../*[local-name()="Location"]/text()')

Was this reply helpful? Yes No