title: How do I send Parameters by using HTTP POST with T-SQL and OLE Automation Procedures
body: <p>I'm using the OLE Automation Procedures to send a HTTP POST Request to a SOAP-Webservice and process the returned data. This works fine for me by using the code snipped below. Now I need to pass a POST-parameter over to the webservice.
  Any idea how i could do that?</p>
  
  <p>Parameter: searchstring<BR/>
  Value: V34432221</p>
  
  <pre><code>DECLARE @XMLResponse xml
  DECLARE @obj INT
  DECLARE @ValorDeRegreso INT
  DECLARE @sUrl NVARCHAR(200)
  DECLARE @response VARCHAR(MAX)
  DECLARE @hr INT
  DECLARE @src NVARCHAR(255)
  DECLARE @desc NVARCHAR(255)
  SET @sUrl = 'http://server/Webservice/Service1.asmx/Suche'
  EXEC sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT
  EXEC sp_OAMethod @obj, 'Open', NULL, 'POST', @sUrl, false
  EXEC sp_OAMethod @obj, 'send'
  EXEC sp_OAGetProperty @obj, 'responseText', @XMLResponse OUT
  --process @XMLResponse...
  </code></pre>