get values from XML with xpath when having Namespace

Question

I am new to xpath matching. Here I have a method which pass XML contain as string. I convert it into XmlDocument.

public static void getProjectDataInfo(string content) {

            XmlDocument doc = new XmlDocument();
            doc.LoadXml(content);
}

Here is my XML. It has xmlns:my

<?xml version="1.0" encoding="UTF-8"?>
<my:myFields xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-02-03T16:54:46" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xml:lang="en-us">
  <my:Financial>
      <my:Quote>
     <my:CHARGE_TYPE>MRC</my:CHARGE_TYPE>
     <my:Price>463.92</my:Price>
      </my:Quote>
  </my:Financial>
</my:myField>

I just want to get values of

/my:myFields/my:Financial/my:Quote/my:Price

However I unable to get values hence this XML has xmlns.

Please help me.

Typist · Accepted Answer · 2012-11-21 05:48:18Z

5

Use XmlNamespaceManager

XmlNamespaceManager nsmgr = new XmlNamespaceManager(new NameTable());
nsmgr.AddNamespace("ns", "http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-02-03T16:54:46");

var str = doc.XPathSelectElement("/root/ns:myFields/ns:Financial/ns:Quote/ns:Price", nsmgr)
            .ToString(SaveOptions.DisableFormatting);
Console.WriteLine(str);

answered Nov 21, 2012 at 5:48

Typist

1,4849 silver badges14 bronze badges

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

2 Comments

devan Over a year ago

I think we can not get '/root/ns:myFields/ns:Financial/ns:Quote/ns:Price' at one time. Insterd of it I get part by part.

Typist Over a year ago

Yes. We need to get it element by element. I did not dare to execute it. It was a logical error. Thanks.

Pawel · Accepted Answer · 2012-11-21 05:48:17Z

0

You need to tell the XmlDocument what my prefix binds to. You use XmlNamespaceManager to do that. Here is an example http://support.microsoft.com/kb/316913. In your case you would do:

xmlns.AddNamespace("my", "http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-02-03T16:54:46")

answered Nov 21, 2012 at 5:48

Pawel

31.7k4 gold badges76 silver badges106 bronze badges

Comments

Anirudha · Accepted Answer · 2012-11-21 16:40:16Z

0

Use LINQ2XML

XElement doc=XElement.Parse(content);
XNamespace my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-02-03T16:54:46";
var price=doc.Element(my+"myFields").Element(my+"Financial").Element(my+"Quote").Element(my+"Price").Value;

OR[if you want to stick with that OLD thing]

XmlNamespaceManager nsmgr = new XmlNamespaceManager(doc.OwnerDocument.NameTable);
nsmgr.AddNamespace("my", "http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-02-03T16:54:46");
var priceNode = el.SelectNode(@"/my:myFields/my:Financial/my:Quote/my:Price", nsmgr);

edited Nov 21, 2012 at 16:40

answered Nov 21, 2012 at 5:48

Anirudha

32.9k8 gold badges71 silver badges90 bronze badges

Comments

ChinaHelloWorld · Accepted Answer · 2014-12-01 08:53:14Z

0

For Infopath form 2013, it could be as following:

XmlNamespaceManager nsmgr = new XmlNamespaceManager(new NameTable()); nsmgr.AddNamespace("my", "http://schemas.microsoft.com/office/infopath/2003/myXSD/2014-11-10T18:44:26");

XmlNode root = doc.DocumentElement;

XmlNode yourIDNode = root.SelectSingleNode("/my:myFields/my:YourID", nsmgr);

The detail "my" namespace definition, you could download from Share Point Document Library where your infopath form submitted xml data staying. Download one of those saved infopath form xml data files, and open it with notepad, then you wll find it on the top of content.

answered Dec 1, 2014 at 8:53

ChinaHelloWorld

1,0471 gold badge12 silver badges6 bronze badges

Collectives™ on Stack Overflow

get values from XML with xpath when having Namespace

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related