HTTP POST from T-SQL

gogul

Hey,

I have setup a stored procedure to send a HTTP POST to a URL using:

EXEC @iHr = sp_oacreate 'MSXML2.ServerXMLHTTP.3.0', @iObject OUTPUT
EXEC @iHr = sp_oamethod @iObject, 'open', null, 'POST', @sURL
EXEC @iHr = sp_oamethod @iObject, 'send', null
EXEC @iHr = sp_oagetproperty @iObject, 'responseText', @sResponseText OUTPUT

Does anyone know how I would specify Form parameters so I could mimic a full HTTP POST?

Thanks
Gogul

NutJob

Without refrencing anything you could write a com object to do this.

A better approach might be to just use SOAP and expose a service on the other application.

sailorfoley

you could use GET instead of post and append append the variables to the url

e.g. to send the variable a1 and a2 and their values to the URL www.sample.com/link.aspx do the following :

http://www.sample.com/link.asp?a1=value&a2=othervalue

etc.

or if you still want to use POST then you need to pass the form variables to the send method of the XMLHTTP object you are using.
See these links - http://msdn2.microsoft.com/en-us/library/ms946729.aspx (using xmlhttp to post to a url) and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/7924f6be-c035-411f-acd2-79de7a711b38.asp

this is the interface into the xmlhttp object.

if you have any other questions just ask