Asp XML Parsing

Question

I am new to asp and have a deadline in the next few days. i receive the following xml from within a webservice response.

print("<?xml version="1.0" encoding="UTF-8"?>
<user_data>
<execution_status>0</execution_status>
<row_count>1</row_count>
<txn_id>stuetd678</txn_id>
<person_info>
    <attribute name="firstname">john</attribute>
    <attribute name="lastname">doe</attribute>
    <attribute name="emailaddress">[email protected]</attribute>
</person_info>
</user_data>");

How can i parse this xml into asp attributes?

Any help is greatly appreciated

Thanks Damien

On more analysis, some soap stuff is also returned as the aboce response is from a web service call. can i still use lukes code below?

Community · Accepted Answer · 2017-05-23 12:09:11Z

9

You need to read about MSXML parser. Here is a link to a good all-in-one example http://oreilly.com/pub/h/466

Some reading on XPath will help as well. You could get all the information you need in MSDN.

Stealing the code from Luke excellent reply for aggregation purposes:

Dim oXML, oNode, sKey, sValue

Set oXML = Server.CreateObject("MSXML2.DomDocument.6.0") 'creating the parser object
oXML.LoadXML(sXML) 'loading the XML from the string

For Each oNode In oXML.SelectNodes("/user_data/person_info/attribute")
  sKey = oNode.GetAttribute("name")
  sValue = oNode.Text
  Select Case sKey
    Case "execution_status"
    ... 'do something with the tag value
    Case else
    ... 'unknown tag
  End Select
Next

Set oXML = Nothing

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Sep 18, 2008 at 17:32

Ilya Kochetov

18.5k6 gold badges48 silver badges62 bronze badges

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

1 Comment

JoJo Over a year ago

I don't understand.. you never do anything with sValue ??

Luke Bennett · Accepted Answer · 2008-09-18 17:36:33Z

6

By ASP I assume you mean Classic ASP? Try:

Dim oXML, oNode, sKey, sValue

Set oXML = Server.CreateObject("MSXML2.DomDocument.4.0")
oXML.LoadXML(sXML)

For Each oNode In oXML.SelectNodes("/user_data/person_info/attribute")
  sKey = oNode.GetAttribute("name")
  sValue = oNode.Text
  ' Do something with these values here
Next

Set oXML = Nothing

The above code assumes you have your XML in a variable called sXML. If you are consuming this via an ServerXMLHttp request, you should be able to use the ResponseXML property of your object in place of oXML above and skip the LoadXML step altogether.

answered Sep 18, 2008 at 17:36

Luke Bennett

32.9k3 gold badges33 silver badges57 bronze badges

Comments

Paulj · Accepted Answer · 2008-09-18 17:33:56Z

0

You could try loading the xml into the xmldocument object and then parse it using it's methods.

answered Sep 18, 2008 at 17:33

Paulj

3,2443 gold badges27 silver badges30 bronze badges

Collectives™ on Stack Overflow

Asp XML Parsing

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related