I have a web service in SQL Server 2014. I'm using sp_oamethod
for request to API. Now I'm getting response-code and response-body. And I need to get response header. Can anyone help me?
The following works for me to retrieve Rate-Limit-Remaining from the response header
DECLARE @responseHeader varchar(4000)
EXEC sp_OAMethod @res, 'getResponseHeader', @responseHeader OUT, 'Rate-Limit-Remaining'
PRINT 'Rate-Limit-Remaining: ' + coalesce(@responseHeader,'<null>')
EXEC sp_OAMethod @res, 'getResponseHeader', @responseHeader OUT, 'Rate-Limit-Reset'
PRINT 'Rate-Limit-Reset: ' + coalesce(@responseHeader,'<null>')
EXEC sp_OAMethod @res, 'getAllResponseHeaders', @responseHeader OUT
PRINT 'Response Headers: ' + coalesce(@responseHeader,'<null>')