How I can get the value from field in schema by XPATH

Question

I am using WCF Test Client, and I am trying to start a wcf Service by Orchestra in Biztalk. In the Orchestra I want to get a value from field in schema by XPATH. but I could not to do it

myPath = @"/*[local-name()='ApplicableChargeResponse' and namespace-uri()='http://xxxxx/xxxxxdtransfer']/*[local-name()='ApplicableChargeResult' and namespace-uri()='http://xxx/xxx]";

myValue = xpath(MsgApplicableChargeDetailsResponce, myPath);

Thank you

Answer 1

Hi Yonial,

Hope you got the below xpath using instentXpath from your xsd schema.

myPath = @"string("/*[local-name()='ApplicableChargeResponse' and namespace-uri()='http://xxxxx/xxxxxdtransfer']/*[local-name()='ApplicableChargeResult' and namespace-uri()='http://xxx/xxx]");

myValue  = xpath(MsgApplicableChargeDetailsResponce, myPath);

___________________________________________________________
If this is helpful or answers your question - please mark as answer and vote as helpful.

---

Raj, http://rajwebjunky.blogspot.com

Answer 2

myValue is Integer.

I tied like this:

myPath = @"/*[local-name()='ApplicableChargeResponse' and namespace-uri()='http://xx/xx]/*[local-name()='ApplicableChargeResult' and namespace-uri()='http://xx/xx]";

myValue = System.Convert.ToInt32(xpath(MsgApplicableChargeDetailsResponce, myPath));

and I get this ERROR:

Unable to cast object of type 'ArrayBasedXmlNodeList' to type 'System.IConvertible'.

Answer 3

is this multiple node element ? if Yes then you need decide which row value need to find it.

You can try with [n] at the end of the xpath. here n represents the row number

myPath = @"/*[local-name()='ApplicableChargeResponse' and namespace-uri()='http://xx/xx]/*[local-name()='ApplicableChargeResult' and namespace-uri()='http://xx/xx][0]"

___________________________________________________________
If this is helpful or answers your question - please mark as answer and vote as helpful.

---

Raj, http://rajwebjunky.blogspot.com

Answer 4

Hi, 

You need to specify which node in nodelist you are interested in.

Please refer to links below,

http://social.msdn.microsoft.com/Forums/ar/biztalkgeneral/thread/cbdd8fbf-5b9b-42e2-af98-7277c1123f1f   &

http://stackoverflow.com/questions/1006283/xpath-select-first-element-with-a-specific-attribute

I hope this helps you.

---

Thanks With Regards,
Shailesh Kawade
MCTS BizTalk Server
Please Mark This As Answer If This Helps You.
http://shaileshbiztalk.blogspot.com/

Answer 5

I Dont think that is this multiple node element, because I have only one element.

In the next picture below, I show you my schema

Answer 6

Hi,

You can test your xpath with some tool,

you can try this, http://www.xpathtester.com/ You just need to specify the xml and xpath.

That way you will get to know what are the value or nodelist you are getting back from xpath.

---

Thanks With Regards,
Shailesh Kawade
MCTS BizTalk Server
Please Mark This As Answer If This Helps You.
http://shaileshbiztalk.blogspot.com/

Answer 7

Can you check the MinOccurs and MaxOccurs of the Node "ApplicableChangeResponse" it should be MinOccurs=1 and MinOccurs=1

---

Raj, http://rajwebjunky.blogspot.com

Answer 8

Thank you,  Your answer was the true..

I learneda new thing,I did not realizeI hadmarked "MinOccurs=1"

Answer 9

Thank you,  Your answer was the true..

I learneda new thing,I did not realizeI hadmarked "MinOccurs=1"

Answer 10

That sounds gr8.

___________________________________________________________

If this is helpful or answers your question - please mark as answer and vote as helpful.

---

Raj, http://rajwebjunky.blogspot.com

Answer 11

Hi YoniAL

It seems you have found your answer, However I would like to suggest you a very good technet wiki "BizTalk Orchestrations XPath: Survival Guide" . Please have a look, It might help you in future.

HTH,Thanks, Naushad (MCC/MCTS) http://alamnaushad.wordpress.com,My New Technet Wiki Article “BizTalk Server: Performance Tuning & Optimization"

If this is helpful or answers your question - please mark accordingly! Please "Vote As Helpful" if this was useful while resolving your question!