Parsing Data From XML Array?

[GDX]

Hello I am trying to place an XML Response into an array for easy parsing but im

having a very hard time doing this. Can someone please help me? We are using the SOAP

ToolKit with ASP (Not .NET). If you look at the results you will see that i am getting

back the data but now how do i loop through each "Product"? Below is a snippet of the

VBS I wrote:


Request.VBS
----------------------------------------

Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP")
Set objOutputXMLDoc = CreateObject("MSXML.DOMDocument")
Set fileSys = Createobject ("Scripting.FileSystemObject")
set readfile = filesys.OpenTextFile("C:\Request.xml", 1, false)
contents = readfile.ReadAll
Msgbox contents
objXMLHTTP.open "post", "

http://webwarehouse.imcparts.net/webapp/wcs/stores/servlet",

False
objXMLHTTP.setRequestHeader "Content-Type", "text/xml"
objXMLHTTP.send contents

Msgbox objXMLHTTP.ResponseText ' <----Got Back Data Please see below for results

----------------------------------------


Results from Call
-------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>

<soap:Envelope xmlns:n="

http://webservice.imc.com.wsdl/Catalog/"

xmlns:soap="

http://schemas.xmlsoap.org/soap/envelope/"

xmlns:soapenc="

http://schemas.xmlsoap.org/soap/encoding/"

xmlns:xs="

http://www.w3.org/2001/XMLSchema"

xmlns:xsd1="

http://datatype.webservice.imc.com/"

xmlns:xsi="

http://www.w3.org/2001/XMLSchema-instance"><soap:Body

soap:encodingStyle="

http://schemas.xmlsoap.org/soap/encoding/"><n:partnumber

Search><result><xsd1roducts soapenc:arrayType="xsd1roduct[4]"
xsi:type="soapenc:Array"><item><xsd1:id>911395</xsd1:id><xsd1artnum>BH0060
84 </xsd1artnum><xsd1:name>POINTS
</xsd1:name><xsd1:altdesc>POINTS</xsd1:altdesc><xsd1:image>imc/images/tn/010
11.jpg</xsd1:image><xsd1:inventory1>219</xsd1:inventory1><xsd1:inventory2>0<
/xsd1:inventory2><xsd1rice>1.42</xsd1rice><xsd1:weight>0.05</xsd1:weight
><xsd1enumber>01011</xsd1enumber><xsd1:brand>Bosch</xsd1:brand></ite
>m><i
tem><xsd1:id>911414</xsd1:id><xsd1artnum>BH006102
</xsd1artnum><xsd1:name>POINTS (H.P.) </xsd1:name><xsd1:altdesc>POINTS

(H.P.)</xsd1:altdesc><xsd1:image>imc/images/tn/01030.jpg</xsd1:image><xsd1:i
nventory1>1440</xsd1:inventory1><xsd1:inventory2>329</xsd1:inventory2><xsd1:
price>5.10</xsd1rice><xsd1:weight>0.06</xsd1:weight><xsd1enumber>010
price>30</
xsd1enumber><xsd1:brand>Bosch</xsd1:brand></item><item><xsd1:id>993653</xs
d1:id><xsd1artnum>BH078370 </xsd1artnum><xsd1:name>POINTS
</xsd1:name><xsd1:altdesc>POINTS</xsd1:altdesc><xsd1:inventory1>219</xsd1:in
ventory1><xsd1:inventory2>0</xsd1:inventory2><xsd1rice>1.42</xsd1ric
ventory1>e><x
sd1:weight>0.05</xsd1:weight><xsd1enumber>01111</xsd1enumber><xsd1:brand
>Bosch</xsd1:brand></item><item><xsd1:id>919916</xsd1:id><xsd1artnum>B
>M047
350 </xsd1artnum><xsd1:name>POINTS, NON HP
</xsd1:name><xsd1:altdesc>POINTS, NON
HP</xsd1:altdesc><xsd1:inventory1>87</xsd1:inventory1><xsd1:inventory2>11</x
sd1:inventory2><xsd1:listPrice>5.21</xsd1:listPrice><xsd1rice>2.00</xsd1
rice><xsd1:weight>0.05</xsd1:weight><xsd1enumber>12111267393</xsd1en
rice>umbe
r><xsd1:brand>Bremi</xsd1:brand></item></xsd1roducts></result></nart
r>numb
erSearch></soap:Body></soap:Envelope>

-----------------------------------------------




Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[simonchristieis]

try this

Set objXMLDoc = CreateObject("Microsoft.XMLDOM") 
objXMLDoc.async = False 
objXMLDoc.loadXml(objXMLHTTP.ResponseText) 

Set NodeList = objXMLDoc.documentElement.selectNodes("//soap:Body/n:partnumberSearch/result/xsd1:products") 
For Each Node In NodeList 
   document.write(Node.text & "<br>") 
Next

hth

simon