invantive documentation
Invantive Support ForumsLog In / Sign Up

CenterProfiles: Exact Online Accountant Profiles

read only REST

  • Catalog: ExactOnlineREST
  • Schema: Accountancy
  • Primary Keys: Id
  • Label: Accountant Profiles

Can only retrieve data.

API Source

  • Endpoint: https://start.exactonline.nl/api/public/accountancy.svc/CenterProfiles
  • 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 CenterProfiles 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
Customer guid Customer filters on the platform, writable Reference to customer (account).
Distance double Distance filters on the platform, writable
Id guid ID filters on the platform, writable
IsCertified char Is Certified filters on the platform, writable
LocationName varchar2 Location Name filters on the platform, writable
LocationsCount int32 Location Count filters on the platform, writable
LogoName varchar2 Logo Name filters on the platform, writable
LogoUrl varchar2 Logo (URL) filters on the platform, writable
Name varchar2(50) Name filters on the platform, writable
ProfileText varchar2 Profile Text filters on the platform, writable
RowId int32 Row ID filters on the platform, writable

Keys

Key Column Refers to Kind Description
CenterProfiles_Customer_Accounts_fk Customer Accounts.ID Key

Release Notes

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