RequestHeaderRemove

Removes a previously associated HTTP Request Header from an HTTP Session

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

Syntax:

EXEC SQLHTTP.net.RequestHeaderRemove @HttpSessionID, @Key

Arguments:

Name	Type	Description
@HttpSessionID	uniqueidentifier	This value is obtained via the HttpSession stored procedure
@Key	nvarchar(400)	Request Header Key Name previously set



Sample Usage:

The following example adds a Request Header and then removes it, resulting in an empty RequestHeaders for the given HttpSessionID:


DECLARE @HTTPSessionID uniqueidentifier

EXEC SQLHTTP.net.HTTPSession @HTTPSessionID OUTPUT

--Appends a Request Header
EXEC SQLHTTP.net.RequestHeaderSet @HTTPSessionID, 
				  'Authorization', 
				  'Bearer AxpYmrpYpwchn9UH95I8Zf4F99BMg3Crxewf'

--Removes the same Request Header
EXEC SQLHTTP.net.RequestHeaderRemove @HTTPSessionID, 
				  'Authorization'

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

DECLARE @HTTPSessionID uniqueidentifier

EXEC SQLHTTP.net.HTTPSession @HTTPSessionID OUTPUT

--Appends a Request Header

EXEC SQLHTTP.net.RequestHeaderSet @HTTPSessionID,

'Authorization',

'Bearer AxpYmrpYpwchn9UH95I8Zf4F99BMg3Crxewf'

--Removes the same Request Header

EXEC SQLHTTP.net.RequestHeaderRemove @HTTPSessionID,

'Authorization'

SELECT *

FROM SQLHTTP.net.RequestHeaders(@HTTPSessionID)

Key Value

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



RequestHeaderRemove

Featured API Wrapper Code / SQL Server