RequestHeaderSet

Associates an HTTP Request Header with an HTTP Session

Stored Procedure
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

EXEC SQLHTTP.net.RequestHeaderSet @HttpSessionID, @Key, @Value

Arguments:

Name	Type	Description
@HttpSessionID	uniqueidentifier	This value is obtained via the HttpSession stored procedure
@Key	nvarchar(400)	Request Header Key Name
@Value	nvarchar(4000)	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



RequestHeaderSet

Featured API Wrapper Code / SQL Server