Me: Exact Online Me
insert update delete REST
- Catalogus:
ExactOnlineREST - Schema:
System - Primaire sleutels:
UserID - Label: Me
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
API-bron
- Eindpunt:
/api/v1/current/Me - Metagegevens:
/api/v1/current/$metadata
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 5 |
| Aantal rijen per minuut bij volledige scan | 7,200 |
| Aantal rijen per minuut in een Query | 300 |
| Aantal rijen per minuut schrijven | 300 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel Me worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Accounting |
int32 |
Boekhoud Afdeling | filters on the platform, writable | Accounting division number. | |
Application |
varchar2 |
Application | writable | Application being used. | |
Current |
int32 |
Huidige Divisie | 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 |
Klantcode | filters op het platform | ||
Data |
varchar2 |
Datacontainer ID | writable | ID of the data container. | |
Division |
int32 |
Divisie ID | writable | Division number of the user. | |
Division |
guid |
Divisie Klant | filters on the platform, writable | Owner account of the division. | |
Division |
varchar2 |
Divisie Klantcode | filters on the platform, writable | Owner account code of the division. | |
Division |
varchar2 |
Divisie Klantnaam | filters on the platform, writable | Owner account name of the division. | |
Division |
varchar2 |
Divisie Klant Siret-Nummer | filters on the platform, writable | Owner account SIRET Number of the division for French legislation. | |
Division |
varchar2 |
Divisie Klant BTW-nummer | filters on the platform, writable | Owner account VAT Number of the division. | |
Division |
varchar2 |
Divisie Label | writable | Label of the division. | |
Dossier |
int32 |
Divisie van Dossier | filters on the platform, writable | Dossier division number (optional). | |
Email |
varchar2 |
filters on the platform, writable | E-mailadres van de gebruiker. | ||
Employee |
guid |
Werknemer ID | filters on the platform, writable | Employee ID. | |
Environment |
varchar2 |
Exact Online Omgeving API Basis URL | writable | API base URL of the Exact Online environment. | |
Environment |
varchar2 |
Exact Online Omgeving Hoogste Niveau Domein | writable | Top-level domain of the Exact Online environment. | |
First |
varchar2 |
Voornaam | filters on the platform, writable | First name. | |
Full |
varchar2 |
Volledige Naam | 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-abonnement | writable | Whether the user is connected using an accountancy subscription. | |
Is |
char |
Is klantgebruiker | 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 op het platform | ||
Is |
char |
Is Ondernemersabonnement | writable | Whether the user is connected using an entrepreneur subscription. | |
Is |
char |
Is Mijn Firma Lite-gebruiker | filters op het platform | ||
Is |
char |
Is Mijn Klant Portaal-gebruiker | filters on the platform, writable | MyFirm user of accountant with limited access and specific start page (internal use). | |
Is |
char |
itgen_eol_isoeimigrationmandatory | filters op het platform | ||
Is |
char |
Is Startgebruiker | filters op het platform | ||
Language |
varchar2 |
Language | filters on the platform, writable | Language spoken by this user. | |
Language |
varchar2 |
Taalcode | filters on the platform, writable | Language (culture) that is used in Exact Online. | |
Last |
varchar2 |
Achternaam | filters on the platform, writable | Last name. | |
Legislation |
int64 |
Legislation | filters on the platform, writable | Legislation. | |
Middle |
varchar2 |
Tussenvoegsel | 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 op het platform | ||
Phone |
varchar2 |
Phone | filters on the platform, writable | Phone number. | |
Phone |
varchar2 |
Telefoontoestel | filters on the platform, writable | Phone number extension. | |
Picture |
varchar2 |
Afbeelding (URL) | filters on the platform, writable | Url that can be used to retrieve the picture of the user. | |
Server |
varchar2 |
Servertijd | 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 |
Miniatuurafbeelding | filters on the platform, writable | Binary thumbnail picture of this user. | |
Thumbnail |
varchar2 |
Miniatuurafbeeldingsformaat | filters on the platform, writable | File type of the picture. | |
Title |
varchar2 |
Title | filters on the platform, writable | Title. | |
User |
varchar2 |
Gebruikersadres, regel 1 | writable | Address line 1 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruikersadres, regel 2 | writable | Address line 2 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruikersadres, regel 3 | writable | Address line 3 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Klantgebruiker KvK-nummer | writable | Chamber of Commerce number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruiker Klant Stad | writable | City of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruiker Klantcode | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruiker Klant Land | writable | Country of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruiker Klant Valuta-code | writable | Currency code of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruiker Klantomschrijving | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruiker Klant E-mail | writable | Email of the owning customer of the subscription and user account. | |
User |
guid |
Gebruiker Klant ID | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruiker Klant Telefoon | writable | Phone of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruiker Klant Postcode | writable | Postal code of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruikersnummer (RSIN) van de klant | writable | RSIN number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Siret-nummer van de klant | writable | SIRET number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Status van de gebruiker/klant | writable | State of the owning customer of the subscription and user account. | |
User |
varchar2 |
BTW-nummer van de klant | writable | VAT number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Gebruiker Klantenwebsite | writable | Website of the owning customer of the subscription and user account. | |
UserID |
guid |
Gebruikers-ID | filters on the platform, writable | Primary key. | |
User |
varchar2 |
Gebruikersnaam | filters on the platform, writable | Login name of the user. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Me_ |
Employee |
Employees.ID |
Key |
Voorbeeldqueries
--
-- 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
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: