RaiseHttpError

Throws an error based on provided HTTP response data

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

Syntax:

EXEC SQLHTTP.net.RaiseHttpError @StatusCode, @StatusDescription, [@Response]

Arguments:

Name	Type	Description
@StatusCode	int	Numeric status of the previous HTTP response
@StatusDescription	nvarchar(MAX)	Status Description of the previous HTTP response
@Response	nvarchar(MAX)	Optional. Data received from the previous HTTP response. Binary data is returned as a Base64 string



Sample Usage:


DECLARE @URL nvarchar(4000)
DECLARE @HttpSessionID uniqueidentifier
DECLARE @Response varchar(MAX)
DECLARE @StatusCode int
DECLARE @StatusDescription nvarchar(MAX)

SET @URL = 'https://api.twitter.com/1.1/followers/list.json'

EXEC SQLHTTP.net.HttpSession @HTTPSessionID OUTPUT

EXEC SQLHTTP.net.HttpRequest 	@HTTPSessionID = @HTTPSessionID,
				@URL = @URL,
				@Response = @Response OUTPUT,
				@StatusCode = @StatusCode OUTPUT,
				@StatusDescription = @StatusDescription OUTPUT

IF @StatusCode >= 400
	BEGIN
		EXEC SQLHTTP.net.RaiseHttpError @StatusCode, @StatusDescription, @Response
	END

DECLARE @URL nvarchar(4000)

DECLARE @HttpSessionID uniqueidentifier

DECLARE @Response varchar(MAX)

DECLARE @StatusCode int

DECLARE @StatusDescription nvarchar(MAX)

SET @URL = 'https://api.twitter.com/1.1/followers/list.json'

EXEC SQLHTTP.net.HttpSession @HTTPSessionID OUTPUT

EXEC SQLHTTP.net.HttpRequest @HTTPSessionID = @HTTPSessionID,

@URL = @URL,

@Response = @Response OUTPUT,

@StatusCode = @StatusCode OUTPUT,

@StatusDescription = @StatusDescription OUTPUT

IF @StatusCode >= 400

BEGIN

EXEC SQLHTTP.net.RaiseHttpError @StatusCode, @StatusDescription, @Response

END

Msg 50000, Level 16, State 1, Procedure RaiseHttpError, Line 15 [Batch Start Line 0]

HTTP ERROR 400:

Bad Request

Additional Error Information:

{"errors":[{"code":215,"message":"Bad Authentication data."}]}



RaiseHttpError

Featured API Wrapper Code / SQL Server