xpath logic app help

Question

I am trying to run an xpath and set a variable that I have previously intialized and running into issues with no value being provided.

Here is the xml example that is being retured via a HTTP Post:

<?xml version="1.0" encoding="utf-8"?>
<buyer_addedit_response xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://cakemarketing.com/api/1/">
<success>true</success>
<message>Buyer (29) Created Successfully</message>
<row_count>0</row_count>
<buyer_id>29</buyer_id>
</buyer_addedit_response>

Here is the xpath I have set in the variable:
xpath(xml(outputs('Compose')),'/buyer_addedit_response/buyer_id[last()]')

The goal is the store the value 29 from the xml abovew in the variable I have created, but instead I am only getting [ ].

Any help would be appreciated.

Answer 1

Hi @ShaneG

Welcome to Microsoft Q&A! Thanks for posting the question.

As your XML response has a namespace you can refer to Example 8 and Example 9 of the xpath document
I have tested it using the string variable content at my end therefore the first parameter of xpath I am converting my string content to XML

xpath(xml(variables('xmlContent')),'string(/[name()="buyer_addedit_response"]/[name()="buyer_id"])')

In your case it would be if you are converting to string or you can use int.
xpath(xml(outputs('Compose')),'string(/[name()="buyer_addedit_response"]/[name()="buyer_id"])')

Hope the above helps you to resolve the issue. Feel free to get back to me if you need any assistance.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.