Open Exchange Rates

Interact with the Open Exchange Rates Online API using SQL Server

Install the SQLHTTP database on your SQL Server
Obtain an API Key from OpenExchangeRates.org
Create the stored procedure documented below
Execute the following SQL statement:


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

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



Stored Procedures:


CREATE PROCEDURE usp_OpenExchangeRates_Auth_Init(@APIKey varchar(35))
AS

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

CREATE PROCEDURE usp_OpenExchangeRates_Auth_Init(@APIKey varchar(35))

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



Available API Calls:

API Library > Open Exchange Rates

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.