How can I make HTTP request from SQL server?

by

I got another answer as well. I created procedure like follows

CREATE procedure HTTP_Request( @sUrl varchar(200))
As


Declare
@obj int
,@hr int
,@msg varchar(255)


 exec @hr = sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT
if @hr <> 0 begin Raiserror('sp_OACreate MSXML2.ServerXMLHttp.3.0
failed', 16,1) return end


exec @hr = sp_OAMethod @obj, 'open', NULL, 'POST', @sUrl, false
if @hr <>0 begin set @msg = 'sp_OAMethod Open failed' goto eh end


exec @hr = sp_OAMethod @obj, 'setRequestHeader', NULL, 'Content-Type',
'application/x-www-form-urlencoded'
if @hr <>0 begin set @msg = 'sp_OAMethod setRequestHeader failed' goto
eh end


exec @hr = sp_OAMethod @obj, send, NULL, ''
if @hr <>0 begin set @msg = 'sp_OAMethod Send failed' goto eh end

 exec @hr = sp_OADestroy @obj
return
eh:
exec @hr = sp_OADestroy @obj
Raiserror(@msg, 16, 1)
return
GO

I called the stored procedure with url

USE [master]
GO

 DECLARE    @return_value int

EXEC    @return_value = [dbo].[HTTP_Request]
    @sUrl = N'url'

SELECT  'Return Value' = @return_value

GO

Thank you guys to make me work this.

More Related Contents:

  1. How to get the last row from a table in SQL Server?
  2. Alias name is same as column name [closed]
  3. LocalDB deployment on client PC
  4. Understanding PIVOT function in T-SQL
  5. The order of a SQL Select statement without Order By clause
  6. Using RegEx in SQL Server
  7. What is the best way to auto-generate INSERT statements for a SQL Server table?
  8. Storing a file in a database as opposed to the file system?
  9. SQL Server named instance with Visual Studio 2017 Installer project
  10. How do you count the number of occurrences of a certain substring in a SQL varchar?
  11. Why is it considered bad practice to use cursors in SQL Server?
  12. Import Excel spreadsheet columns into SQL Server database
  13. CAST and IsNumeric
  14. Find index of last occurrence of a sub-string using T-SQL
  15. Hidden Features of SQL Server
  16. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  17. SQL Server 2008 Empty String vs. Space
  18. How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
  19. SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain
  20. SQL Query to find the last day of the month
  21. SQL Server, convert a named instance to default instance?
  22. How to drop column with constraint?
  23. How to specify a port number in SQL Server connection string?
  24. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  25. SQL Server 2008 Vertical data to Horizontal
  26. What are some ways of accessing Microsoft SQL Server from Linux?
  27. LPAD in SQL Server 2008
  28. What are row, page and table locks? And when they are acquired?
  29. Bootstrapping SQL Express from WiX?
  30. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

Leave a Comment