BizTalk Adapter for Open Exchange Rates

Build 21.0.7930


Query Currency symbols available from Open Exchange Rates.

Table Specific Information


Select all Currency symbols:

SELECT * FROM Currencies

Select experimental Currencies:

SELECT * FROM Currencies WHERE ShowExperimental=true


Name Type References Description
Currency String Currency (3-letter code).
Name String Long name for the currency.


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
ShowExperimental Boolean Whether to show experimental currencies from the unofficial, black market, and alternative currencies list in OpenExchangeRates.

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