CenterProfileLocations: Exact Online Accountant Profile Locations
read only REST
- Catalog:
ExactOnlineREST - Schema:
Accountancy - Primary Keys:
Id - Label: Accountant Profile Locations
Can only retrieve data.
API Source
- Endpoint:
https://start.exactonline.nl/api/public/accountancy.svc/CenterProfileLocations - Metadata:
https://start.exactonline.nl/api/public/accountancy.svc/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |
The result can be cached on the client.
Table Columns
The columns of the table CenterProfileLocations 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 |
|---|---|---|---|---|---|
Address |
varchar2 |
Address Line 1 | filters on the platform, writable | First address line. | |
Address |
varchar2 |
Address Line 2 | filters on the platform, writable | Second address line. | |
Address |
varchar2 |
Address Line 3 | filters on the platform, writable | Third address line. | |
City |
varchar2 |
City | filters on the platform, writable | City. | |
Contact |
varchar2 |
Contact Person | filters on the platform, writable | ||
Country |
varchar2 |
Country | filters on the platform, writable | Country code. | |
County |
varchar2 |
County | filters on the platform, writable | ||
Distance |
double |
Distance | filters on the platform, writable | ||
Email |
varchar2 |
filters on the platform, writable | Email address. | ||
Id |
guid |
ID | filters on the platform, writable | ||
Latitude |
double |
Latitude | filters on the platform, writable | ||
Longitude |
double |
Longitude | filters on the platform, writable | ||
Main |
int16 |
Main | filters on the platform, writable | ||
Name |
varchar2 |
Name | filters on the platform, writable | ||
Phone |
varchar2 |
Phone | filters on the platform, writable | Phone number. | |
Picture |
varchar2 |
Picture Name | filters on the platform, writable | ||
Picture |
varchar2 |
Picture (URL) | filters on the platform, writable | ||
Postcode |
varchar2 |
Postal Code | filters on the platform, writable | Postcode. | |
Profile |
guid |
Profile ID | filters on the platform, writable | ||
State |
varchar2 |
State | filters on the platform, writable | State/Province code. | |
Website |
varchar2 |
Website | filters on the platform, writable | Website. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: