← Return to the list of available actions
If you have trouble understanding how the action works, check the descriptions: Action, Conditional execution, Component parameters
Basic information
Category: Currency
Action location: Table, Table button, Form button
Available from version: 1.0.X
Description
The action collects the value of PLN exchange rate for each row. Additionally, they can save the table number and / or the table symbol taken from the NBP. Data are downloaded directly from the NBP website. The component starts up changing the column value given above in the parameters "Currency code" and "Date of exchange rate".
Configuration parameters
| Name of the parameter | From version | Description | Parameter type | Default value | Field type | Notes and restrictions |
|---|---|---|---|---|---|---|
| Currency code* | 1.0.81 | Column containing currency codes in ISO format (currency codes are available on the NBP)website), e.g. EUR, USD | An array of text variables | Editable field | ||
| Date of exchange rate* | 1.0.81 | Column in the table with the date of the exchange rate | An array of date variables | Editable field | ||
| Exchange rate* | 1.0.81 | A column in the table to save the course value | An array of floating point variables | Editable field | ||
| Table number | 1.0.81 | Column for entering the table number from which the exchange ratewas taken | An array of text variables | Editable field | ||
| Table type | 1.0.81 | Column for writing the table type from which the exchange ratewas taken | An array of text variables | Editable field | ||
| Line condition | 1.0.81 | The function called for each line. The type of function being returned is logical | Function | Editable field | Possibility of using the tabular variable "Row index" | |
| Day shift* | 1.0.106 | Modify the date of downloading the course (adds / subtracts the number of days from the given date) | Integer | Editable field | Modifies the date of downloading the courses for all the rows in the table Example: | |
| Effective date | 1.0.162; 1.1.8
| Effective date the request has been made for. | Text variable | |||
| Removed in version 1.0.153 | ||||||
| Dynamic table ID | 1.0.138 | Specifies the table that will have exchange rates updated. | Text | Editable field | The parameter is visible and mandatory only when the action is placed on the form button. |
Parameter*- required field
Sample configuration
Change log
1.0.81 (applicable documentation)
- Adding component
1.0.98
- Adding a comment in the popup in case of an error
1.0.106
- Adding day shift parameter
1.0.135 (applicable documentation)
- Added "NBP Bank timezone" parameter
1.0.138
- Allowing the action to be placed on the table button and form button. Adding the "Dynamic Table ID" parameter
1.0.153
- Removed "NBP Bank timezone" parameter
- Logging ActivityId
1.0.162;
1.1.8
- Possibility to set effective exchange date variable.
1 Comment
Tomasz Wojciechowski
przykład sprawdzenia w przeglądarce czy u klienta pobiera się kurs EUR z danego zakresu (w poniższych przypadku data od i do jest taka sama ustawiona):
http://api.nbp.pl/api/exchangerates/rates/A/EUR/2021-10-21/2021-10-21?format=json
jak nie znajdzie w tabeli A to szuka w tabeli B:
http://api.nbp.pl/api/exchangerates/rates/B/EUR/2021-10-21/2021-10-21?format=json
Na linuxie można skorzystać z polecenia curl w konsoli, czyli
curl http://api.nbp.pl/api/exchangerates/rates/A/EUR/2021-10-21/2021-10-21?format=json
Add Comment