invantive documentation
Invantive SupportforenAnmelden / Eintragen

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
AccountingDivision int32 Abteilung Buchhaltung filters on the platform, writable Accounting division number.
Application varchar2(240) Application writable Application being used.
CurrentDivision 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.
CustomerCode varchar2 Kunde-Code Filter auf der Plattform
DataContainerID varchar2 Datenkontainer ID writable ID of the data container.
Division int32 Abteilung ID writable Division number of the user.
DivisionCustomer guid Geschäftsbereich Kunden filters on the platform, writable Owner account of the division.
DivisionCustomerCode varchar2(18) Geschäftsbereichskundennummer filters on the platform, writable Owner account code of the division.
DivisionCustomerName varchar2 Abteilung Kundenname filters on the platform, writable Owner account name of the division.
DivisionCustomerSiretNumber varchar2 Geschäftsbereich Kunden-Siret-Nummer filters on the platform, writable Owner account SIRET Number of the division for French legislation.
DivisionCustomerVatNumber varchar2(35) Division Kundenumsatzsteuernummer filters on the platform, writable Owner account VAT Number of the division.
DivisionLabel varchar2(128) Abteilungsbezeichnung writable Label of the division.
DossierDivision int32 Dateiabteilung filters on the platform, writable Dossier division number (optional).
Email varchar2(128) Email filters on the platform, writable E-Mail-Adresse des Benutzers.
EmployeeID guid Mitarbeiter ID filters on the platform, writable Employee ID.
EnvironmentApiBaseUrl varchar2(60) Basis-URL der Exact Online Environment API writable API base URL of the Exact Online environment.
EnvironmentTopLevelDomain varchar2(30) Exact Online-Umgebung – Top-Level-Domain writable Top-level domain of the Exact Online environment.
FirstName varchar2(64) Vorname filters on the platform, writable First name.
FullName varchar2(240) Vollständiger 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 Ist Buchhaltungsabonnement writable Whether the user is connected using an accountancy subscription.
IsClientUser 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).
IsEmployeeSelfServiceUser char itgen_eol_isemployeeselfserviceuser Filter auf der Plattform
IsEntrepreneurSubscription char Ist ein Unternehmerabonnement writable Whether the user is connected using an entrepreneur subscription.
IsMyFirmLiteUser char Bin ich ein „Firm Lite“-Nutzer? Filter auf der Plattform
IsMyFirmPortalUser char Ist Meine Firma Portalbenutzer filters on the platform, writable MyFirm user of accountant with limited access and specific start page (internal use).
IsOEIMigrationMandatory char itgen_eol_isoeimigrationmandatory Filter auf der Plattform
IsStarterUser char Ist Starter-Benutzer Filter auf der Plattform
Language varchar2(30) Language filters on the platform, writable Language spoken by this user.
LanguageCode varchar2(30) Sprachen-Code filters on the platform, writable Language (culture) that is used in Exact Online.
LastName varchar2(60) Nachname filters on the platform, writable Last name.
Legislation int64 Legislation filters on the platform, writable Legislation.
MiddleName varchar2 Zweiter 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 Filter auf der Plattform
Phone varchar2(25) Phone filters on the platform, writable Phone number.
PhoneExtension varchar2(15) Telefon-Durchwahl filters on the platform, writable Phone number extension.
PictureUrl varchar2 Bild (URL) filters on the platform, writable Url that can be used to retrieve the picture of the user.
ServerTime varchar2 Serverzeit 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 Bild filters on the platform, writable Binary thumbnail picture of this user.
ThumbnailPictureFormat varchar2 Thumbnail Bild Format filters on the platform, writable File type of the picture.
Title varchar2 Title filters on the platform, writable Title.
UserCustomerAddressLine1 varchar2 Adresse des Kunden – Zeile 1 writable Address line 1 of the owning customer of the subscription and user account.
UserCustomerAddressLine2 varchar2 Adresse des Kunden – Zeile 2 writable Address line 2 of the owning customer of the subscription and user account.
UserCustomerAddressLine3 varchar2 Adresse des Kunden – Zeile 3 writable Address line 3 of the owning customer of the subscription and user account.
UserCustomerChamberOfCommerceNumber varchar2 Benutzer-CoC-Nummer writable Chamber of Commerce number of the owning customer of the subscription and user account.
UserCustomerCity varchar2 Benutzer Kunde Ort writable City of the owning customer of the subscription and user account.
UserCustomerCode varchar2 Benutzer-Kundennummer writable ID of the owning customer of the subscription and user account.
UserCustomerCountry varchar2 Benutzer Kunde Land writable Country of the owning customer of the subscription and user account.
UserCustomerCurrencyCode varchar2 Benutzer Kunde Währung writable Currency code of the owning customer of the subscription and user account.
UserCustomerDescription varchar2 Benutzer-Kundenbeschreibung writable ID of the owning customer of the subscription and user account.
UserCustomerEmail varchar2 Benutzer, Kunde, E-Mail-Adresse writable Email of the owning customer of the subscription and user account.
UserCustomerId guid Benutzer-Kunden-ID writable ID of the owning customer of the subscription and user account.
UserCustomerPhone varchar2 Benutzer Kunde Telefon writable Phone of the owning customer of the subscription and user account.
UserCustomerPostalCode varchar2 Benutzer Kunde Postleitzahl writable Postal code of the owning customer of the subscription and user account.
UserCustomerRsinNumber varchar2 Benutzer-Kunden-RSIN-Nummer writable RSIN number of the owning customer of the subscription and user account.
UserCustomerSiretNumber varchar2 Siret-Nummer des Kunden writable SIRET number of the owning customer of the subscription and user account.
UserCustomerState varchar2 Benutzer-Kundenstatus writable State of the owning customer of the subscription and user account.
UserCustomerVatNumber varchar2 Umsatzsteuer-Identifikationsnummer des Kunden writable VAT number of the owning customer of the subscription and user account.
UserCustomerWebsite 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.
UserName varchar2 Benutzername filters on the platform, writable Login name of the user.

Tasten

Key Column Bezieht sich auf Kind Description
Me_EmployeeID_Employees_fk EmployeeID 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: