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 |
|---|---|---|---|---|---|
Accounting |
int32 |
División de Contabilidad | filters on the platform, writable | Accounting division number. | |
Application |
varchar2 |
Application | writable | Application being used. | |
Current |
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. | |
Customer |
varchar2 |
Código de Cliente | filtros de la plataforma | ||
Data |
varchar2 |
ID del Contenedor de Datos | writable | ID of the data container. | |
Division |
int32 |
ID de la Empresa | writable | Division number of the user. | |
Division |
guid |
Cliente de la división | filters on the platform, writable | Owner account of the division. | |
Division |
varchar2 |
Código de cliente de la división | filters on the platform, writable | Owner account code of the division. | |
Division |
varchar2 |
Nombre del cliente de la división | filters on the platform, writable | Owner account name of the division. | |
Division |
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. | |
Division |
varchar2 |
Número de IVA de la división | filters on the platform, writable | Owner account VAT Number of the division. | |
Division |
varchar2 |
Etiqueta de división | writable | Label of the division. | |
Dossier |
int32 |
División de archivos | filters on the platform, writable | Dossier division number (optional). | |
Email |
varchar2 |
filters on the platform, writable | Dirección de correo electrónico del usuario. | ||
Employee |
guid |
Identificación del Empleado | filters on the platform, writable | Employee ID. | |
Environment |
varchar2 |
URL base de la API de Exact Online Environment | writable | API base URL of the Exact Online environment. | |
Environment |
varchar2 |
Dominio de primer nivel «Exact Online Environment» | writable | Top-level domain of the Exact Online environment. | |
First |
varchar2 |
Primer Nombre | filters on the platform, writable | First name. | |
Full |
varchar2 |
Nombre Completo | 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 |
¿Es una suscripción a un servicio de contabilidad? | writable | Whether the user is connected using an accountancy subscription. | |
Is |
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). | |
Is |
char |
itgen_eol_isemployeeselfserviceuser | filtros de la plataforma | ||
Is |
char |
¿Qué es la suscripción a Entrepreneur? | writable | Whether the user is connected using an entrepreneur subscription. | |
Is |
char |
¿Soy usuario de la versión Lite de My Firm? | filtros de la plataforma | ||
Is |
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). | |
Is |
char |
itgen_eol_isoeimigrationmandatory | filtros de la plataforma | ||
Is |
char |
Es un usuario principiante | filtros de la plataforma | ||
Language |
varchar2 |
Language | filters on the platform, writable | Language spoken by this user. | |
Language |
varchar2 |
Código del idioma | filters on the platform, writable | Language (culture) that is used in Exact Online. | |
Last |
varchar2 |
Apellido | filters on the platform, writable | Last name. | |
Legislation |
int64 |
Legislation | filters on the platform, writable | Legislation. | |
Middle |
varchar2 |
Segundo Nombre | 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 | filtros de la plataforma | ||
Phone |
varchar2 |
Phone | filters on the platform, writable | Phone number. | |
Phone |
varchar2 |
Extensión Telefónica | filters on the platform, writable | Phone number extension. | |
Picture |
varchar2 |
Imagen (URL) | filters on the platform, writable | Url that can be used to retrieve the picture of the user. | |
Server |
varchar2 |
Hora del Servidor | filters on the platform, writable | The current date and time in Exact Online. | |
Server |
double |
Desplazamiento UTC del Servidor | filters on the platform, writable | The time difference with UTC in seconds. | |
Thumbnail |
blob |
Miniatura de Imagen | filters on the platform, writable | Binary thumbnail picture of this user. | |
Thumbnail |
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. | |
User |
varchar2 |
Dirección del cliente: línea 1 | writable | Address line 1 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Dirección del cliente: línea 2 | writable | Address line 2 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Dirección del cliente: línea 3 | writable | Address line 3 of the owning customer of the subscription and user account. | |
User |
varchar2 |
Número de CoC del cliente | writable | Chamber of Commerce number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Usuario Cliente Ciudad | writable | City of the owning customer of the subscription and user account. | |
User |
varchar2 |
Código de cliente del usuario | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Usuario Cliente País | writable | Country of the owning customer of the subscription and user account. | |
User |
varchar2 |
Código de moneda del cliente | writable | Currency code of the owning customer of the subscription and user account. | |
User |
varchar2 |
Descripción del usuario/cliente | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Correo electrónico del usuario/cliente | writable | Email of the owning customer of the subscription and user account. | |
User |
guid |
ID de cliente del usuario | writable | ID of the owning customer of the subscription and user account. | |
User |
varchar2 |
Usuario Cliente Teléfono | writable | Phone of the owning customer of the subscription and user account. | |
User |
varchar2 |
Código postal del cliente | writable | Postal code of the owning customer of the subscription and user account. | |
User |
varchar2 |
Número RSIN del cliente | writable | RSIN number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Número SIRET del cliente | writable | SIRET number of the owning customer of the subscription and user account. | |
User |
varchar2 |
Estado del usuario/cliente | writable | State of the owning customer of the subscription and user account. | |
User |
varchar2 |
Número de IVA del cliente | writable | VAT number of the owning customer of the subscription and user account. | |
User |
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. | |
User |
varchar2 |
Nombre de Usuario | filters on the platform, writable | Login name of the user. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Me_ |
Employee |
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: