Problem in Using xpath() function in Biztalk

mamatharocks · May 22nd, 2008, 10:15 AM

I have an xml document which looks as this
<DataItems>
<DataItem>
<ItemName>Web Service Url</ItemName>
<ItemValue>www.Google.com</ItemValue>
</DataItem>
<DataItem>
<ItemName>Password/ItemName>
<ItemValue>Swetha</ItemValue>
</DataItem>
<DataItems>
I want to get the text of ItemValue if i give the text of ItemName
using the xpath() function in Biztalk server.

For example if i give the text of <ItemName> as Web Service Url How to get the corresponding <ItemValue> that is www.Google.com
using xpath() function in Biztalk server.Please give any sugestions.

joefawcett · May 22nd, 2008, 11:03 AM

Code:

/*/DataItem[ItemName = 'Web Service Url']/ItemValue

If the actual document has namespaces then you'll have to use the longer-winded syntax,

Code:

local-name() = 'element name' and namespace-uri() = 'namespace uri''

to identify the elements.u

--

Joe (Microsoft MVP - XML)

oliviajones · September 9th, 2013, 02:57 AM

You want to get the text of ItemValue if u give the text of ItemName
using the xpath() function in Biztalk server than

1) Add a breadpoint in the orchestration.

2) Extract the BizTalk messaging and see whether the field is present in the incoming message. If so, than use the "Instance XPath" of the retrieved message using any tool.

http://www.athenainfotech.co.uk/managed-b2b-services