CNB daily rates currency month reader
[ | version 3.0]
Connector
The connector is permitted for use of the platform background agent.
Connector processing type: Row by row!
The CNB daily rates currency month reader is connected to the CNB API and returns the set of exchange rates for the defined single currency code and the month based on the provided date. More information is available on the public swagger.
The connector expects the input of:
-
single currency code (ISO format 4217) and
-
date (format yyyy-mm-ddThh:mm:ss.sss or yyyymmddThh:mm:ss.sss based on ISO 8601). The connector will parse the date and use the year and month part of it.
The currency code is mandatory, 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 all relevant days of the month except the current date.
Configuration
This connector does not include any configuration.
Input & Output Schema
Input
CNB daily rates currency month input (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| Currency | string | No | Currency code in ISO 4217 format |
| DateMonth | DateTime | Yes | Date - the month and year value will be taken to obtain the exchange rate. If the date is empty (null), actual date is taken. |
Output
CNB daily rates currency month output (ver. 1.0.0)
| Column | Data type | Allow null | Description |
|---|---|---|---|
| ValidFor | DateTime | No | Day in month (entire date) |
| CurrencyCode | string | No | Currency code in ISO 4217 format (CZK, EUR, USD, ...) |
| Amount | integer | No | Decimal place factor |
| Rate | double | No | Exchange rate for the currency using the decimal place factor |
Release notes
3.0.0
- First release