ECB daily rates reader

[ | version 3.0]

Connector

The connector is permitted for use of the platform background agent.

Connector processing type: Row by row!

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 and CurrencyCode

3.0.0

• First release

---

Was this page helpful?

×

Yes No

What is the reason for your feedback?

Tell us more:

Submit Privacy Policy