Expression to read XML attribute value in Logic Apps

Question

In a Logic Apps For Each, I am iterating over part of an XML document that has, in part:

<Part ref="1">

I want to read out the attribute value only. In this case, "1". I have tried:

xpath(xml(item()),'Part/@ref')

and I get

["ref=\"1\""]

With

first(xpath(xml(item()),'Part/@ref'))

I get

ref="1"

I have tried incorporating string() and value() functions to no avail. What is the proper way to read out just the value?

Gilles Quénot · Accepted Answer · 2018-02-21 22:54:23Z

3

Try this xpath expression :

'string(//Part/@ref)'

answered Feb 21, 2018 at 22:54

Gilles Quénot

188k43 gold badges232 silver badges229 bronze badges

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

Comments

felixmondelo · Accepted Answer · 2018-02-22 10:58:21Z

0

You have to use this expression in Code View:

@xpath(xml(item()), 'string(/*[local-name()=\"Part\" and namespace-uri()=\"\"]/@*[local-name()=\"ref\" and namespace-uri()=\"\"])')

answered Feb 22, 2018 at 10:58

felixmondelo

1,4921 gold badge13 silver badges27 bronze badges

Thank you felixmondelo. That does work for me. Specifically in code view I used:

"@{xpath(xml(item()), 'string(/*[local-name()=\"Part\" and namespace-uri()=\"\"]/@*[local-name()=\"ref\" and namespace-uri()=\"\"])')}"

or in designer:

xpath(xml(item()), 'string(/*[local-name()="Part" and namespace-uri()=""]/@*[local-name()="ref" and namespace-uri()=""])')

But, I am using as successfully the suggestion from Gilles Quenot as it is much simpler and I have to document and explain for others.

Yes, I agree - both are correct. I wish I could mark both as correct.