Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Have a question about accessing the SOAP response via VBA client.  RSS feed

Shubh Bhat
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all, below is the SOAP Response I get from a webservice
I need to access things inside #id0 and #id1. I am unable to get it.
I would need VBA specific code as an example.

Thanks in advance,

<?xml version="1.0" encoding="UTF-8" ?>
- <soapenv:Envelope xmlns:soapenv="" xmlns:xsd="" xmlns:xsi="">
- <soapenv:Body>
- <ns1:getPositionsResponse soapenv:encodingStyle="" xmlns:ns1="urn:com.ts.test.qs">
- <getPositionsReturn soapenc:arrayType="ns2:ArrayOf_xsd_anyType[2]" xsi:type="soapenc:Array" xmlns:ns2="" xmlns:soapenc="">
<getPositionsReturn href="#id0" />
<getPositionsReturn href="#id1" />
- <multiRef id="id1" soapenc:root="0" soapenv:encodingStyle="" xsi:type="ns3 roduct" xmlns:soapenc="" xmlns:ns3="">
<name xsi:type="xsd:string">SecondName</name>
<description xsi:type="xsd:string">Desc</description>
<price xsi:type="xsd ouble">2345.6</price>
<asOfDate xsi:type="xsd ate">1969-12-31</asOfDate>
- <multiRef id="id0" soapenc:root="0" soapenv:encodingStyle="" xsi:type="ns4 roduct" xmlns:ns4="" xmlns:soapenc="">
<name xsi:type="xsd:string">FirstName</name>
<description xsi:type="xsd:string">description</description>
<price xsi:type="xsd ouble">123123.13</price>
<asOfDate xsi:type="xsd ate">1969-12-31</asOfDate>
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!