invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Me: Exact Online Me

insert update delete REST

  • Catalogue : ExactOnlineREST
  • Schéma : System
  • Clés primaires : UserID
  • Label: Me

Permet de récupérer et de modifier des données à l'aide de insert, update et delete.

Source de l'API

  • Point de terminaison : /api/v1/current/Me
  • Métadonnées : /api/v1/current/$metadata

Caractéristiques de performance

Characteristic Value
Latence moyenne d'accès (ms) 5
Nombre de lignes par minute en mode de balayage complet 7,200
Nombre de lignes de requêtes ponctuelles par minute 300
Nombre d'enregistrements écrits par minute 300

Le résultat peut être mis en cache côté client.

Colonnes de table

Les colonnes de la table Me sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
AccountingDivision int32 Service comptable filters on the platform, writable Accounting division number.
Application varchar2(240) Application writable Application being used.
CurrentDivision int32 Division actuelle 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 Code client filtres disponibles sur la plateforme
DataContainerID varchar2 ID du conteneur de données writable ID of the data container.
Division int32 ID de l'entreprise writable Division number of the user.
DivisionCustomer guid Division Clients filters on the platform, writable Owner account of the division.
DivisionCustomerCode varchar2(18) Code client de la division filters on the platform, writable Owner account code of the division.
DivisionCustomerName varchar2 Division Nom du client filters on the platform, writable Owner account name of the division.
DivisionCustomerSiretNumber varchar2 Division - Numéro SIRET du client filters on the platform, writable Owner account SIRET Number of the division for French legislation.
DivisionCustomerVatNumber varchar2(35) Numéro de TVA client de la division filters on the platform, writable Owner account VAT Number of the division.
DivisionLabel varchar2(128) Étiquette de division writable Label of the division.
DossierDivision int32 Division des fichiers filters on the platform, writable Dossier division number (optional).
Email varchar2(128) Email filters on the platform, writable Adresse e-mail de l'utilisateur.
EmployeeID guid ID d'employé filters on the platform, writable Employee ID.
EnvironmentApiBaseUrl varchar2(60) URL de base de l'API Exact Online Environment writable API base URL of the Exact Online environment.
EnvironmentTopLevelDomain varchar2(30) Domaine de premier niveau « Exact Online Environment » writable Top-level domain of the Exact Online environment.
FirstName varchar2(64) Prénom filters on the platform, writable First name.
FullName varchar2(240) Nom complet pour utilisation dans les listes 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 Abonnement à « Accountancy » writable Whether the user is connected using an accountancy subscription.
IsClientUser char Est-ce un utilisateur client ? 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 filtres disponibles sur la plateforme
IsEntrepreneurSubscription char Abonnement à Entrepreneur writable Whether the user is connected using an entrepreneur subscription.
IsMyFirmLiteUser char Suis-je un utilisateur de la version Lite de My Firm ? filtres disponibles sur la plateforme
IsMyFirmPortalUser char Je suis un utilisateur du portail de mon cabinet filters on the platform, writable MyFirm user of accountant with limited access and specific start page (internal use).
IsOEIMigrationMandatory char itgen_eol_isoeimigrationmandatory filtres disponibles sur la plateforme
IsStarterUser char Est-il un utilisateur débutant ? filtres disponibles sur la plateforme
Language varchar2(30) Language filters on the platform, writable Language spoken by this user.
LanguageCode varchar2(30) Code de langue filters on the platform, writable Language (culture) that is used in Exact Online.
LastName varchar2(60) Nom filters on the platform, writable Last name.
Legislation int64 Legislation filters on the platform, writable Legislation.
MiddleName varchar2 Deuxième prénom 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 filtres disponibles sur la plateforme
Phone varchar2(25) Phone filters on the platform, writable Phone number.
PhoneExtension varchar2(15) Poste téléphonique filters on the platform, writable Phone number extension.
PictureUrl varchar2 Image (URL) filters on the platform, writable Url that can be used to retrieve the picture of the user.
ServerTime varchar2 Temps de serveur filters on the platform, writable The current date and time in Exact Online.
ServerUtcOffset double Décalage horaire UTC du serveur filters on the platform, writable The time difference with UTC in seconds.
ThumbnailPicture blob Vignette filters on the platform, writable Binary thumbnail picture of this user.
ThumbnailPictureFormat varchar2 Format des vignettes filters on the platform, writable File type of the picture.
Title varchar2 Title filters on the platform, writable Title.
UserCustomerAddressLine1 varchar2 Adresse du client – Ligne 1 writable Address line 1 of the owning customer of the subscription and user account.
UserCustomerAddressLine2 varchar2 Adresse du client – Ligne 2 writable Address line 2 of the owning customer of the subscription and user account.
UserCustomerAddressLine3 varchar2 Adresse du client – Ligne 3 writable Address line 3 of the owning customer of the subscription and user account.
UserCustomerChamberOfCommerceNumber varchar2 Numéro CoC de l'utilisateur/client writable Chamber of Commerce number of the owning customer of the subscription and user account.
UserCustomerCity varchar2 Utilisateur Client Ville writable City of the owning customer of the subscription and user account.
UserCustomerCode varchar2 Code client de l'utilisateur writable ID of the owning customer of the subscription and user account.
UserCustomerCountry varchar2 Utilisateur Client Pays writable Country of the owning customer of the subscription and user account.
UserCustomerCurrencyCode varchar2 Code de devise du client utilisateur writable Currency code of the owning customer of the subscription and user account.
UserCustomerDescription varchar2 Description du client utilisateur writable ID of the owning customer of the subscription and user account.
UserCustomerEmail varchar2 Adresse e-mail de l'utilisateur/client writable Email of the owning customer of the subscription and user account.
UserCustomerId guid Identifiant client writable ID of the owning customer of the subscription and user account.
UserCustomerPhone varchar2 Utilisateur Client Téléphone writable Phone of the owning customer of the subscription and user account.
UserCustomerPostalCode varchar2 Code postal du client writable Postal code of the owning customer of the subscription and user account.
UserCustomerRsinNumber varchar2 Numéro RSIN de l'utilisateur/client writable RSIN number of the owning customer of the subscription and user account.
UserCustomerSiretNumber varchar2 Numéro SIRET du client writable SIRET number of the owning customer of the subscription and user account.
UserCustomerState varchar2 État de l'utilisateur/client writable State of the owning customer of the subscription and user account.
UserCustomerVatNumber varchar2 Numéro de TVA de l'utilisateur/client writable VAT number of the owning customer of the subscription and user account.
UserCustomerWebsite varchar2 Site web destiné aux utilisateurs et aux clients writable Website of the owning customer of the subscription and user account.
UserID guid ID utilisateur filters on the platform, writable Primary key.
UserName varchar2 Nom d'Utilisateur filters on the platform, writable Login name of the user.

Clés

Key Column Se réfère à Kind Description
Me_EmployeeID_Employees_fk EmployeeID Employees.ID Key

Exemples de 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

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :