Get Value From XML Object

Question

I am struggling to find out how to pull out the tracking number(s) values from the following XML:

 <ShipmentHeader>
    <DocumentID>62017836-1</DocumentID>
    <DocumentReference type="CustomerSuppliedReference">
       <DocumentID>
          <ID>10532</ID>
       </DocumentID>
    </DocumentReference>
    <Status>
       <Code/>
       <Description languageID="en-us"/>
    </Status>
    <ActualShipDateTime>2023-06-07T09:16:33-04:00</ActualShipDateTime>
    <ShippingMethod>CHEAPEST METHOD W/FIRST CLASS</ShippingMethod>
    <DocumentReference type="TrackingNumber">
       <TrackingNumber>9200190233107605458375</TrackingNumber>
    </DocumentReference>
 </ShipmentHeader>

From what I have seen, it seems that I must use reflection, but I just cannot get it to work.
Can anyone give me any pointers please?

"From what i have seen it seem i must used reflection" - no, definitely not. I suggest you read a tutorial on LINQ to XML, which is a really powerful and easy-to-use XML API. — Jon Skeet, Jun 09 '23 at 13:45
Does this answer your question? [How do I read and parse an XML file in C#?](https://stackoverflow.com/questions/642293/how-do-i-read-and-parse-an-xml-file-in-c) — Progman, Jun 09 '23 at 14:37

Serge · Answer 1 · 2023-06-09T14:23:22.877

1

try this code

    var results = XDocument.Parse(xml)
       .Descendants("TrackingNumber")
       .Select(e => e.Value)
       .FirstOrDefault(); // Or .ToList() maybe

edited Jun 09 '23 at 14:23

answered Jun 09 '23 at 13:52

Serge

40,935
4
18
45

score 0 · Answer 2 · answered Jun 09 '23 at 13:58

A possibly more performant method than @Serge, still using XDocument

XDocument doc = XDocument.Parse(xml);

var result = 
    doc.Root
       .Elements("DocumentReference")
       .Where(e => (string)e.Attribute("type") == "TrackingNumber")
       .SelectMany(e => e.Elements("TrackingNumber"))
       .Select(e => e.Value);

Or you can use XQuery

var result = doc.XPathSelectElements(
    @"/ShipmentHeader/DocumentReference[@type=""TrackingNumber""]/TrackingNumber")
  .Select(e => e.Value);

dotnetfiddle

score 0 · Answer 3 · answered Jun 09 '23 at 14:04

As I understand you are trying to find any "TrackingNumber" element, at any level:

void Main()
{
    string s = @"<ShipmentHeader>
            <DocumentID>62017836-1</DocumentID>
            <DocumentReference type=""CustomerSuppliedReference"">
               <DocumentID>
                  <ID>10532</ID>
               </DocumentID>
            </DocumentReference>
            <Status>
               <Code/>
               <Description languageID=""en-us""/>
            </Status>
            <ActualShipDateTime>2023-06-07T09:16:33-04:00</ActualShipDateTime>
            <ShippingMethod>CHEAPEST METHOD W/FIRST CLASS</ShippingMethod>
            <DocumentReference type=""TrackingNumber"">
               <TrackingNumber>9200190233107605458375</TrackingNumber>
            </DocumentReference>
         </ShipmentHeader>";
         
    var numbers = XElement.Parse(s)
        .Descendants("TrackingNumber")
        .Select(xe => (string)xe);
        
    foreach (var number in numbers)
    {
        Console.WriteLine(number);
    }
}

emrah karaman · Answer 4 · 2023-06-12T10:27:25.463

0

an alternative way;

    XmlDocument xmlDoc = new XmlDocument();
    xmlDoc.LoadXml("your xml");

    XmlNodeList trackingNumberNodes = xmlDoc.SelectNodes("//DocumentReference[@type='TrackingNumber']/TrackingNumber");
    foreach (XmlNode node in trackingNumberNodes)
    {
        Console.WriteLine(node.InnerText);
    }

https://dotnetfiddle.net/N5eNno

edited Jun 12 '23 at 10:27

answered Jun 12 '23 at 10:22

emrah karaman

91
5

Get Value From XML Object

4 Answers4