Historical Rates

Return historical exchange rates for the currencies specified in the currencies parameter using SQL Server

Prerequisites:

See SQLHTTP easy setup for CurrencyLayer
See API Call documentation for parameter values and other information

Sample Usage:


DECLARE @Response nvarchar(MAX)
DECLARE @StatusCode int
DECLARE @StatusDescription nvarchar(MAX)

EXEC usp_APILayer_Fetch	@Type = 'historical',
			@Parameters = '2017-01-15', --format: YYYY-MM-DD' 
			@Response = @Response OUTPUT, 
			@StatusCode = @StatusCode OUTPUT, 
			@StatusDescription = @StatusDescription OUTPUT

IF @StatusCode >= 400
	EXEC SQLHTTP.net.RaiseHttpError @StatusCode, @StatusDescription, @Response
ELSE
	BEGIN
		SELECT [Name], [Value]
		FROM SQLHTTP.net.Json_To_NodeTable(@Response)
		WHERE [Name] IN ('USDAUD', 'USDNZD', 'USDCAD')
	END

DECLARE @Response nvarchar(MAX)

DECLARE @StatusCode int

DECLARE @StatusDescription nvarchar(MAX)

EXEC usp_APILayer_Fetch @Type = 'historical',

@Parameters = '2017-01-15', --format: YYYY-MM-DD'

@Response = @Response OUTPUT,

@StatusCode = @StatusCode OUTPUT,

@StatusDescription = @StatusDescription OUTPUT

IF @StatusCode >= 400

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

ELSE

BEGIN

SELECT [Name], [Value]

FROM SQLHTTP.net.Json_To_NodeTable(@Response)

WHERE [Name] IN ('USDAUD', 'USDNZD', 'USDCAD')

END

Name Value

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

USDAUD 1.333399

USDCAD 1.31268

USDNZD 1.401597



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.