How to parse nested XML in C#

Question

I'm working with an API and retrieving the data in XML. Here's my XML:

<RTT>
  <AgencyList>
    <Agency Name="Caltrain" HasDirection="True" Mode="Rail">
      <RouteList>
        <Route Name="BABY BULLET" Code="BABY BULLET">
          <RouteDirectionList>
            <RouteDirection Code="SB2" Name="SOUTHBOUND TO TAMIEN">
              <StopList>
                <Stop name="Sunnyvale Caltrain Station" StopCode="70222">
                  <DepartureTimeList/>
                </Stop>
              </StopList>
            </RouteDirection>
            <RouteDirection Code="NB" Name="NORTHBOUND TO SAN FRANCISCO">
              <StopList>
                <Stop name="Sunnyvale Caltrain Station" StopCode="70221">
                  <DepartureTimeList>
                    <DepartureTime>69</DepartureTime>
                  </DepartureTimeList>
                </Stop>
              </StopList>
            </RouteDirection>
          </RouteDirectionList>
        </Route>
        <Route Name="LIMITED" Code="LIMITED">...</Route>
        <Route Name="LOCAL" Code="LOCAL">...</Route>
      </RouteList>
    </Agency>
  </AgencyList>
</RTT>

Not every DepartureTimeList will have a DepartureTime child node. Here's what I got so far, which retrieves the Route name:

List<string> trainType = new List<string>();
XDocument doc = XDocument.Load("http://services.my511.org/Transit2.0/GetNextDeparturesByStopName.aspx?token=0f01ac4a-bc16-46a5-8527-5abc79fee435&agencyName=Caltrain&stopName=" + DropDownList1.SelectedItem.Text.ToString());
doc.Save("times.xml");
string feed = doc.ToString();


XmlReader r = XmlReader.Create(new StringReader(feed));
r.ReadToFollowing("RouteList");
if (r.ReadToDescendant("Route"))
{
    do
    {
        trainType.Add(r.GetAttribute("Name"));
    } while (r.ReadToNextSibling("Route"));
}

I'm mostly interested in the departure time (if it exists) and I've been struggling all afternoon to try and parse it.

Did you try using LINQ to XML for query instead?

MarcinJuraszek
– MarcinJuraszek

2013-11-04 03:35:54 +00:00
Commented Nov 4, 2013 at 3:35 — MarcinJuraszek
– MarcinJuraszek, Commented Nov 4, 2013 at 3:35
I've never actually used LINQ to XML for parsing XML.

Amanda_Panda
– Amanda_Panda

2013-11-04 03:40:38 +00:00
Commented Nov 4, 2013 at 3:40 — Amanda_Panda
– Amanda_Panda, Commented Nov 4, 2013 at 3:40
Note that ASP.NET is clearly not relevant to this question.

John Saunders
– John Saunders

2013-11-04 05:50:51 +00:00
Commented Nov 4, 2013 at 5:50 — John Saunders
– John Saunders, Commented Nov 4, 2013 at 5:50

deathismyfriend · Accepted Answer · 2013-11-04 03:25:23Z

2

Try this... Hopefully this will do it.

    XmlDocument doc = new XmlDocument();
    doc.Load("xml path");
    XmlNode node = doc.SelectSingleNode("/RTT");
    foreach (XmlNode nodes in node.SelectNodes(
        "/AgencyList/Agency Name/RouteList/Route"))
    {
        trainType.Add(r.GetAttribute("Name"));
        XmlNode s = nodes.SelectSingleNode("Route Name/RouteDirectionList/RouteDirection Code/StopList/Stop");
        if (s != null && s["DepartureTimeList"].HasChildNodes)
        {
            // do stuff here
        }
    }

edited Nov 4, 2013 at 3:25

answered Nov 3, 2013 at 22:11

deathismyfriend

2,2022 gold badges20 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How to parse nested XML in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related