invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Me: Exact Online Me

insert update delete REST

  • Catálogo: ExactOnlineREST
  • Esquema: System
  • Llaves Primarias: UserID
  • Label: Me

Permite recuperar y modificar datos utilizando insert, update y delete.

Fuente de la API

  • Punto final: /api/v1/current/Me
  • Metadatos: /api/v1/current/$metadata

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 5
Número de filas escaneadas por minuto 7,200
Número de filas de queries puntuales por minuto 300
Escribir filas por minuto 300

El resultado se puede almacenar en la Caché del cliente.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla Me. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
AccountingDivision int32 División de Contabilidad filters on the platform, writable Accounting division number.
Application varchar2(240) Application writable Application being used.
CurrentDivision int32 División Actual 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 Código de Cliente filtros de la plataforma
DataContainerID varchar2 ID del Contenedor de Datos writable ID of the data container.
Division int32 ID de la Empresa writable Division number of the user.
DivisionCustomer guid Cliente de la división filters on the platform, writable Owner account of the division.
DivisionCustomerCode varchar2(18) Código de cliente de la división filters on the platform, writable Owner account code of the division.
DivisionCustomerName varchar2 Nombre del cliente de la división filters on the platform, writable Owner account name of the division.
DivisionCustomerSiretNumber varchar2 Número SIRET del cliente de la división filters on the platform, writable Owner account SIRET Number of the division for French legislation.
DivisionCustomerVatNumber varchar2(35) Número de IVA de la división filters on the platform, writable Owner account VAT Number of the division.
DivisionLabel varchar2(128) Etiqueta de división writable Label of the division.
DossierDivision int32 División de archivos filters on the platform, writable Dossier division number (optional).
Email varchar2(128) Email filters on the platform, writable Dirección de correo electrónico del usuario.
EmployeeID guid Identificación del Empleado filters on the platform, writable Employee ID.
EnvironmentApiBaseUrl varchar2(60) URL base de la API de Exact Online Environment writable API base URL of the Exact Online environment.
EnvironmentTopLevelDomain varchar2(30) Dominio de primer nivel «Exact Online Environment» writable Top-level domain of the Exact Online environment.
FirstName varchar2(64) Primer Nombre filters on the platform, writable First name.
FullName varchar2(240) Nombre Completo 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 ¿Es una suscripción a un servicio de contabilidad? writable Whether the user is connected using an accountancy subscription.
IsClientUser char ¿Es un usuario 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 filtros de la plataforma
IsEntrepreneurSubscription char ¿Qué es la suscripción a Entrepreneur? writable Whether the user is connected using an entrepreneur subscription.
IsMyFirmLiteUser char ¿Soy usuario de la versión Lite de My Firm? filtros de la plataforma
IsMyFirmPortalUser char ¿Soy usuario del portal de mi empresa? filters on the platform, writable MyFirm user of accountant with limited access and specific start page (internal use).
IsOEIMigrationMandatory char itgen_eol_isoeimigrationmandatory filtros de la plataforma
IsStarterUser char Es un usuario principiante filtros de la plataforma
Language varchar2(30) Language filters on the platform, writable Language spoken by this user.
LanguageCode varchar2(30) Código del idioma filters on the platform, writable Language (culture) that is used in Exact Online.
LastName varchar2(60) Apellido filters on the platform, writable Last name.
Legislation int64 Legislation filters on the platform, writable Legislation.
MiddleName varchar2 Segundo Nombre 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 filtros de la plataforma
Phone varchar2(25) Phone filters on the platform, writable Phone number.
PhoneExtension varchar2(15) Extensión Telefónica filters on the platform, writable Phone number extension.
PictureUrl varchar2 Imagen (URL) filters on the platform, writable Url that can be used to retrieve the picture of the user.
ServerTime varchar2 Hora del Servidor filters on the platform, writable The current date and time in Exact Online.
ServerUtcOffset double Desplazamiento UTC del Servidor filters on the platform, writable The time difference with UTC in seconds.
ThumbnailPicture blob Miniatura de Imagen filters on the platform, writable Binary thumbnail picture of this user.
ThumbnailPictureFormat varchar2 Formato de Miniatura de Imagen filters on the platform, writable File type of the picture.
Title varchar2 Title filters on the platform, writable Title.
UserCustomerAddressLine1 varchar2 Dirección del cliente: línea 1 writable Address line 1 of the owning customer of the subscription and user account.
UserCustomerAddressLine2 varchar2 Dirección del cliente: línea 2 writable Address line 2 of the owning customer of the subscription and user account.
UserCustomerAddressLine3 varchar2 Dirección del cliente: línea 3 writable Address line 3 of the owning customer of the subscription and user account.
UserCustomerChamberOfCommerceNumber varchar2 Número de CoC del cliente writable Chamber of Commerce number of the owning customer of the subscription and user account.
UserCustomerCity varchar2 Usuario Cliente Ciudad writable City of the owning customer of the subscription and user account.
UserCustomerCode varchar2 Código de cliente del usuario writable ID of the owning customer of the subscription and user account.
UserCustomerCountry varchar2 Usuario Cliente País writable Country of the owning customer of the subscription and user account.
UserCustomerCurrencyCode varchar2 Código de moneda del cliente writable Currency code of the owning customer of the subscription and user account.
UserCustomerDescription varchar2 Descripción del usuario/cliente writable ID of the owning customer of the subscription and user account.
UserCustomerEmail varchar2 Correo electrónico del usuario/cliente writable Email of the owning customer of the subscription and user account.
UserCustomerId guid ID de cliente del usuario writable ID of the owning customer of the subscription and user account.
UserCustomerPhone varchar2 Usuario Cliente Teléfono writable Phone of the owning customer of the subscription and user account.
UserCustomerPostalCode varchar2 Código postal del cliente writable Postal code of the owning customer of the subscription and user account.
UserCustomerRsinNumber varchar2 Número RSIN del cliente writable RSIN number of the owning customer of the subscription and user account.
UserCustomerSiretNumber varchar2 Número SIRET del cliente writable SIRET number of the owning customer of the subscription and user account.
UserCustomerState varchar2 Estado del usuario/cliente writable State of the owning customer of the subscription and user account.
UserCustomerVatNumber varchar2 Número de IVA del cliente writable VAT number of the owning customer of the subscription and user account.
UserCustomerWebsite varchar2 Usuario Cliente Página web writable Website of the owning customer of the subscription and user account.
UserID guid Identificación de Usuario filters on the platform, writable Primary key.
UserName varchar2 Nombre de Usuario filters on the platform, writable Login name of the user.

Teclas

Key Column Se refiere a Kind Description
Me_EmployeeID_Employees_fk EmployeeID Employees.ID Key

Ejemplos 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

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: