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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with xpath function	Phanikumar	Biztalk	1	May 22nd, 2008 02:32 AM
TRANSLATE FUNCTION INSIDE XPATH	pallone	XSLT	8	February 8th, 2008 05:30 PM
Formating xpath function result number	ronisc	XSLT	4	December 20th, 2006 09:04 AM
Sum function and XPath problems	tslag	XSLT	2	June 26th, 2006 10:23 AM
Xpath: sum function	gracehanh	XSLT	13	September 27th, 2005 09:30 AM