XML in an MSXML2.DOMDocument : Copy to Worksheet

[bobtaylor]

Hi,

I'm consuming a rest service from a SAAS platform and I need to find a way to read the XML returned back to the worksheet.

I've gotton as far as loading the XML into an MSXML2.DOMDocument.

The XML is indicated below :

<?xml version="1.0" encoding="UTF-8"?>
<response success="true">
<output>
<levels>
<level id="1" name="Blah" currency="USD" >
<level id="61" name="Blah" currency="USD" >
<level id="642" name="Blah" currency="USD" >
<level id="141" name="Blah" currency="USD" >
<level id="153" name="Blah" currency="USD" />
<level id="154" name="Blah" currency="USD" />
<level id="185" name="blah" currency="USD" />
<level id="186" name="Blah" currency="USD" />
</level>
<level id="142" name="Blah" currency="USD" >
<level id="155" name="Blah" currency="USD" />
<level id="159" name="Blah" currency="USD" />
<level id="163" name="Blah" currency="USD" />
<level id="188" name="Blah" currency="USD" />
</level>

<response success="true"><output><levels><level id="1" currency="USD" name="Blah"><level id="61" currency="USD" name="Blah"><level id="642" currency="USD" name="Blah"><level id="141" currency="USD" name="Blah"><level id="153" currency="USD" name="Blah"><level id="154" currency="USD" name="Blah"><level id="185" currency="USD" name="blah"><level id="142" currency="USD" name="Blah"><level id="155" currency="USD" name="Blah"><level id="159" currency="USD" name="Blah"><level id="163" currency="USD" name="Blah"><response success="true"><output><levels><level id="1" currency="USD" name="blahblah"><level id="61" name="blahblah currency=" USD?=""><level id="642" currency="USD" name="blahblah"><level id="141" currency="USD" name="blahblah"><level id="153" currency="USD" name="blahblah"><level id="154" currency="USD" name="blahblah"><level id="185" currency="USD" name="blahblah"><level id="142" currency="USD" name="blahblah"><level id="155" currency="USD" name="blah"><level id="159" currency="USD" name="blah"><level id="163" currency="USD" name="blah"><response success="true"><output><levels><level id="1" currency="USD" name="Blah"><level id="61" currency="USD" name="Blah"><level id="642" currency="USD" name="Blah"><level id="141" currency="USD" name="Blah"><level id="153" currency="USD" name="Blah"><level id="154" currency="USD" name="Blah"><level id="185" currency="USD" name="blah"><level id="142" currency="USD" name="Blah"><level id="155" currency="USD" name="Blah"><level id="159" currency="USD" name="Blah"><level id="163" currency="USD" name="Blah">I think I may need to use SelectSingleNode to traverse through the XML but I'm unsure of the required Xpath query.

I'd appreciate any help.</level></level></level></level></level></level></level></level></level></level></level></levels></output></response></level></level></level></level></level></level></level></level></level></level></level></levels></output></response></level></level></level></level></level></level></level></level></level></level></level></levels></output></response>

 

[bobtaylor]

 

[bobtaylor]

bump