Parsing XML String Returned from WebRequest

-3

I have an xml string returned from a HTTPWebRequest which I need to parse through to obtain the correct mailing address. The tag contains a child tag of which will either be Primary or Alternate. If the tag equals Alternate I will use the address values for that CustAddr, but if there is no Alternate then I will use the primary as the default. In C# how would I do this using the System.Xml.Linq library?

<Customer>

 <CustInfo>

  <CustAddr>

   <FullName>MY PRIMARY NAME</FullName>

   <Addr1>PRIMARY ADDRESS1</Addr1>

   <Addr2>PRIMARY ADDRESS2</Addr2>

   <Addr3>PRIMARY ADDRESS3</Addr3>

   <Addr4></Addr4>

   <Addr5></Addr5>

   <AddrCode>PRIMARY</AddrCode>

  </CustAddr>

  <CustAddr>

   <FullName>MY ALTERNATE ADDRESS LINE 1</FullName>

   <Addr1>TEST ALT ADDRESS LINE1</Addr1>

   <Addr2>TEST ALT ADDRESS LINE2</Addr2>

   <Addr3>TEST ALT ADDRESS LINE3</Addr3>

   <Addr4></Addr4>

   <Addr5></Addr5>

   <AddrCode>ALTERNATE</AddrCode>

  </CustAddr>

 </CustInfo>

</Customer>

asked Nov 20 at 22:32

Workflow_Automation

explain better the issue here
– oetoni
Nov 20 at 23:49

add a comment |

-3

<Customer>

 <CustInfo>

  <CustAddr>

   <FullName>MY PRIMARY NAME</FullName>

   <Addr1>PRIMARY ADDRESS1</Addr1>

   <Addr2>PRIMARY ADDRESS2</Addr2>

   <Addr3>PRIMARY ADDRESS3</Addr3>

   <Addr4></Addr4>

   <Addr5></Addr5>

   <AddrCode>PRIMARY</AddrCode>

  </CustAddr>

  <CustAddr>

   <FullName>MY ALTERNATE ADDRESS LINE 1</FullName>

   <Addr1>TEST ALT ADDRESS LINE1</Addr1>

   <Addr2>TEST ALT ADDRESS LINE2</Addr2>

   <Addr3>TEST ALT ADDRESS LINE3</Addr3>

   <Addr4></Addr4>

   <Addr5></Addr5>

   <AddrCode>ALTERNATE</AddrCode>

  </CustAddr>

 </CustInfo>

</Customer>

asked Nov 20 at 22:32

Workflow_Automation

explain better the issue here
– oetoni
Nov 20 at 23:49

add a comment |

-3

<Customer>

 <CustInfo>

  <CustAddr>

   <FullName>MY PRIMARY NAME</FullName>

   <Addr1>PRIMARY ADDRESS1</Addr1>

   <Addr2>PRIMARY ADDRESS2</Addr2>

   <Addr3>PRIMARY ADDRESS3</Addr3>

   <Addr4></Addr4>

   <Addr5></Addr5>

   <AddrCode>PRIMARY</AddrCode>

  </CustAddr>

  <CustAddr>

   <FullName>MY ALTERNATE ADDRESS LINE 1</FullName>

   <Addr1>TEST ALT ADDRESS LINE1</Addr1>

   <Addr2>TEST ALT ADDRESS LINE2</Addr2>

   <Addr3>TEST ALT ADDRESS LINE3</Addr3>

   <Addr4></Addr4>

   <Addr5></Addr5>

   <AddrCode>ALTERNATE</AddrCode>

  </CustAddr>

 </CustInfo>

</Customer>

asked Nov 20 at 22:32

Workflow_Automation

<Customer>

 <CustInfo>

  <CustAddr>

   <FullName>MY PRIMARY NAME</FullName>

   <Addr1>PRIMARY ADDRESS1</Addr1>

   <Addr2>PRIMARY ADDRESS2</Addr2>

   <Addr3>PRIMARY ADDRESS3</Addr3>

   <Addr4></Addr4>

   <Addr5></Addr5>

   <AddrCode>PRIMARY</AddrCode>

  </CustAddr>

  <CustAddr>

   <FullName>MY ALTERNATE ADDRESS LINE 1</FullName>

   <Addr1>TEST ALT ADDRESS LINE1</Addr1>

   <Addr2>TEST ALT ADDRESS LINE2</Addr2>

   <Addr3>TEST ALT ADDRESS LINE3</Addr3>

   <Addr4></Addr4>

   <Addr5></Addr5>

   <AddrCode>ALTERNATE</AddrCode>

  </CustAddr>

 </CustInfo>

</Customer>

c# xml parsing

asked Nov 20 at 22:32

Workflow_Automation

asked Nov 20 at 22:32

Workflow_Automation

asked Nov 20 at 22:32

Workflow_Automation

asked Nov 20 at 22:32

Workflow_Automation

asked Nov 20 at 22:32

Workflow_Automation

explain better the issue here
– oetoni
Nov 20 at 23:49

add a comment |

explain better the issue here
– oetoni
Nov 20 at 23:49

explain better the issue here
– oetoni
Nov 20 at 23:49

add a comment |

1 Answer
1

active

oldest

votes

Try following xml linq. I used Regex to get addresses. Needed to avoid getting AddrCode as part of the address.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Xml;

using System.Xml.Linq;

using System.Text.RegularExpressions;

using System.IO;



namespace ConsoleApplication1

{

    class Program

    {

        const string FILENAME = @"c:temptest.xml";

        static void Main(string args)

        {

            string xml = File.ReadAllText(FILENAME);



            //use parse to take string returned from request

            XDocument doc = XDocument.Parse(xml);



            KeyValuePair<string, List<string>> results = doc.Descendants("CustAddr").Where(x => (string)x.Element("AddrCode") == "PRIMARY")

                .Select(x => new KeyValuePair<string, List<string>>((string)x.Element("FullName"), x.Elements().Where(y => Regex.IsMatch(y.Name.LocalName, @"Addrd")).Select(y => (string)y).ToList())).FirstOrDefault(); 



        }

    }

}

edited Nov 21 at 2:28

answered Nov 21 at 2:22

jdweng

16.7k2717

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53402589%2fparsing-xml-string-returned-from-webrequest%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

Try following xml linq. I used Regex to get addresses. Needed to avoid getting AddrCode as part of the address.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Xml;

using System.Xml.Linq;

using System.Text.RegularExpressions;

using System.IO;



namespace ConsoleApplication1

{

    class Program

    {

        const string FILENAME = @"c:temptest.xml";

        static void Main(string args)

        {

            string xml = File.ReadAllText(FILENAME);



            //use parse to take string returned from request

            XDocument doc = XDocument.Parse(xml);



            KeyValuePair<string, List<string>> results = doc.Descendants("CustAddr").Where(x => (string)x.Element("AddrCode") == "PRIMARY")

                .Select(x => new KeyValuePair<string, List<string>>((string)x.Element("FullName"), x.Elements().Where(y => Regex.IsMatch(y.Name.LocalName, @"Addrd")).Select(y => (string)y).ToList())).FirstOrDefault(); 



        }

    }

}

edited Nov 21 at 2:28

answered Nov 21 at 2:22

jdweng

16.7k2717

add a comment |

Try following xml linq. I used Regex to get addresses. Needed to avoid getting AddrCode as part of the address.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Xml;

using System.Xml.Linq;

using System.Text.RegularExpressions;

using System.IO;



namespace ConsoleApplication1

{

    class Program

    {

        const string FILENAME = @"c:temptest.xml";

        static void Main(string args)

        {

            string xml = File.ReadAllText(FILENAME);



            //use parse to take string returned from request

            XDocument doc = XDocument.Parse(xml);



            KeyValuePair<string, List<string>> results = doc.Descendants("CustAddr").Where(x => (string)x.Element("AddrCode") == "PRIMARY")

                .Select(x => new KeyValuePair<string, List<string>>((string)x.Element("FullName"), x.Elements().Where(y => Regex.IsMatch(y.Name.LocalName, @"Addrd")).Select(y => (string)y).ToList())).FirstOrDefault(); 



        }

    }

}

edited Nov 21 at 2:28

answered Nov 21 at 2:22

jdweng

16.7k2717

add a comment |

Try following xml linq. I used Regex to get addresses. Needed to avoid getting AddrCode as part of the address.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Xml;

using System.Xml.Linq;

using System.Text.RegularExpressions;

using System.IO;



namespace ConsoleApplication1

{

    class Program

    {

        const string FILENAME = @"c:temptest.xml";

        static void Main(string args)

        {

            string xml = File.ReadAllText(FILENAME);



            //use parse to take string returned from request

            XDocument doc = XDocument.Parse(xml);



            KeyValuePair<string, List<string>> results = doc.Descendants("CustAddr").Where(x => (string)x.Element("AddrCode") == "PRIMARY")

                .Select(x => new KeyValuePair<string, List<string>>((string)x.Element("FullName"), x.Elements().Where(y => Regex.IsMatch(y.Name.LocalName, @"Addrd")).Select(y => (string)y).ToList())).FirstOrDefault(); 



        }

    }

}

edited Nov 21 at 2:28

answered Nov 21 at 2:22

jdweng

16.7k2717

Try following xml linq. I used Regex to get addresses. Needed to avoid getting AddrCode as part of the address.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Xml;

using System.Xml.Linq;

using System.Text.RegularExpressions;

using System.IO;



namespace ConsoleApplication1

{

    class Program

    {

        const string FILENAME = @"c:temptest.xml";

        static void Main(string args)

        {

            string xml = File.ReadAllText(FILENAME);



            //use parse to take string returned from request

            XDocument doc = XDocument.Parse(xml);



            KeyValuePair<string, List<string>> results = doc.Descendants("CustAddr").Where(x => (string)x.Element("AddrCode") == "PRIMARY")

                .Select(x => new KeyValuePair<string, List<string>>((string)x.Element("FullName"), x.Elements().Where(y => Regex.IsMatch(y.Name.LocalName, @"Addrd")).Select(y => (string)y).ToList())).FirstOrDefault(); 



        }

    }

}

edited Nov 21 at 2:28

answered Nov 21 at 2:22

jdweng

16.7k2717

edited Nov 21 at 2:28

answered Nov 21 at 2:22

jdweng

16.7k2717

answered Nov 21 at 2:22

jdweng

16.7k2717

answered Nov 21 at 2:22

jdweng

16.7k2717

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Tukukkk