invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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
AccountingDivision int32 Divisione della Contabilità filters on the platform, writable Accounting division number.
Application varchar2(240) Application writable Application being used.
CurrentDivision 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.
CustomerCode varchar2 Codice del Cliente filtri sulla piattaforma
DataContainerID varchar2 ID di contenitore di dati writable ID of the data container.
Division int32 ID dell'azienda writable Division number of the user.
DivisionCustomer guid Divisione Clienti filters on the platform, writable Owner account of the division.
DivisionCustomerCode varchar2(18) Codice cliente della divisione filters on the platform, writable Owner account code of the division.
DivisionCustomerName varchar2 Divisione Nome cliente filters on the platform, writable Owner account name of the division.
DivisionCustomerSiretNumber varchar2 Divisione - Numero SIRET del cliente filters on the platform, writable Owner account SIRET Number of the division for French legislation.
DivisionCustomerVatNumber varchar2(35) Partita IVA del cliente della divisione filters on the platform, writable Owner account VAT Number of the division.
DivisionLabel varchar2(128) Etichetta della divisione writable Label of the division.
DossierDivision int32 Divisione File filters on the platform, writable Dossier division number (optional).
Email varchar2(128) Email filters on the platform, writable Indirizzo e-mail dell'utente.
EmployeeID guid ID dell'impiegato filters on the platform, writable Employee ID.
EnvironmentApiBaseUrl varchar2(60) URL di base dell'API di Exact Online Environment writable API base URL of the Exact Online environment.
EnvironmentTopLevelDomain varchar2(30) Dominio di primo livello "Exact Online Environment" writable Top-level domain of the Exact Online environment.
FirstName varchar2(64) Nome filters on the platform, writable First name.
FullName varchar2(240) Nome completo per l'uso nelle liste 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 È un abbonamento ai servizi di contabilità? writable Whether the user is connected using an accountancy subscription.
IsClientUser 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).
IsEmployeeSelfServiceUser char itgen_eol_isemployeeselfserviceuser filtri sulla piattaforma
IsEntrepreneurSubscription char Abbonamento a Entrepreneur writable Whether the user is connected using an entrepreneur subscription.
IsMyFirmLiteUser char Sono un utente di My Firm Lite? filtri sulla piattaforma
IsMyFirmPortalUser 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).
IsOEIMigrationMandatory char itgen_eol_isoeimigrationmandatory filtri sulla piattaforma
IsStarterUser char È un utente principiante filtri sulla piattaforma
Language varchar2(30) Language filters on the platform, writable Language spoken by this user.
LanguageCode varchar2(30) Codice della lingua filters on the platform, writable Language (culture) that is used in Exact Online.
LastName varchar2(60) Cognome filters on the platform, writable Last name.
Legislation int64 Legislation filters on the platform, writable Legislation.
MiddleName varchar2 Secondo nome 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 filtri sulla piattaforma
Phone varchar2(25) Phone filters on the platform, writable Phone number.
PhoneExtension varchar2(15) Estensione del telefono filters on the platform, writable Phone number extension.
PictureUrl varchar2 Immagine (URL) filters on the platform, writable Url that can be used to retrieve the picture of the user.
ServerTime varchar2 Ora del server filters on the platform, writable The current date and time in Exact Online.
ServerUtcOffset double Differenza rispetto all'UTC del server filters on the platform, writable The time difference with UTC in seconds.
ThumbnailPicture blob Immagine in miniatura filters on the platform, writable Binary thumbnail picture of this user.
ThumbnailPictureFormat 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.
UserCustomerAddressLine1 varchar2 Indirizzo del cliente - Riga 1 writable Address line 1 of the owning customer of the subscription and user account.
UserCustomerAddressLine2 varchar2 Indirizzo del cliente - Riga 2 writable Address line 2 of the owning customer of the subscription and user account.
UserCustomerAddressLine3 varchar2 Indirizzo del cliente - Riga 3 writable Address line 3 of the owning customer of the subscription and user account.
UserCustomerChamberOfCommerceNumber varchar2 Numero del codice fiscale del cliente utente writable Chamber of Commerce number of the owning customer of the subscription and user account.
UserCustomerCity varchar2 Città del cliente utente writable City of the owning customer of the subscription and user account.
UserCustomerCode varchar2 Codice cliente utente writable ID of the owning customer of the subscription and user account.
UserCustomerCountry varchar2 Utente Cliente Paese writable Country of the owning customer of the subscription and user account.
UserCustomerCurrencyCode varchar2 Utente Cliente Codice Valuta writable Currency code of the owning customer of the subscription and user account.
UserCustomerDescription varchar2 Descrizione dell'utente/cliente writable ID of the owning customer of the subscription and user account.
UserCustomerEmail varchar2 E-mail del cliente utente writable Email of the owning customer of the subscription and user account.
UserCustomerId guid ID cliente utente writable ID of the owning customer of the subscription and user account.
UserCustomerPhone varchar2 Telefono del cliente utente writable Phone of the owning customer of the subscription and user account.
UserCustomerPostalCode varchar2 Codice postale del cliente writable Postal code of the owning customer of the subscription and user account.
UserCustomerRsinNumber varchar2 Numero RSIN del cliente writable RSIN number of the owning customer of the subscription and user account.
UserCustomerSiretNumber varchar2 Numero SIRET del cliente writable SIRET number of the owning customer of the subscription and user account.
UserCustomerState varchar2 Stato dell'utente/cliente writable State of the owning customer of the subscription and user account.
UserCustomerVatNumber varchar2 Partita IVA del cliente writable VAT number of the owning customer of the subscription and user account.
UserCustomerWebsite 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.
UserName varchar2 Nome Utente filters on the platform, writable Login name of the user.

Chiavi

Key Column Si riferisce a Kind Description
Me_EmployeeID_Employees_fk EmployeeID 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: