Calling a Webservice from VBA using SOAP

Question

I'm trying to call a web service in an Excel Macro:

Set objHTTP = New MSXML.XMLHTTPRequest
objHTTP.Open "post", "https://www.server.com/EIDEServer/EIDEService.asmx"
objHTTP.setRequestHeader "Content-Type", "text/xml"
objHTTP.setRequestHeader "SOAPAction", "PutSchedule"
objHTTP.send strXML

And I get back the following response:

  <?xml version="1.0" encoding="utf-8"?>
  <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <soap:Body>
      <soap:Fault>
        <faultcode>soap:Client</faultcode>
        <faultstring>Server did not recognize the value of HTTP Header SOAPAction: PutSchedule.</faultstring>
        <detail />
      </soap:Fault>
    </soap:Body>
  </soap:Envelope>

Anybody out there done something like this before?

Ray Lu · Accepted Answer · 2008-10-28 01:20:11Z

4

You SOAP action should also include namespace of the method e.g.

"http://tempri.org/PutSchedule"

Find out what the namespace of your Service and add it in front of the method name PutSchedule.

answered Oct 28, 2008 at 1:20

Ray Lu

26.7k12 gold badges63 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marci-man Over a year ago

could you please be a little more specific? I know this message is more than 3 years old, but that is the point of having such forums, right?

vba-er · Accepted Answer · 2008-11-04 12:09:25Z

2

looks more like you're using xml-rpc instead of soap. interact with the webservice using the soap type library at : http://msdn.microsoft.com/en-us/library/aa192537(office.11).aspx, or the one that corresponds with your ms office version

answered Nov 4, 2008 at 12:09

vba-er

Collectives™ on Stack Overflow

Calling a Webservice from VBA using SOAP

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related