UsersByDivision: Exact Online Users by Division
read only per partition REST
- Catálogo:
ExactOnlineREST - Esquema:
Users - Label: Users by Division
Los datos de esta tabla están divididos por el valor de la columna Division.
Solo puede recuperar datos.
Fuente de la API
- Punto final:
/api/v1/{division}/Users/Users - Metadatos:
/api/v1/{division}/Users/$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.
Parámetros
| Name | Tipo de Datos | Required | Default | Documentation |
|---|---|---|---|---|
division |
int32 |
ID of the division to retrieve data for. |
Columnas de la Tabla
A continuación se muestran las columnas de la tabla UsersByDivision. 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 |
|---|---|---|---|---|---|
Account |
guid |
Account | writable | ||
Birth |
datetime |
Fecha de Nacimiento | writable | Birth date. | |
Birth |
varchar2 |
Nombre de Nacimiento | writable | Birth name. | |
Created |
datetime |
Created | writable | Creation date. | |
Creator |
guid |
Creator | writable | User ID of the creator. | |
Creator |
varchar2 |
Nombre Completo del Creador | writable | Name of the creator. | |
Customer |
guid |
Customer | writable | Customer the user belongs to. | |
Customer |
varchar2 |
Nombre del Cliente | writable | Name of Customer. | |
Email |
varchar2 |
writable | Dirección de correo electrónico del usuario. | ||
End |
datetime |
Fecha Final | writable | Date after which the user login is disabled.NULL means no enddate. | |
First |
varchar2 |
Primer Nombre | writable | First name. | |
Full |
varchar2 |
Nombre Completo | writable | Full name of the user. | |
Gender |
varchar2 |
Gender | writable | Gender: M=Male, V=Female, O=Unknown. | |
Has |
char |
Has Registered for 2 Step Verification | writable | User has completed registration of Two-Step verification. | |
Has |
char |
Has 2 Step Verification | writable | User must use Two-Step verification to log in. | |
Initials |
varchar2 |
Initials | writable | Initials. | |
Language |
varchar2 |
Language | writable | Language (culture) that is used in Exact Online. | |
Last |
datetime |
Último Acceso | writable | The last time this user logged in. | |
Last |
varchar2 |
Apellido | writable | Last name. | |
Middle |
varchar2 |
Segundo Nombre | writable | Middle name. | |
Mobile |
varchar2 |
Mobile | writable | Mobile phone. | |
Modified |
datetime |
Modified | writable | Last modified date. | |
Modifier |
guid |
Modifier | writable | User ID of the last modifier. | |
Modifier |
varchar2 |
Nombre completo modificado | writable | Name of the last modifier. | |
Nationality |
varchar2 |
Nationality | writable | Nationality. | |
Notes |
varchar2 |
Notes | writable | Remarks. | |
Phone |
varchar2 |
Phone | writable | Phone number. | |
Phone |
varchar2 |
Extensión Telefónica | writable | Phone number extension. | |
Profile |
varchar2 |
Código del Perfil | writable | Profile code. | |
Start |
datetime |
Fecha Inicial | writable | Startdate after which the login is allowed.If the start date is NULL the login is allowed as well. | |
Start |
int32 |
Iniciar la División | writable | Start Division. | |
Title |
varchar2 |
Title | writable | Title. | |
UserID |
guid |
Identificación de Usuario | writable | Primary key. | |
User |
varchar2 |
Nombre de Usuario | writable | Login name of the user. | |
User |
varchar2 |
Lista de Tiposde Usuario | writable | Obsolete. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: