Solved

XML/ASP/VBS Identifying a Value of a Child node

Posted on 2009-04-14
2
402 Views
Last Modified: 2012-05-06
Hi Guys,

Can someone please help me understand the following:

I get a SOAP request back from a 3rd party and I need to get the following info:

EmailAddress, Name, and the [SubscriberCustomField] MemberNo.  I can get the first two with the attached code however I don't know the syntax to search through the node "SubscriberCustomField" and find the <value> where the <key> = "MemberNo".

Can someone point me in the right direction please?

Cheers!
JetGrrrL


Set objSubs = XmlDoc.selectNodes("//Subscriber")
For Each objSubInfo In objSubs
   Set colInfo = objSubInfo.childNodes
   Response.write "Email:", colInfo.Item(0).Text
   Response.write "Name:", colInfo.Item(1).Text
Next
 
 
<Subscribers.GetBouncedResponse xmlns="http://sadsdsddsfsdf">
	<Subscribers.GetBouncedResult>
	<Subscriber>
		<EmailAddress>random@here.com</EmailAddress>
		<Name>Random</Name>
		<Date>21-12-2009</Date>
		<State>NSW</State>
		<SubscriberCustomField>
			<Key>MemberNo</Key>
			<Value>123456</Value>
			<Key>MemberType</Key>
			<Value>Green</Value>
		</SubscriberCustomField>
	</Subscriber>
	<Subscriber>
		<EmailAddress>random@here.com.au</EmailAddress>
		<Name>Random3</Name>
		<Date>21-11-2009</Date>
		<State>NSW</State>
		<SubscriberCustomField>
			<Key>MemberNo</Key>
			<Value></Value>
			<Key>MemberType</Key>
			<Value></Value>
		</SubscriberCustomField>
	</Subscriber>
	</Subscribers.GetBouncedResult>
</Subscribers.GetBouncedResponse>

Open in new window

0
Comment
Question by:jetgrrrl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 28

Accepted Solution

by:
sybe earned 500 total points
ID: 24145002
Basically it works the same all the way. Each node can have childnodes, and you can use the same way of coding to loop through it.


Set oSubscriberNodes =  = XmlDoc.selectNodes("//Subscriber")
For each oSingleSubscriberNode in oSubscriberNodes
    Response.write "Email: " & oSingleSubscriberNode.selectSingleNode("EmailAddress").Text & "<br>"
    Response.write "Name: " & oSingleSubscriberNode.selectSingleNode("Name").Text & "<br>"
    Response.write "Date: " & oSingleSubscriberNode.selectSingleNode("Date").Text & "<br>"
    For each oCustomFieldNode In oSingleSubscriberNode.selectSingleNode("SubscriberCustomField")
        Response.write "Customfield, Name = " oCustomFieldNode.Name & ", Value: " & oCustomFieldNode.Name & "<br>"
    Next
Next

Open in new window

0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question