• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
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,
Shubhra

<?xml version="1.0" encoding="UTF-8" ?>
- <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <soapenv:Body>
- <ns1:getPositionsResponse soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns1="urn:com.ts.test.qs">
- <getPositionsReturn soapenc:arrayType="ns2:ArrayOf_xsd_anyType[2]" xsi:type="soapenc:Array" xmlns:ns2="http://qs.test.ts.com" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<getPositionsReturn href="#id0" />
<getPositionsReturn href="#id1" />
</getPositionsReturn>
</ns1:getPositionsResponse>
- <multiRef id="id1" soapenc:root="0" soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xsi:type="ns3 roduct" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:ns3="http://qs.test.ts.com">
<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>
- <multiRef id="id0" soapenc:root="0" soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xsi:type="ns4 roduct" xmlns:ns4="http://qs.test.ts.com" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<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>
</multiRef>
</soapenv:Body>
</soapenv:Envelope>
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic