HolidayAPI

Interact with HolidayAPI using SQL Server

Install the SQLHTTP database on your SQL Server
Obtain an API Key from HolidayAPI.com
Create the stored procedures documented below
Execute the following SQL statement:


EXEC usp_HolidayAPI_Auth_Init @APIKey = 'enter-your-API-Key-here'

EXEC usp_HolidayAPI_Auth_Init @APIKey = 'enter-your-API-Key-here'



Stored Procedures:


CREATE PROCEDURE usp_HolidayAPI_Auth_Init(@APIKey varchar(50))
AS

EXEC SQLHTTP.net.AuthParamSet	@Profile = 'holidayapi', 
				@Name = 'APIKey', 
				@Value = @APIKey
GO

CREATE PROCEDURE usp_HolidayAPI_Auth_Init(@APIKey varchar(50))

EXEC SQLHTTP.net.AuthParamSet @Profile = 'holidayapi',

@Name = 'APIKey',

@Value = @APIKey


CREATE PROCEDURE usp_HolidayAPI_Fetch (	@Country varchar(6),
					@Year char(4),
					@Month varchar(2),
					@Response nvarchar(MAX) OUTPUT,
					@StatusCode int OUTPUT,
					@StatusDescription nvarchar(MAX) OUTPUT)
AS

SET NOCOUNT ON

DECLARE @URL nvarchar(MAX)
DECLARE @QueryString varchar(MAX)
DECLARE @HTTPSessionID uniqueidentifier

SET @URL = 'https://holidayapi.com/v1/holidays'

EXEC SQLHTTP.net.QueryStringBuilder     @QueryString OUTPUT,
					'holidayapi', 
					'key', '#APIKey',
					'country', @Country,
					'year', @Year,
					'month', @Month

SET @URL = @URL + @QueryString

EXEC SQLHTTP.net.HTTPSession @HTTPSessionID OUTPUT

EXEC SQLHTTP.net.HTTPRequest	@HttpSessionID,
				@URL = @URL,
				@Method = 'GET',
				@StatusCode = @StatusCode OUTPUT,
				@StatusDescription = @StatusDescription OUTPUT,
				@Response = @Response OUTPUT
GO

CREATE PROCEDURE usp_HolidayAPI_Fetch ( @Country varchar(6),

@Year char(4),

@Month varchar(2),

@Response nvarchar(MAX) OUTPUT,

@StatusCode int OUTPUT,

@StatusDescription nvarchar(MAX) OUTPUT)

SET NOCOUNT ON

DECLARE @URL nvarchar(MAX)

DECLARE @QueryString varchar(MAX)

DECLARE @HTTPSessionID uniqueidentifier

SET @URL = 'https://holidayapi.com/v1/holidays'

EXEC SQLHTTP.net.QueryStringBuilder @QueryString OUTPUT,

'holidayapi',

'key', '#APIKey',

'country', @Country,

'year', @Year,

'month', @Month

SET @URL = @URL + @QueryString

EXEC SQLHTTP.net.HTTPSession @HTTPSessionID OUTPUT

EXEC SQLHTTP.net.HTTPRequest @HttpSessionID,

@URL = @URL,

@Method = 'GET',

@StatusCode = @StatusCode OUTPUT,

@StatusDescription = @StatusDescription OUTPUT,

@Response = @Response OUTPUT



Available API Calls:

Holidays

API Library > HolidayAPI

Install Now Free

IMPORTANT DISCLAIMER

CODE/SQL ON THESE PAGES ARE PROVIDED AS-IS AND ARE AVAILABLE FOR ILLUSTRATIVE PURPOSES ONLY.

USERS ARE REQUIRED TO ABIDE BY THE TERMS AND CONDITIONS FOR USING REFERENCED THIRD PARTY WEBSITES AND/OR APIs FROM THEIR RESPECTIVE WEBSITES. WE DO NOT CONDONE ANY VIOLATION OF THIRD PARTY WEBSITES AND/OR APIs TERMS AND CONDITIONS USING OUR SOFTWARE.

USERS SHALL BE SOLELY RESPONSIBLE AND BE SOLELY LIABLE FOR VIOLATION OF ANY RULES SPECIFIED BY THIRD PARTIES FOR USING THEIR WEBSITES AND/OR APIs, OR INFRINGEMENT OF RIGHTS OF SUCH THIRD PARTIES.