RequestHeaders

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

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

Syntax:

SELECT *
FROM SQLHTTP.net.RequestHeaders ( @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 Request Header Name
Value	nvarchar(MAX)	HTTP Request Header Value



Sample Usage:


DECLARE @HTTPSessionID uniqueidentifier

EXEC SQLHTTP.net.HTTPSession @HTTPSessionID OUTPUT

EXEC SQLHTTP.net.RequestHeaderSet @HTTPSessionID, 
				  'Authorization', 
				  'Bearer AxpYmrpYpwchn9UH95I8Zf4F99BMg3Crxewf'

SELECT *
FROM SQLHTTP.net.RequestHeaders(@HTTPSessionID)

DECLARE @HTTPSessionID uniqueidentifier

EXEC SQLHTTP.net.HTTPSession @HTTPSessionID OUTPUT

EXEC SQLHTTP.net.RequestHeaderSet @HTTPSessionID,

'Authorization',

'Bearer AxpYmrpYpwchn9UH95I8Zf4F99BMg3Crxewf'

SELECT *

FROM SQLHTTP.net.RequestHeaders(@HTTPSessionID)

Key Value

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

Authorization Bearer AxpYmrpYpwchn9UH95I8Zf4F99BMg3Crxewf



RequestHeaders

Featured API Wrapper Code / SQL Server