Loop through XML document using XPathNavigator

I have the below XML, and I am trying to write values to a CSV file. I am however not sure how to proceed further, with everything I've tried throwing errors. Any assistance is appreciated.

XML:


<?xml version="1.0" encoding="UTF-8"?>
<Envelope>
   <Body>
  <RESULT>
     <SUCCESS>TRUE</SUCCESS>
     <Mailing>
        <MailingId>9285984</MailingId>
        <ReportId>362040252</ReportId>
        <ScheduledTS>2014-08-22 11:44:33.0</ScheduledTS>
        <MailingName>305_ENDS</MailingName>
     </Mailing>
     <Mailing>
        <MailingId>9278770</MailingId>
        <ReportId>361956135</ReportId>
        <ScheduledTS>2014-08-22 09:15:00.0</ScheduledTS>
        <MailingName>141_TSI</MailingName>
        <Visibility>Shared</Visibility>
     </Mailing>
     <Mailing>
        <MailingId>9286460</MailingId>
        <ReportId>362043622</ReportId>
        <ScheduledTS>2014-08-22 12:57:30.0</ScheduledTS>
        <MailingName>301_BRANDREP</MailingName>
     </Mailing>
  </RESULT>
</Body>
</Envelope>

C#:


xpathDoc = HttpHelper.HttpStream(xmlReq, sessionid);

XPathNavigator nav = xpathDoc.CreateNavigator();

var csv = new StringBuilder();

filePath = "C:\Campaigns.csv";

foreach (XPathNavigator node in nav.Select("/Envelope/Body/RESULT/"))
{
string MailingId = ?;
string ReportId = ?;
string ScheduledTS = ?;
string MailingName = ?;

string newLine = string.Format("{0},{1},{2},{3},{4}", MailingId, ReportId, ScheduledTS, MailingName, Environment.NewLine);
csv.Append(newLine);

}

File.WriteAllText(filePath, csv.ToString());

Loop through XML document using XPathNavigator

No comments:

Post a Comment