JDBC Driver for Open Exchange Rates

Build 21.0.7930

Latest

Query the Latest exchange rates available from Open Exchange Rates.

Table Specific Information

Select

Select all of the Latest exchange rates:

SELECT * FROM Latest

Select from the Latest exchange rates by specifying Symbols in a comma-separated list:

SELECT * FROM Latest WHERE Symbols='ALL,AUR,GBP' 

Columns

Name Type References Description
Currency String Currency (3-letter code).
Value Decimal Rate for the currency.
Base String Base currency (3-letter code. Default: USD).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Symbols String Limit results to specific currencies (comma-separated list of 3-letter codes).

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930