Azure Logic App - xpath for xml with namespace prefix

Question

In my logic app i am using xpath() function to get the value of . I have tried different xpaths but getting error

'The template language function 'xpath' parameters are invalid: the 'xpath' parameter must be a supported, well formed XPath expression. Please see https://aka.ms/logicexpressions#xpath for usage details.'.

i have the following xml:

I have tried:

@xpath(xml(<YourMessage>), '/*[local-name()=\"Envelope\" and namespace-uri()=\"http://schemas.xmlsoap.org/soap/envelope/\"]/*[local-name()=\"Body\" and namespace-uri()=\"http://schemas.xmlsoap.org/soap/envelope/\"]')
@xpath(xml(<YourMessage>), 'string(/*[local-name()=\"Envelope\" and namespace-uri()=\"http://schemas.xmlsoap.org/soap/envelope/\"]/*[local-name()=\"Body\" and namespace-uri()=\"http://schemas.xmlsoap.org/soap/envelope/\"])')

but getting the same error

DTRT · Accepted Answer · 2018-05-06 18:55:01Z

2

You might be better off converting to JSON and working with the data in that format. At least you can get rid of all the silly namespace complexities that way.

LogicApps is JSON focused internally so doing so would be slightly more 'correct' anyway.

You can find samples at: JSONPath - XPath for JSON

And an evaluator: JSONPath Online Evaluator

edited May 6, 2018 at 18:55

answered May 1, 2018 at 15:04

DTRT

11k15 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Adeel bin Khalid Over a year ago

any chance you could post an example? I am relatively new to LogicApps

AdamKent Over a year ago

In a logic app, you can convert XML to JSON and then select from the resulting object, but that's only useful if you have a direct path to the value you need to extract. Logic Apps don't have a built-in JSONPath implementation (or jq or jsonata or ...). Also beware of converting XML to JSON where you're expecting an array (eg. purchase order lines). If there's only one record, it'll be a JSON object rather than an array with a single item.

Steven Van Eycken · Accepted Answer · 2018-05-01 08:23:34Z

2

You can include the namespace in your xpath using this expression:

@xpath(YOURBODY, '/*[local-name()=\"Envelope\" and namespace-uri()=\"http://schemas.xmlsoap.org/soap/envelope/\"]/*[local-name()=\"Body\" and namespace-uri()=\"http://schemas.xmlsoap.org/soap/envelope/\"]')

answered May 1, 2018 at 8:23

Steven Van Eycken

5663 silver badges8 bronze badges

1 Comment

Adeel bin Khalid Over a year ago

I am getting the same error. Have a look at the screenshot

Adeel bin Khalid · Accepted Answer · 2018-05-05 05:10:22Z

1

I did what Johns-305 suggested.

json(<Output>)['soap:Envelope']['soap:Body']

answered May 5, 2018 at 5:10

Adeel bin Khalid

551 silver badge6 bronze badges

Comments

AdamKent · Accepted Answer · 2022-02-11 10:38:55Z

Coming to this late, but the error is because you've escaped the double-quotes in the designer (which automagically escapes double-quotes for you).

This is from the Reference guide to expression functions for Azure Logic Apps and Power Automate:

Important

If you work in code view, escape the double quotation mark (") by using the backslash character (\). For example, you need to use escape characters when you serialize an expression as a JSON string. However, if you're work in the Logic App Designer or expression editor, you don't need to escape the double quotation mark because the backslash character is added automatically to the underlying definition, for example:

Code view: xpath(xml(body('Http')), '/*[name()=\"file\"]/*[name()=\"location\"]')

Expression editor: xpath(xml(body('Http')), '/*[name()="file"]/*[name()="location"]')

Paco de la Cruz · Accepted Answer · 2018-05-03 01:10:31Z

0

If what you need is the value of one of the internal nodes, you can try:

@xpath(<YourMessage>, 'string(/*[local-name()=\"Envelope\" and namespace-uri()=\"http://schemas.xmlsoap.org/soap/envelope/\"]/*[local-name()=\"Body\" and namespace-uri()=\"http://schemas.xmlsoap.org/soap/envelope/\"]/*[name()=\"SearchByABNv201408Response\"]/*[name()=\"ABRPayloadSearchResults\"]/*[name()=\"Request\"]/*[name()=\"identifierSearchRequest\"]/*[name()=\"authenticationGUID\"])')

I hope this points you in the right direction

answered May 3, 2018 at 1:10

Paco de la Cruz

2,17416 silver badges24 bronze badges

1 Comment

Adeel bin Khalid Over a year ago

I am getting the same error. Have a look at the screenshot

Jairo Villarreal · Accepted Answer · 2024-05-15 15:40:11Z

0

You don't really need to scape the " characters, from the portal editor, you can simply put the xpath like this:

xpath(xml(body('Transform_XML')), '/*[local-name()="root" and namespace-uri()=""]/*[local-name()="X12_00401_210" and namespace-uri()="http://schemas.microsoft.com/BizTalk/EDI/X12/2006"]')

answered May 15, 2024 at 15:40

Jairo Villarreal

313 bronze badges

Collectives™ on Stack Overflow

Azure Logic App - xpath for xml with namespace prefix

6 Answers 6

2 Comments

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related