ResponseHeaders

Returns a table of HTTP Response Headers associated with an HTTP Session

Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT *
FROM SQLHTTP.net.ResponseHeaders ( @HttpSessionID )

Arguments:

Name	Type	Description
@HttpSessionID	uniqueidentifier	This value is obtained via the HttpSession stored procedure



Table Returned:

Column name	Data type	Description
Key	nvarchar(400)	HTTP Response Header Name
Value	nvarchar(MAX)	HTTP Response Header Value



Sample Usage:


DECLARE @HttpSessionID uniqueidentifier

--A sample HttpSessionID generated after a previous execution of the HttpRequest stored procedure
SET @HttpSessionID = 'A97D0B68-A0FD-4DDE-88C7-356EE0B5EC1C'

SELECT *
FROM SQLHTTP.net.ResponseHeaders_To_table(@HttpSessionID)

DECLARE @HttpSessionID uniqueidentifier

--A sample HttpSessionID generated after a previous execution of the HttpRequest stored procedure

SET @HttpSessionID = 'A97D0B68-A0FD-4DDE-88C7-356EE0B5EC1C'

SELECT *

FROM SQLHTTP.net.ResponseHeaders_To_table(@HttpSessionID)

Key Value

--------------------- ----------------------------------------------------------------

Cache-Control no-cache, no-store, must-revalidate, pre-check=0, post-check=0

content-disposition attachment; filename=json.json

Content-Length 28571

Content-Type application/json;charset=utf-8

Date Fri, 30 Jun 2017 01:04:30 GMT

Expires Tue, 31 Mar 1981 05:00:00 GMT

Last-Modified Fri, 30 Jun 2017 01:04:30 GMT

pragma no-cache

status 200 OK



ResponseHeaders

Featured API Wrapper Code / SQL Server