M
Me 1971
Excel 2003 with the Web Services Reference tool 2.0 installed.
My vba project can happily see my webservice, and connect. WHen I do it
creates the Proxy classes, stubs and the request objects quite happily.
If I call a webservice method similar to a Hello world, or a simple maths
one, then the system works fine and returns my data.
If I call a more complex method, that returns a nested piece of data (My
schema / wsdl is huge, so Im hoping I can avoid posting it here. But I'll
summarise it)
<Response>
<DataPoint>
<DataPointName>
<DataPointDateItem>
<Date>
<MeasuredLocation>
<Results>
<24 hourly measurements here in an array >
</Results>
</DataPointItem>
<.. Next Data Point Item>
</DataPoint>
<.. Next Data Point >
....
</Response>
I get the message SoapMapper: restoring the data into SoapMapper <type>
failed.
If I attach a Http utility such as fiddler to the call and run it, I can see
that the response is being returned from the webservice, and it looks ok. So
The error is being caused at the vba end of the call, when the data is
returned.
I have tried assigning the return value to a variant, a variant() and an
object, but I always get the same response.
I have also tried doing htis the hard way, constructing the soap envelope
and sending it via the connections input stream / attaching a reader to the
output stream. In that case I get an 'Object Required' Error.
So, is there a workround to this, or do I just tell my customer that all I
can give him is csv files, and he has to import the data manually?
My vba project can happily see my webservice, and connect. WHen I do it
creates the Proxy classes, stubs and the request objects quite happily.
If I call a webservice method similar to a Hello world, or a simple maths
one, then the system works fine and returns my data.
If I call a more complex method, that returns a nested piece of data (My
schema / wsdl is huge, so Im hoping I can avoid posting it here. But I'll
summarise it)
<Response>
<DataPoint>
<DataPointName>
<DataPointDateItem>
<Date>
<MeasuredLocation>
<Results>
<24 hourly measurements here in an array >
</Results>
</DataPointItem>
<.. Next Data Point Item>
</DataPoint>
<.. Next Data Point >
....
</Response>
I get the message SoapMapper: restoring the data into SoapMapper <type>
failed.
If I attach a Http utility such as fiddler to the call and run it, I can see
that the response is being returned from the webservice, and it looks ok. So
The error is being caused at the vba end of the call, when the data is
returned.
I have tried assigning the return value to a variant, a variant() and an
object, but I always get the same response.
I have also tried doing htis the hard way, constructing the soap envelope
and sending it via the connections input stream / attaching a reader to the
output stream. In that case I get an 'Object Required' Error.
So, is there a workround to this, or do I just tell my customer that all I
can give him is csv files, and he has to import the data manually?