search

VBA-tools / VBA-Web

VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
http://vba-tools.github.io/VBA-Web/
MIT License
2k stars 492 forks source link

Add SOAP support and/or example #57

Open zinji opened 10 years ago

zinji commented 10 years ago

Thinking of using your tool as soap request client. Do you have any feature request in the pipeline. I am planning to modify the RestClient to incorporate the soap calls - do you have any suggestions on the proposed approach.

timhall commented 10 years ago

Hi @zinji From what I've seen of SOAP, it should definitely be doable with Excel-REST. The first step towards it, and this has been planned, is implementing built-in XML support (although it's indirectly supported now). After that, I'll have to look into more details on SOAP to see how best to integrate it. Do you have any good examples of APIs that I can use for reference?

zinji commented 10 years ago

Tim this is a sample webservice that provides geo location for ip addresses (http://ws.cdyne.com/ip2geo/ip2geo.asmx?wsdl). The service provides a soap response with xml contents. I got this from this website http://www.service-repository.com/service/overview/-537094317. This site provides interface to make the calls and see the response.

IgorShch commented 9 years ago

Hi Tim,

Thank you very much for your effort.

Sorry if it's stupid, but is the SOAP support included in the version 4.0? Would be pretty cool to have an example if it is.

timhall commented 9 years ago

@IgorShch I believe all of the elements of SOAP are supported, but I haven't tried a SOAP example yet. I'll look into it more and see if I can create an example for it.

HugoHugoson commented 8 years ago

I called some SOAP interface using basic authentication over HTTPS. I had some Chrome extension decode the WSDL and created the message envelope manually and got an XML string back. Would that snippet be of any help, and where would I put it?