invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

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
AccountingDivision int32 Boekhoud Afdeling filters on the platform, writable Accounting division number.
Application varchar2(240) Application writable Application being used.
CurrentDivision 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.
CustomerCode varchar2 Klantcode filters op het platform
DataContainerID varchar2 Datacontainer ID writable ID of the data container.
Division int32 Divisie ID writable Division number of the user.
DivisionCustomer guid Divisie Klant filters on the platform, writable Owner account of the division.
DivisionCustomerCode varchar2(18) Divisie Klantcode filters on the platform, writable Owner account code of the division.
DivisionCustomerName varchar2 Divisie Klantnaam filters on the platform, writable Owner account name of the division.
DivisionCustomerSiretNumber varchar2 Divisie Klant Siret-Nummer filters on the platform, writable Owner account SIRET Number of the division for French legislation.
DivisionCustomerVatNumber varchar2(35) Divisie Klant BTW-nummer filters on the platform, writable Owner account VAT Number of the division.
DivisionLabel varchar2(128) Divisie Label writable Label of the division.
DossierDivision int32 Divisie van Dossier filters on the platform, writable Dossier division number (optional).
Email varchar2(128) Email filters on the platform, writable E-mailadres van de gebruiker.
EmployeeID guid Werknemer ID filters on the platform, writable Employee ID.
EnvironmentApiBaseUrl varchar2(60) Exact Online Omgeving API Basis URL writable API base URL of the Exact Online environment.
EnvironmentTopLevelDomain varchar2(30) Exact Online Omgeving Hoogste Niveau Domein writable Top-level domain of the Exact Online environment.
FirstName varchar2(64) Voornaam filters on the platform, writable First name.
FullName varchar2(240) Volledige Naam 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-abonnement writable Whether the user is connected using an accountancy subscription.
IsClientUser 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).
IsEmployeeSelfServiceUser char itgen_eol_isemployeeselfserviceuser filters op het platform
IsEntrepreneurSubscription char Is Ondernemersabonnement writable Whether the user is connected using an entrepreneur subscription.
IsMyFirmLiteUser char Is Mijn Firma Lite-gebruiker filters op het platform
IsMyFirmPortalUser char Is Mijn Klant Portaal-gebruiker filters on the platform, writable MyFirm user of accountant with limited access and specific start page (internal use).
IsOEIMigrationMandatory char itgen_eol_isoeimigrationmandatory filters op het platform
IsStarterUser char Is Startgebruiker filters op het platform
Language varchar2(30) Language filters on the platform, writable Language spoken by this user.
LanguageCode varchar2(30) Taalcode filters on the platform, writable Language (culture) that is used in Exact Online.
LastName varchar2(60) Achternaam filters on the platform, writable Last name.
Legislation int64 Legislation filters on the platform, writable Legislation.
MiddleName varchar2 Tussenvoegsel 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 op het platform
Phone varchar2(25) Phone filters on the platform, writable Phone number.
PhoneExtension varchar2(15) Telefoontoestel filters on the platform, writable Phone number extension.
PictureUrl varchar2 Afbeelding (URL) filters on the platform, writable Url that can be used to retrieve the picture of the user.
ServerTime varchar2 Servertijd 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 Miniatuurafbeelding filters on the platform, writable Binary thumbnail picture of this user.
ThumbnailPictureFormat varchar2 Miniatuurafbeeldingsformaat filters on the platform, writable File type of the picture.
Title varchar2 Title filters on the platform, writable Title.
UserCustomerAddressLine1 varchar2 Gebruikersadres, regel 1 writable Address line 1 of the owning customer of the subscription and user account.
UserCustomerAddressLine2 varchar2 Gebruikersadres, regel 2 writable Address line 2 of the owning customer of the subscription and user account.
UserCustomerAddressLine3 varchar2 Gebruikersadres, regel 3 writable Address line 3 of the owning customer of the subscription and user account.
UserCustomerChamberOfCommerceNumber varchar2 Klantgebruiker KvK-nummer writable Chamber of Commerce number of the owning customer of the subscription and user account.
UserCustomerCity varchar2 Gebruiker Klant Stad writable City of the owning customer of the subscription and user account.
UserCustomerCode varchar2 Gebruiker Klantcode writable ID of the owning customer of the subscription and user account.
UserCustomerCountry varchar2 Gebruiker Klant Land writable Country of the owning customer of the subscription and user account.
UserCustomerCurrencyCode varchar2 Gebruiker Klant Valuta-code writable Currency code of the owning customer of the subscription and user account.
UserCustomerDescription varchar2 Gebruiker Klantomschrijving writable ID of the owning customer of the subscription and user account.
UserCustomerEmail varchar2 Gebruiker Klant E-mail writable Email of the owning customer of the subscription and user account.
UserCustomerId guid Gebruiker Klant ID writable ID of the owning customer of the subscription and user account.
UserCustomerPhone varchar2 Gebruiker Klant Telefoon writable Phone of the owning customer of the subscription and user account.
UserCustomerPostalCode varchar2 Gebruiker Klant Postcode writable Postal code of the owning customer of the subscription and user account.
UserCustomerRsinNumber varchar2 Gebruikersnummer (RSIN) van de klant writable RSIN number of the owning customer of the subscription and user account.
UserCustomerSiretNumber varchar2 Siret-nummer van de klant writable SIRET number of the owning customer of the subscription and user account.
UserCustomerState varchar2 Status van de gebruiker/klant writable State of the owning customer of the subscription and user account.
UserCustomerVatNumber varchar2 BTW-nummer van de klant writable VAT number of the owning customer of the subscription and user account.
UserCustomerWebsite 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.
UserName varchar2 Gebruikersnaam filters on the platform, writable Login name of the user.

Toetsen

Key Column Verwijst naar Kind Description
Me_EmployeeID_Employees_fk EmployeeID 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: