invantive documentation
Invantive Support ForumsLog In / Sign Up

Me: Exact Online Me

insert update delete REST

  • Catalog: ExactOnlineREST
  • Schema: System
  • Primary Keys: UserID
  • Label: Me

Can retrieve data and change data using insert, update and delete.

API Source

  • Endpoint: /api/v1/current/Me
  • Metadata: /api/v1/current/$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 Me 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
AccountingDivision int32 Accounting Division filters on the platform, writable Accounting division number.
Application varchar2(240) Application writable Application being used.
CurrentDivision int32 Current Division filters on the platform, writable Division number that is currently used in the API. You should use a division number in the url.
CustomerCode varchar2 Customer Code filters on the platform
DataContainerID varchar2 Data Container ID writable ID of the data container.
Division int32 Division ID writable Division number of the user.
DivisionCustomer guid Division Customer filters on the platform, writable Owner account of the division.
DivisionCustomerCode varchar2(18) Division Customer Code filters on the platform, writable Owner account code of the division.
DivisionCustomerName varchar2 Division Customer Name filters on the platform, writable Owner account name of the division.
DivisionCustomerSiretNumber varchar2 Division Customer Siret Number filters on the platform, writable Owner account SIRET Number of the division for French legislation.
DivisionCustomerVatNumber varchar2(35) Division Customer VAT Number filters on the platform, writable Owner account VAT Number of the division.
DivisionLabel varchar2(128) Division Label writable Label of the division.
DossierDivision int32 File Division filters on the platform, writable Dossier division number (optional).
Email varchar2(128) Email filters on the platform, writable Email address of the user.
EmployeeID guid Employee ID filters on the platform, writable Employee ID.
EnvironmentApiBaseUrl varchar2(60) Exact Online Environment API Base URL writable API base URL of the Exact Online environment.
EnvironmentTopLevelDomain varchar2(30) Exact Online Environment Top-level Domain writable Top-level domain of the Exact Online environment.
FirstName varchar2(64) First Name filters on the platform, writable First name.
FullName varchar2(240) Full Name filters on the platform, writable Full name of the user.
Gender varchar2(1) Gender filters on the platform, writable Gender: M=Male, V=Female, O=Unknown.
Initials varchar2(10) Initials filters on the platform, writable Initials.
IsAccountancySubscription char Is Accountancy Subscription writable Whether the user is connected using an accountancy subscription.
IsClientUser char Is Client User filters on the platform, writable Client user of an accountant: either a portal user or a non-accountant user with his own license (internal use).
IsEmployeeSelfServiceUser char itgen_eol_isemployeeselfserviceuser filters on the platform
IsEntrepreneurSubscription char Is Entrepreneur Subscription writable Whether the user is connected using an entrepreneur subscription.
IsMyFirmLiteUser char Is My Firm Lite User filters on the platform
IsMyFirmPortalUser char Is My Firm Portal User filters on the platform, writable MyFirm user of accountant with limited access and specific start page (internal use).
IsOEIMigrationMandatory char itgen_eol_isoeimigrationmandatory filters on the platform
IsStarterUser char Is Starter User filters on the platform
Language varchar2(30) Language filters on the platform, writable Language spoken by this user.
LanguageCode varchar2(30) Language Code filters on the platform, writable Language (culture) that is used in Exact Online.
LastName varchar2(60) Last Name filters on the platform, writable Last name.
Legislation int64 Legislation filters on the platform, writable Legislation.
MiddleName varchar2 Middle Name filters on the platform, writable Middle name.
Mobile varchar2(25) Mobile filters on the platform, writable Mobile phone.
Nationality varchar2 Nationality filters on the platform, writable Nationality.
PackageCode varchar2 itgen_eol_packagecode filters on the platform
Phone varchar2(25) Phone filters on the platform, writable Phone number.
PhoneExtension varchar2(15) Phone Extension filters on the platform, writable Phone number extension.
PictureUrl varchar2 Picture (URL) filters on the platform, writable Url that can be used to retrieve the picture of the user.
ServerTime varchar2 Server Time filters on the platform, writable The current date and time in Exact Online.
ServerUtcOffset double Server UTC Offset filters on the platform, writable The time difference with UTC in seconds.
ThumbnailPicture blob Thumbnail Picture filters on the platform, writable Binary thumbnail picture of this user.
ThumbnailPictureFormat varchar2 Thumbnail Picture Format filters on the platform, writable File type of the picture.
Title varchar2 Title filters on the platform, writable Title.
UserCustomerAddressLine1 varchar2 User Customer Address Line 1 writable Address line 1 of the owning customer of the subscription and user account.
UserCustomerAddressLine2 varchar2 User Customer Address Line 2 writable Address line 2 of the owning customer of the subscription and user account.
UserCustomerAddressLine3 varchar2 User Customer Address Line 3 writable Address line 3 of the owning customer of the subscription and user account.
UserCustomerChamberOfCommerceNumber varchar2 User Customer CoC Number writable Chamber of Commerce number of the owning customer of the subscription and user account.
UserCustomerCity varchar2 User Customer City writable City of the owning customer of the subscription and user account.
UserCustomerCode varchar2 User Customer Code writable ID of the owning customer of the subscription and user account.
UserCustomerCountry varchar2 User Customer Country writable Country of the owning customer of the subscription and user account.
UserCustomerCurrencyCode varchar2 User Customer Currency Code writable Currency code of the owning customer of the subscription and user account.
UserCustomerDescription varchar2 User Customer Description writable ID of the owning customer of the subscription and user account.
UserCustomerEmail varchar2 User Customer Email writable Email of the owning customer of the subscription and user account.
UserCustomerId guid User Customer ID writable ID of the owning customer of the subscription and user account.
UserCustomerPhone varchar2 User Customer Phone writable Phone of the owning customer of the subscription and user account.
UserCustomerPostalCode varchar2 User Customer Postal Code writable Postal code of the owning customer of the subscription and user account.
UserCustomerRsinNumber varchar2 User Customer RSIN Number writable RSIN number of the owning customer of the subscription and user account.
UserCustomerSiretNumber varchar2 User Customer Siret Number writable SIRET number of the owning customer of the subscription and user account.
UserCustomerState varchar2 User Customer State writable State of the owning customer of the subscription and user account.
UserCustomerVatNumber varchar2 User Customer VAT Number writable VAT number of the owning customer of the subscription and user account.
UserCustomerWebsite varchar2 User Customer Website writable Website of the owning customer of the subscription and user account.
UserID guid User ID filters on the platform, writable Primary key.
UserName varchar2 User Name filters on the platform, writable Login name of the user.

Keys

Key Column Refers to Kind Description
Me_EmployeeID_Employees_fk EmployeeID Employees.ID Key

Sample Queries

--
-- Financial transaction lines from all journals and selected companies. Note that LineNumber 0 reflects the header and 9999 the VAT.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/exact-online-data-model/webhelp/exact-online-connector-exactonlinerest-incremental-transactionlinesincremental.html
--
-- Related forum post: https://forums.invantive.eu/t/recommended-and-popular-exact-online-tables-for-2022/2340
--
select *
from   ExactOnlineREST.Incremental.TransactionLinesIncremental@eol
limit  100
--
-- Retrieve list of all Exact Online companies. For accountants, companies of customers are also included.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/exact-online-data-model/webhelp/exact-online-connector-exactonlinerest-system-systemdivisions.html
--
-- Related forum post: https://forums.invantive.eu/t/selecting-partitions-administrations-via-the-use-sql-statement/2172
--
select *
from   ExactOnlineREST.System.SystemDivisions@eol
limit  100

Release Notes

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