Parsing XML with xpath using dynamic XML string

(0) Share

Report

Posted on by famcanico10

Hi,

I'm trying to parse an XML string value from the "text" field under "post" entity in Dynamics 365.

Here's is the sample value of the field:

"<?xml version="1.0" encoding="utf-16"?><pi id="Account.Create.Post" icon="0" ya="1"><ps><p type="1" otc="8" id="ff87e0f2-813f-eb11-bf68-000d3a3abbc3">David So</p></ps></pi>"

I'm assigning that value to a Compose step then uses another Compose (Compose 2) step to parse it using xpath

I am trying to get the string value, David So, of the p node but I'm getting this error:

is there anything wrong with the syntax of the expression I'm using?

I'd appreciate any feedback on this. thank you.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report
@famcanico10 I was able to extract the information you need.

xpath(xml(outputs('Compose')),'string(//p)')
Output :

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report

@famcanico10 I am also facing same issue with <?xml version="1.0" encoding="utf-16"?> but if I change it to <?xml version="1.0" encoding="utf-8"?> it just works fine. So it looks some issue with the encoding tag if possible change it to utf-8 and try and it should work.

I could not find any example of documentation where utf-16 was used or demonstrated, but feel free to go through below links and confirm again.

More details about Xpath function, please check the following article:
https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#x...

More details about Xpath examples, please check the following article:
https://msdn.microsoft.com/en-us/library/ms256086(v=vs.110).aspx

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No