Few days back I was trying to send sql data to my web API using Store-procedure and it was simple and interesting, you can use the same way to call web http post or get both method using such way

CREATE function [dbo].[HttpGetMethod]

(

@url varchar(8000)

)

returns varchar(8000)
as

BEGIN





DECLARE @win int
DECLARE @HttpWinRequest  int



DECLARE @ResultText varchar(8000)




EXEC @HttpWinRequest=sp_OACreate 'WinHttp.WinHttpRequest.5.1',@win OUT



IF @HttpWinRequest <> 0 EXEC sp_OAGetErrorInfo @win



EXEC @HttpWinRequest=sp_OAMethod @win, 'Open',NULL,'GET',@url,'false'



IF @HttpWinRequest <> 0 EXEC sp_OAGetErrorInfo @win



EXEC @HttpWinRequest=sp_OAMethod @win,'Send'


IF @HttpWinRequest <> 0 EXEC sp_OAGetErrorInfo @win




EXEC @HttpWinRequest=sp_OAGetProperty @win,'ResponseText',@ResultText OUTPUT



IF @HttpWinRequest <> 0 EXEC sp_OAGetErrorInfo @win



EXEC @HttpWinRequest=sp_OADestroy @win



IF @HttpWinRequest <> 0 EXEC sp_OAGetErrorInfo @win





RETURN @ResultText




END

Call the function:

-- Select dbo.[HttpGetMethod]('http://localhost/default.asp?Name=John')

Result:

Your Result: John

default.asp can be:

<%

    response.write "Your Result: "&  request("Name")

%>