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 |
|---|---|---|---|---|---|
Accounting |
int32 |
Accounting Division | filters on the platform, writable | Accounting division number. | |
Application |
varchar2 |
Application | writable | Application being used. | |
Current |
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. | |
Customer |
varchar2 |
Customer Code | filters on the platform | ||
Data |
varchar2 |
Data Container ID | writable | ID of the data container. | |
Division |
int32 |
Division ID | writable | Division number of the user. | |
Division |
guid |
Division Customer | filters on the platform, writable | Owner account of the division. | |
Division |
varchar2 |
Division Customer Code | filters on the platform, writable | Owner account code of the division. | |
Division |
varchar2 |
Division Customer Name | filters on the platform, writable | Owner account name of the division. | |
Division |
varchar2 |
Division Customer Siret Number | filters on the platform, writable | Owner account SIRET Number of the division for French legislation. | |
Division |
varchar2 |
Division Customer VAT Number | filters on the platform, writable | Owner account VAT Number of the division. | |
Division |
varchar2 |
Division Label | writable | Label of the division. | |
Dossier |
int32 |
File Division | filters on the platform, writable | Dossier division number (optional). | |
Email |
varchar2 |
filters on the platform, writable | Email address of the user. | ||
Employee |
guid |
Employee ID | filters on the platform, writable | Employee ID. | |
Environment |
varchar2 |
Exact Online Environment API Base URL | writable | API base URL of the Exact Online environment. | |
Environment |
varchar2 |
Exact Online Environment Top-level Domain | writable | Top-level domain of the Exact Online environment. | |
First |
varchar2 |
First Name | filters on the platform, writable | First name. | |
Full |
varchar2 |
Full Name | filters on the platform, writable | Full name of the user. | |
Gender |
varchar2 |
Gender | filters on the platform, writable | Gender: M=Male, V=Female, O=Unknown. | |
Initials |
varchar2 |
Initials | filters on the platform, writable | Initials. | |
Is |
char |
Is Accountancy Subscription | writable | Whether the user is connected using an accountancy subscription. | |
Is |
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). | |
Is |
char |
itgen_eol_isemployeeselfserviceuser | filters on the platform | ||
Is |
char |
Is Entrepreneur Subscription | writable | Whether the user is connected using an entrepreneur subscription. | |
Is |
char |
Is My Firm Lite User | filters on the platform | ||
Is |
char |
Is My Firm Portal User | filters on the platform, writable | MyFirm user of accountant with limited access and specific start page (internal use). | |
Is |
char |
itgen_eol_isoeimigrationmandatory | filters on the platform | ||
Is |
char |
Is Starter User | filters on the platform | ||
Language |
varchar2 |
Language | filters on the platform, writable | Language spoken by this user. | |
Language |
varchar2 |
Language Code | filters on the platform, writable | Language (culture) that is used in Exact Online. | |
Last |
varchar2 |
Last Name | filters on the platform, writable | Last name. | |
Legislation |
int64 |
Legislation | filters on the platform, writable | Legislation. | |
Middle |
varchar2 |
Middle Name | filters on the platform, writable | Middle name. | |
Mobile |
varchar2 |
Mobile | filters on the platform, writable | Mobile phone. | |
Nationality |
varchar2 |
Nationality | filters on the platform, writable | Nationality. | |
Package |
varchar2 |
itgen_eol_packagecode | filters on the platform | ||
Phone |
varchar2 |
Phone | filters on the platform, writable | Phone number. | |
Phone |
varchar2 |
Phone Extension | filters on the platform, writable | Phone number extension. | |
Picture |
varchar2 |
Picture (URL) | filters on the platform, writable | Url that can be used to retrieve the picture of the user. | |
Server |
varchar2 |
Server Time | filters on the platform, writable | The current date and time in Exact Online. | |
Server |
double |
Server UTC Offset | filters on the platform, writable | The time difference with UTC in seconds. | |
Thumbnail |
blob |
Thumbnail Picture | filters on the platform, writable | Binary thumbnail picture of this user. | |
Thumbnail |
varchar2 |
Thumbnail Picture Format | filters on the platform, writable | File type of the picture. | |
Title |
varchar2 |
Title | filters on the platform, writable | Title. | |
User |
varchar2 |
User Customer Address Line 1 | writable | Address line 1 of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer Address Line 2 | writable | Address line 2 of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer Address Line 3 | writable | Address line 3 of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer CoC Number | writable | Chamber of Commerce number of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer City | writable | City of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer Code | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer Country | writable | Country of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer Currency Code | writable | Currency code of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer Description | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer Email | writable | Email of the owning customer of the subscription and user account. | |
User |
guid |
User Customer ID | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer Phone | writable | Phone of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer Postal Code | writable | Postal code of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer RSIN Number | writable | RSIN number of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer Siret Number | writable | SIRET number of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer State | writable | State of the owning customer of the subscription and user account. | |
User |
varchar2 |
User Customer VAT Number | writable | VAT number of the owning customer of the subscription and user account. | |
User |
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. | |
User |
varchar2 |
User Name | filters on the platform, writable | Login name of the user. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Me_ |
Employee |
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: