CurrencyRate: Visma.net Financials Currency Rates
insert REST
- Catalog:
VismaNet - Schema:
CurrencyRate - Label: Currency Rates
Get all currency rates.
Can retrieve data and change data using insert.
API Source
- Endpoint:
/v2/currencyrate - Operation:
get /v2/currencyrate
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 239 |
| Full scan rows per minute | 3,010,000 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
from |
`` | Identifies from currency. | ||
from |
`` | From effective date. | ||
rate |
`` | Identifies rate type. | ||
to |
`` | Identifies to currency. | ||
toDate |
`` | To effective date. |
Table Columns
The columns of the table CurrencyRate are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COMPANY_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
effective |
datetime |
Effective Date | filters on the platform, writable, effective |
EffectiveDate | |
from |
varchar2 |
From Currency ID | filters on the platform, writable, from |
From Currency Id. | |
id |
int32 |
ID | filters on the platform, writable, id |
Currency rate Id. | |
mult |
varchar2 |
itgen_vnet_multdiv | filters on the platform, writable, mult |
Mult/Div | |
rate |
double |
itgen_vnet_rate | filters on the platform, writable, rate |
Currency rate. | |
rate |
double |
itgen_vnet_ratereciprocal | filters on the platform, writable, rate |
Rate reciprocal | |
rate |
varchar2 |
itgen_vnet_ratetype | filters on the platform, writable, rate |
Currency rate type. | |
time |
blob |
Timestamp | filters on the platform, writable, time |
Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers) | |
to |
varchar2 |
itgen_vnet_tocurrencyid | filters on the platform, writable, to |
To Currency Id. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Currency |
from |
Currencies.id |
Key | |
Currency |
to |
Currencies.id |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: