Me: Exact Online Me
insert update delete REST
- Katalog:
ExactOnlineREST - Schema:
System - Primärschlüssel:
UserID - Label: Me
Mit insert, update und delete können Daten abgerufen und geändert werden.
API-Quelle
- Endpunkt:
/api/v1/current/Me - Metadaten:
/api/v1/current/$metadata
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Durchschnittliche Zugriffsverzögerung (ms) | 5 |
| Anzahl der Vollscan-Zeilen pro Minute | 7,200 |
| Anzahl der Query-Zeilen pro Minute | 300 |
| Zeilen pro Minute schreiben | 300 |
Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.
Tabellenspalten
Die Spalten der Tabelle Me sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Accounting |
int32 |
Abteilung Buchhaltung | filters on the platform, writable | Accounting division number. | |
Application |
varchar2 |
Application | writable | Application being used. | |
Current |
int32 |
Aktueller Geschäftsbereich | 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 |
Kunde-Code | Filter auf der Plattform | ||
Data |
varchar2 |
Datenkontainer ID | writable | ID of the data container. | |
Division |
int32 |
Abteilung ID | writable | Division number of the user. | |
Division |
guid |
Geschäftsbereich Kunden | filters on the platform, writable | Owner account of the division. | |
Division |
varchar2 |
Geschäftsbereichskundennummer | filters on the platform, writable | Owner account code of the division. | |
Division |
varchar2 |
Abteilung Kundenname | filters on the platform, writable | Owner account name of the division. | |
Division |
varchar2 |
Geschäftsbereich Kunden-Siret-Nummer | filters on the platform, writable | Owner account SIRET Number of the division for French legislation. | |
Division |
varchar2 |
Division Kundenumsatzsteuernummer | filters on the platform, writable | Owner account VAT Number of the division. | |
Division |
varchar2 |
Abteilungsbezeichnung | writable | Label of the division. | |
Dossier |
int32 |
Dateiabteilung | filters on the platform, writable | Dossier division number (optional). | |
Email |
varchar2 |
filters on the platform, writable | E-Mail-Adresse des Benutzers. | ||
Employee |
guid |
Mitarbeiter ID | filters on the platform, writable | Employee ID. | |
Environment |
varchar2 |
Basis-URL der Exact Online Environment API | writable | API base URL of the Exact Online environment. | |
Environment |
varchar2 |
Exact Online-Umgebung – Top-Level-Domain | writable | Top-level domain of the Exact Online environment. | |
First |
varchar2 |
Vorname | filters on the platform, writable | First name. | |
Full |
varchar2 |
Vollständiger 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 |
Ist Buchhaltungsabonnement | writable | Whether the user is connected using an accountancy subscription. | |
Is |
char |
Ist Kundebenutzer | 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 | Filter auf der Plattform | ||
Is |
char |
Ist ein Unternehmerabonnement | writable | Whether the user is connected using an entrepreneur subscription. | |
Is |
char |
Bin ich ein „Firm Lite“-Nutzer? | Filter auf der Plattform | ||
Is |
char |
Ist Meine Firma Portalbenutzer | filters on the platform, writable | MyFirm user of accountant with limited access and specific start page (internal use). | |
Is |
char |
itgen_eol_isoeimigrationmandatory | Filter auf der Plattform | ||
Is |
char |
Ist Starter-Benutzer | Filter auf der Plattform | ||
Language |
varchar2 |
Language | filters on the platform, writable | Language spoken by this user. | |
Language |
varchar2 |
Sprachen-Code | filters on the platform, writable | Language (culture) that is used in Exact Online. | |
Last |
varchar2 |
Nachname | filters on the platform, writable | Last name. | |
Legislation |
int64 |
Legislation | filters on the platform, writable | Legislation. | |
Middle |
varchar2 |
Zweiter 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 | Filter auf der Plattform | ||
Phone |
varchar2 |
Phone | filters on the platform, writable | Phone number. | |
Phone |
varchar2 |
Telefon-Durchwahl | filters on the platform, writable | Phone number extension. | |
Picture |
varchar2 |
Bild (URL) | filters on the platform, writable | Url that can be used to retrieve the picture of the user. | |
Server |
varchar2 |
Serverzeit | 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 Bild | filters on the platform, writable | Binary thumbnail picture of this user. | |
Thumbnail |
varchar2 |
Thumbnail Bild Format | filters on the platform, writable | File type of the picture. | |
Title |
varchar2 |
Title | filters on the platform, writable | Title. | |
User |
varchar2 |
Adresse des Kunden – Zeile 1 | writable | Address line 1 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Adresse des Kunden – Zeile 2 | writable | Address line 2 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Adresse des Kunden – Zeile 3 | writable | Address line 3 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer-CoC-Nummer | writable | Chamber of Commerce number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer Kunde Ort | writable | City of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer-Kundennummer | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer Kunde Land | writable | Country of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer Kunde Währung | writable | Currency code of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer-Kundenbeschreibung | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer, Kunde, E-Mail-Adresse | writable | Email of the owning customer of the subscription and user account. | |
User |
guid |
Benutzer-Kunden-ID | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer Kunde Telefon | writable | Phone of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer Kunde Postleitzahl | writable | Postal code of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer-Kunden-RSIN-Nummer | writable | RSIN number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Siret-Nummer des Kunden | writable | SIRET number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer-Kundenstatus | writable | State of the owning customer of the subscription and user account. | |
User |
varchar2 |
Umsatzsteuer-Identifikationsnummer des Kunden | writable | VAT number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Benutzer-Kunden-Website | writable | Website of the owning customer of the subscription and user account. | |
UserID |
guid |
Benutzer-Kennung | filters on the platform, writable | Primary key. | |
User |
varchar2 |
Benutzername | filters on the platform, writable | Login name of the user. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Me_ |
Employee |
Employees.ID |
Key |
Beispiel-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
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: