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 |
|---|---|---|---|---|---|
Accounting |
int32 |
Service comptable | filters on the platform, writable | Accounting division number. | |
Application |
varchar2 |
Application | writable | Application being used. | |
Current |
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. | |
Customer |
varchar2 |
Code client | filtres disponibles sur la plateforme | ||
Data |
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. | |
Division |
guid |
Division Clients | filters on the platform, writable | Owner account of the division. | |
Division |
varchar2 |
Code client de la division | filters on the platform, writable | Owner account code of the division. | |
Division |
varchar2 |
Division Nom du client | filters on the platform, writable | Owner account name of the division. | |
Division |
varchar2 |
Division - Numéro SIRET du client | filters on the platform, writable | Owner account SIRET Number of the division for French legislation. | |
Division |
varchar2 |
Numéro de TVA client de la division | filters on the platform, writable | Owner account VAT Number of the division. | |
Division |
varchar2 |
Étiquette de division | writable | Label of the division. | |
Dossier |
int32 |
Division des fichiers | filters on the platform, writable | Dossier division number (optional). | |
Email |
varchar2 |
filters on the platform, writable | Adresse e-mail de l'utilisateur. | ||
Employee |
guid |
ID d'employé | filters on the platform, writable | Employee ID. | |
Environment |
varchar2 |
URL de base de l'API Exact Online Environment | writable | API base URL of the Exact Online environment. | |
Environment |
varchar2 |
Domaine de premier niveau « Exact Online Environment » | writable | Top-level domain of the Exact Online environment. | |
First |
varchar2 |
Prénom | filters on the platform, writable | First name. | |
Full |
varchar2 |
Nom complet pour utilisation dans les listes | 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 |
Abonnement à « Accountancy » | writable | Whether the user is connected using an accountancy subscription. | |
Is |
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). | |
Is |
char |
itgen_eol_isemployeeselfserviceuser | filtres disponibles sur la plateforme | ||
Is |
char |
Abonnement à Entrepreneur | writable | Whether the user is connected using an entrepreneur subscription. | |
Is |
char |
Suis-je un utilisateur de la version Lite de My Firm ? | filtres disponibles sur la plateforme | ||
Is |
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). | |
Is |
char |
itgen_eol_isoeimigrationmandatory | filtres disponibles sur la plateforme | ||
Is |
char |
Est-il un utilisateur débutant ? | filtres disponibles sur la plateforme | ||
Language |
varchar2 |
Language | filters on the platform, writable | Language spoken by this user. | |
Language |
varchar2 |
Code de langue | filters on the platform, writable | Language (culture) that is used in Exact Online. | |
Last |
varchar2 |
Nom | filters on the platform, writable | Last name. | |
Legislation |
int64 |
Legislation | filters on the platform, writable | Legislation. | |
Middle |
varchar2 |
Deuxième prénom | 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 | filtres disponibles sur la plateforme | ||
Phone |
varchar2 |
Phone | filters on the platform, writable | Phone number. | |
Phone |
varchar2 |
Poste téléphonique | filters on the platform, writable | Phone number extension. | |
Picture |
varchar2 |
Image (URL) | filters on the platform, writable | Url that can be used to retrieve the picture of the user. | |
Server |
varchar2 |
Temps de serveur | filters on the platform, writable | The current date and time in Exact Online. | |
Server |
double |
Décalage horaire UTC du serveur | filters on the platform, writable | The time difference with UTC in seconds. | |
Thumbnail |
blob |
Vignette | filters on the platform, writable | Binary thumbnail picture of this user. | |
Thumbnail |
varchar2 |
Format des vignettes | filters on the platform, writable | File type of the picture. | |
Title |
varchar2 |
Title | filters on the platform, writable | Title. | |
User |
varchar2 |
Adresse du client – Ligne 1 | writable | Address line 1 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Adresse du client – Ligne 2 | writable | Address line 2 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Adresse du client – Ligne 3 | writable | Address line 3 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Numéro CoC de l'utilisateur/client | writable | Chamber of Commerce number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Utilisateur Client Ville | writable | City of the owning customer of the subscription and user account. | |
User |
varchar2 |
Code client de l'utilisateur | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Utilisateur Client Pays | writable | Country of the owning customer of the subscription and user account. | |
User |
varchar2 |
Code de devise du client utilisateur | writable | Currency code of the owning customer of the subscription and user account. | |
User |
varchar2 |
Description du client utilisateur | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Adresse e-mail de l'utilisateur/client | writable | Email of the owning customer of the subscription and user account. | |
User |
guid |
Identifiant client | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Utilisateur Client Téléphone | writable | Phone of the owning customer of the subscription and user account. | |
User |
varchar2 |
Code postal du client | writable | Postal code of the owning customer of the subscription and user account. | |
User |
varchar2 |
Numéro RSIN de l'utilisateur/client | writable | RSIN number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Numéro SIRET du client | writable | SIRET number of the owning customer of the subscription and user account. | |
User |
varchar2 |
État de l'utilisateur/client | writable | State of the owning customer of the subscription and user account. | |
User |
varchar2 |
Numéro de TVA de l'utilisateur/client | writable | VAT number of the owning customer of the subscription and user account. | |
User |
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. | |
User |
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_ |
Employee |
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 :