DECLARE @o as Int; DECLARE @r as Varchar(8000); DECLARE @body AS VARCHAR(8000) = '{ "what": 1, "ever": "you", "need": "to send as the body" }' DECLARE @url varchar(max) = 'http://192.168.80.184:8050/housekeeper_report' EXEC sp_OACreate 'MSXML2.XMLHTTP', @o OUT ; EXEC sp_OAMethod @o, 'open', NULL, 'post',@url,'false' EXEC sp_OAMethod @o, 'send', null, @body EXEC sp_OAMethod @o, 'responseText', @r OUTPUT print(@r) Exec sp_OADestroy @o

https://gist.github.com/theorigin/fa3c58406ff7b4565ca2

DECLARE @task varchar(250) = 'foo' DECLARE @o as Int; DECLARE @r as Varchar(8000); DECLARE @body AS VARCHAR(8000) = concat('{"task":"',@task,'"}') DECLARE @url varchar(max) = 'http://192.168.80.184:8050/housekeeper_report' EXEC sp_OACreate 'MSXML2.XMLHTTP', @o OUT ; EXEC sp_OAMethod @o, 'open', NULL, 'post',@url,'false' EXEC sp_OAMethod @o, 'send', null, @body EXEC sp_OAMethod @o, 'responseText', @r OUTPUT print(@r) Exec sp_OADestroy @o 07.06.18 EXEC sp_OAMethod @o, 'setRequestHeader', null, 'Content-Type', 'application/json' 07.06.18 this works: 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) DECLARE @StringRequest NVARCHAR(500) SET @StringRequest = '{"task":"create_new_price_entries"}' --SET @sUrl = 'http://192.168.80.240:9050/housekeeper_report' SET @sUrl = 'http://foo.com/housekeeper_report' EXEC sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT EXEC sp_OAMethod @obj, 'Open', NULL, 'POST', @sUrl, false EXEC sp_OAMethod @obj, 'setRequestHeader', null, 'Content-Type', 'application/json' EXEC sp_OAMethod @obj, 'send', NULL, @StringRequest EXEC sp_OAGetProperty @obj, 'responseText', @XMLResponse 07.06.18

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024