The ECB daily rates reader is connected to the ECB data portal exchange reference rates and returns the set of exchange rates for the published set of currency codes and the provided date.
The connector expects the input of:
- date (format yyyy-mm-ddThh:mm:ss.sss or yyyymmddThh:mm:ss.sss based on ISO 8601).
The date is optional, and if not provided, the default date value is set to: NOW. Please mind, that if the date is set to the current day date or default value NOW, the exchange rates will be returned for the previous day i.e. Today - 1.
Euro foreign exchange reference rates
The reference rates are usually updated at around 16:00 CET every working day, except on TARGET closing days.
They are based on the daily concertation procedure between central banks across Europe, which normally takes place around 14:10 CET. The reference rates are published for information purposes only. Using the rates for transaction purposes is strongly discouraged.
Configuration
This connector does not include any configuration.
Input & Output Schema
Input
ECB Daily Rates Input (ver. 1.0.0)
Column | Data type | Allow null | Description |
---|---|---|---|
Date | DateTime | Yes | Exchange rate date |
LanguageCode | string | No | Returned data language code (CZ or EN) |
Output
ECB daily rates output (ver. 1.0.0)
Column | Data type | Allow null | Description |
---|---|---|---|
ValidFor | DateTime | No | Exchange rate validity date |
Currency | string | No | Currency name (based on language code from input data) |
CurrencyCode | string | No | Currency code in ISO 4217 format |
Amount | integer | No | Decimal place factor |
Rate | double | No | Exchange rate for the currency using the decimal place factor |
Release notes
3.0.1
- In case InputData property 'Date' is null yesterday date is used.
- Fix output schema values for properties
Currency
andCurrencyCode
3.0.0
- First release