Me: Exact Online Me
insert update delete REST
- Catalogo:
ExactOnlineREST - Schema:
System - Chiavi primarie:
UserID - Label: Me
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Codice sorgente dell'API
- Punto finale:
/api/v1/current/Me - Metadati:
/api/v1/current/$metadata
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 5 |
| Righe di scansione completa al minuto | 7,200 |
| Numero di righe di Query al minuto | 300 |
| Scrittura di righe al minuto | 300 |
Il risultato può essere memorizzato nella memoria cache sul client.
Colonne della tabella
Di seguito sono riportate le colonne della tabella Me. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Accounting |
int32 |
Divisione della Contabilità | filters on the platform, writable | Accounting division number. | |
Application |
varchar2 |
Application | writable | Application being used. | |
Current |
int32 |
Divisione attuale | 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 |
Codice del Cliente | filtri sulla piattaforma | ||
Data |
varchar2 |
ID di contenitore di dati | writable | ID of the data container. | |
Division |
int32 |
ID dell'azienda | writable | Division number of the user. | |
Division |
guid |
Divisione Clienti | filters on the platform, writable | Owner account of the division. | |
Division |
varchar2 |
Codice cliente della divisione | filters on the platform, writable | Owner account code of the division. | |
Division |
varchar2 |
Divisione Nome cliente | filters on the platform, writable | Owner account name of the division. | |
Division |
varchar2 |
Divisione - Numero SIRET del cliente | filters on the platform, writable | Owner account SIRET Number of the division for French legislation. | |
Division |
varchar2 |
Partita IVA del cliente della divisione | filters on the platform, writable | Owner account VAT Number of the division. | |
Division |
varchar2 |
Etichetta della divisione | writable | Label of the division. | |
Dossier |
int32 |
Divisione File | filters on the platform, writable | Dossier division number (optional). | |
Email |
varchar2 |
filters on the platform, writable | Indirizzo e-mail dell'utente. | ||
Employee |
guid |
ID dell'impiegato | filters on the platform, writable | Employee ID. | |
Environment |
varchar2 |
URL di base dell'API di Exact Online Environment | writable | API base URL of the Exact Online environment. | |
Environment |
varchar2 |
Dominio di primo livello "Exact Online Environment" | writable | Top-level domain of the Exact Online environment. | |
First |
varchar2 |
Nome | filters on the platform, writable | First name. | |
Full |
varchar2 |
Nome completo per l'uso nelle liste | 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 |
È un abbonamento ai servizi di contabilità? | writable | Whether the user is connected using an accountancy subscription. | |
Is |
char |
È un utente cliente? | 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 | filtri sulla piattaforma | ||
Is |
char |
Abbonamento a Entrepreneur | writable | Whether the user is connected using an entrepreneur subscription. | |
Is |
char |
Sono un utente di My Firm Lite? | filtri sulla piattaforma | ||
Is |
char |
Sono un utente del portale della mia azienda? | filters on the platform, writable | MyFirm user of accountant with limited access and specific start page (internal use). | |
Is |
char |
itgen_eol_isoeimigrationmandatory | filtri sulla piattaforma | ||
Is |
char |
È un utente principiante | filtri sulla piattaforma | ||
Language |
varchar2 |
Language | filters on the platform, writable | Language spoken by this user. | |
Language |
varchar2 |
Codice della lingua | filters on the platform, writable | Language (culture) that is used in Exact Online. | |
Last |
varchar2 |
Cognome | filters on the platform, writable | Last name. | |
Legislation |
int64 |
Legislation | filters on the platform, writable | Legislation. | |
Middle |
varchar2 |
Secondo nome | 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 | filtri sulla piattaforma | ||
Phone |
varchar2 |
Phone | filters on the platform, writable | Phone number. | |
Phone |
varchar2 |
Estensione del telefono | filters on the platform, writable | Phone number extension. | |
Picture |
varchar2 |
Immagine (URL) | filters on the platform, writable | Url that can be used to retrieve the picture of the user. | |
Server |
varchar2 |
Ora del server | filters on the platform, writable | The current date and time in Exact Online. | |
Server |
double |
Differenza rispetto all'UTC del server | filters on the platform, writable | The time difference with UTC in seconds. | |
Thumbnail |
blob |
Immagine in miniatura | filters on the platform, writable | Binary thumbnail picture of this user. | |
Thumbnail |
varchar2 |
Formato dell'immagine in miniatura | filters on the platform, writable | File type of the picture. | |
Title |
varchar2 |
Title | filters on the platform, writable | Title. | |
User |
varchar2 |
Indirizzo del cliente - Riga 1 | writable | Address line 1 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Indirizzo del cliente - Riga 2 | writable | Address line 2 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Indirizzo del cliente - Riga 3 | writable | Address line 3 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Numero del codice fiscale del cliente utente | writable | Chamber of Commerce number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Città del cliente utente | writable | City of the owning customer of the subscription and user account. | |
User |
varchar2 |
Codice cliente utente | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Utente Cliente Paese | writable | Country of the owning customer of the subscription and user account. | |
User |
varchar2 |
Utente Cliente Codice Valuta | writable | Currency code of the owning customer of the subscription and user account. | |
User |
varchar2 |
Descrizione dell'utente/cliente | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
E-mail del cliente utente | writable | Email of the owning customer of the subscription and user account. | |
User |
guid |
ID cliente utente | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Telefono del cliente utente | writable | Phone of the owning customer of the subscription and user account. | |
User |
varchar2 |
Codice postale del cliente | writable | Postal code of the owning customer of the subscription and user account. | |
User |
varchar2 |
Numero RSIN del cliente | writable | RSIN number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Numero SIRET del cliente | writable | SIRET number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Stato dell'utente/cliente | writable | State of the owning customer of the subscription and user account. | |
User |
varchar2 |
Partita IVA del cliente | writable | VAT number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Sito web del cliente utente | writable | Website of the owning customer of the subscription and user account. | |
UserID |
guid |
ID Utente | filters on the platform, writable | Primary key. | |
User |
varchar2 |
Nome Utente | filters on the platform, writable | Login name of the user. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Me_ |
Employee |
Employees.ID |
Key |
Esempi di Query
--
-- 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
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: