SOAP request not working

[ChristianCB]

Hi all

I have some problems getting a SOAP request to work in Excel.

This is my code:

Please Login or Register  to view this content.

where xml is a variant variable containing xml data as a text String. (I had to add Spaces in between h t t p s to be allowed to post on this forum. New users are not allowed to post "links".)

I sent the same XML data in a test Application called SoapUI. There it works. But when I send the exact same xml in Excel, it does not work. Instead I get an error Message from the server, saying a required parameter is zero. But the parameter is defined in the xml, and it's value should have been set to the same in both SoapUI and Excel. So the error has to be in the VBA code, and not in the xml.

Does anyone see what I have done wrong?

[NeedForExcel]

Hi,

The Code seems OK to me.. I suspect xml isn't being generated properly.. Make sure your SOAP Envelope is OK..

I suggest, Instead of Late Binding the Code, Early Bind it.. It will be easier for you to debug, and then change it back to Late Binding if you wish to.

[ChristianCB]

Hi

Thanks for Your reply. I have changed it to early binding

The forum won't let me post xml here (it says html tags are not allowed). But the xml is generated by SoapUI (where it Works), and I just copied it from there. It validates as xml With no errors. But it does not work in Excel.

[NeedForExcel]

Hi,

Can you upload your XML here?

http://textuploader.com/

It is a bit hard to judge what the exact issue might be without taking a look

[ChristianCB]

This was not an easy to use forum I uploaded the xml to textuploader.com, but I'm still not allowed to post clickable links

This is the XML I used, which was automatically generated by SoapUT:
textuploader.com/df0pi

I also tried this XML, which I just copied from the service documentation:
textuploader.com/df0zs

(I have censored the value of my user id, but I have an actual 9 digits number there)

This is the response from the server:
textuploader.com/df0z5

[NeedForExcel]

Hi,

You will basically need a code like this -

http://textuploader.com/df02l

You will have to check if the SOAP Envelope is right, and pass in the required parameters.

That is the best I could do without debugging.

[ChristianCB]

I finally found a solution to this. I was using a SOAP 1.1 Call. I changed it to 1.2, and it worked. The documentation said both calls could be used, but apparently only 1.2 was working. Thank you for your help

[NeedForExcel]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.