invantive documentation
Invantive Support ForumsLog In / Sign Up

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
AddressLine1 varchar2(80) Address Line 1 filters on the platform, writable First address line.
AddressLine2 varchar2(80) Address Line 2 filters on the platform, writable Second address line.
AddressLine3 varchar2(80) Address Line 3 filters on the platform, writable Third address line.
City varchar2(30) City filters on the platform, writable City.
ContactPerson varchar2 Contact Person filters on the platform, writable
Country varchar2(30) 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(128) Email 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(240) Name filters on the platform, writable
Phone varchar2(25) Phone filters on the platform, writable Phone number.
PictureName varchar2 Picture Name filters on the platform, writable
PictureUrl varchar2 Picture (URL) filters on the platform, writable
Postcode varchar2(20) Postal Code filters on the platform, writable Postcode.
ProfileId guid Profile ID filters on the platform, writable
State varchar2(30) State filters on the platform, writable State/Province code.
Website varchar2(128) Website filters on the platform, writable Website.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: