Weather Underground

Retrieve data from the Weather Underground API using SQL Server

Obtain an API Key from Weather Underground
Create the stored procedures documented below
Execute the following SQL statement:


EXEC usp_WeatherUnderground_Auth_Init @APIKey = 'enter your API Key here'

EXEC usp_WeatherUnderground_Auth_Init @APIKey = 'enter your API Key here'



Stored Procedures:


CREATE PROCEDURE usp_WeatherUnderground_Auth_Init(@APIKey varchar(20))
AS

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

CREATE PROCEDURE usp_WeatherUnderground_Auth_Init(@APIKey varchar(20))

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


CREATE PROCEDURE usp_WeatherUnderground_Fetch(	@Type varchar(20),
						@ZipCode varchar(20),
						@Response nvarchar(MAX) OUTPUT,
						@StatusCode int OUTPUT,
						@StatusDescription nvarchar(MAX) OUTPUT)
AS

IF LOWER(@Type) NOT IN ('alerts', 'almanac', 'astronomy', 'conditions', 'forecast', 'hourly')
	BEGIN
		RAISERROR('Invalid @Type parameter', 16, 1)
		RETURN
	END

DECLARE @URL nvarchar(MAX)
DECLARE @HTTPSessionID uniqueidentifier

SET @URL = 'http://api.wunderground.com/api'

SET @ZipCode = @ZipCode + '.json' COLLATE SQL_Latin1_General_CP1_CI_AS

EXEC SQLHTTP.net.UrlBuilder 	@URL OUTPUT,
				'wunderground', 
				'#APIKey', 
				@Type, 
				'q', @ZipCode
				
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_WeatherUnderground_Fetch( @Type varchar(20),

@ZipCode varchar(20),

@Response nvarchar(MAX) OUTPUT,

@StatusCode int OUTPUT,

@StatusDescription nvarchar(MAX) OUTPUT)

IF LOWER(@Type) NOT IN ('alerts', 'almanac', 'astronomy', 'conditions', 'forecast', 'hourly')

BEGIN

RAISERROR('Invalid @Type parameter', 16, 1)

RETURN

END

DECLARE @URL nvarchar(MAX)

DECLARE @HTTPSessionID uniqueidentifier

SET @URL = 'http://api.wunderground.com/api'

SET @ZipCode = @ZipCode + '.json' COLLATE SQL_Latin1_General_CP1_CI_AS

EXEC SQLHTTP.net.UrlBuilder @URL OUTPUT,

'wunderground',

'#APIKey',

@Type,

'q', @ZipCode

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:

API Library > Weather Underground

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.