BizTalk Adapter for Open Exchange Rates

Build 21.0.7930

Historical

Query Historical exchange rates for any date available from Open Exchange Rates.

Table Specific Information

Select

Select all Historical exchange rates for the current Date:

SELECT * FROM Historical

Select all Historical exchange rates for the specified Date:

SELECT * FROM Historical WHERE Date='2016-01-01'

Columns

Name Type References Description
Currency String Currency (3-letter code).
Value Decimal Rate for the currency.
Date Date The requested date.
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