ansaurus

Question

Parse XML document

Answer 1

+4 A:

What version of the .Net framework are you using? Is LINQ available to you? If it is I would use that to pull out the values as it is a little nicer to work with. For a really nice example of LINQ have a look here:

http://weblogs.asp.net/scottgu/archive/2007/08/07/using-linq-to-xml-and-how-to-build-a-custom-rss-feed-reader-with-it.aspx

DeanMc 2010-06-14 16:41:57

Answer 2

+4 A:

Amount is not an attribute, it's a child element.

The according xpath-query would be /ItemLookupResponse/Items/Item/ItemAttributes/ListPrice/Amount.

XPathNodeIterator ListPrice = nav.Select("/ItemLookupResponse/Items/Item/ItemAttributes/ListPrice/Amount");

Response.Write(ListPrice.Value);

Femaref 2010-06-14 16:47:27

I haven't throw together a test harness, so I don't know if this applies, but XPath is also picky about namespaces. I don't know if the XPathNavigator automagically handles a default namespace as expected in this code.

Toby 2010-06-14 16:56:36

The xpath is correct (http://xpathvisualizer.codeplex.com/ is a great tool for testing it). I have to admit though, I'm not very into the deeper details of xml.

Femaref 2010-06-14 17:01:08

That won't work, since you're not taking into account the XML namespace on the document!

marc_s 2010-06-14 19:31:03

could you help and edit the right version in? As I said, I'm not that well into the theory behind it. Would appreciate it.

Femaref 2010-06-14 19:35:56

Answer 3

+2 A:

You're not paying attention to the XML namespace(s) in the XML document (and neither are the other answers provided):

<ItemLookupResponse 
     xmlns="http://webservices.amazon.com/AWSECommerceService/2009-03-31"&gt;

You need to take that into account!

XPathDocument Doc = new XPathDocument(@"D:\amazon.xml");

XPathNavigator nav = Doc.CreateNavigator();

// add a XML namespace manager - pick any prefix you want        
XmlNamespaceManager mngr = new XmlNamespaceManager(nav.NameTable);
mngr.AddNamespace("az", "http://webservices.amazon.com/AWSECommerceService/2009-03-31");

// use that XML namespace prefix to select
var ListPrice = nav.Select("/az:ItemLookupResponse/az:Items/az:Item/az:ItemAttributes/az:ListPrice", mngr);

UPDATE: if you want to explore the child nodes below your ListPrice node, you can do something like this:

var curr = ListPrice.Current;

if(ListPrice.MoveNext())
{
    var lpc = ListPrice.Current;

    if(lpc.MoveToFirstChild())
    {
       var node = lpc.Name + "/" + lpc.Value;

       while(lpc.MoveToNext())
       {
           node = lpc.Name + "/" + lpc.Value;
       }
    }
}

to iterate through all child nodes under <ListPrice> and get their name and value.

marc_s 2010-06-14 17:07:26

When I put a breakpoint on var ListPrice - new nav...... and step through it, I can see the piece of data I need in the results view collection - how do I get it?

Neil 2010-06-14 17:57:57

@Neil: updated my answer showing how to access the details....

marc_s 2010-06-14 21:02:35

ansaurus

tags:

views:

answers:

Parse XML document

related questions