invantive documentation
Invantive Support ForumsLog In / Sign Up

UsersByDivision: Exact Online Users by Division

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: Users
  • Label: Users by Division

The data in this table is partitioned per value of the Division column.

Can only retrieve data.

API Source

  • Endpoint: /api/v1/{division}/Users/Users
  • Metadata: /api/v1/{division}/Users/$metadata

Performance Characteristics

Characteristic Value
Average access latency (ms) 5
Full scan rows per minute 7,200
Point query rows per minute 300
Write rows per minute 300

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
division int32 ID of the division to retrieve data for.

Table Columns

The columns of the table UsersByDivision are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
Account guid Account writable
BirthDate datetime Birth Date writable Birth date.
BirthName varchar2 Birth Name writable Birth name.
Created datetime Created writable Creation date.
Creator guid Creator writable User ID of the creator.
CreatorFullName varchar2(240) Creator Full Name writable Name of the creator.
Customer guid Customer writable Customer the user belongs to.
CustomerName varchar2 Customer Name writable Name of Customer.
Email varchar2(128) Email writable Email address of the user.
EndDate datetime End Date writable Date after which the user login is disabled. NULL means no enddate.
FirstName varchar2(64) First Name writable First name.
FullName varchar2(240) Full Name writable Full name of the user.
Gender varchar2(1) Gender writable Gender: M=Male, V=Female, O=Unknown.
HasRegisteredForTwoStepVerification char Has Registered for 2 Step Verification writable User has completed registration of Two-Step verification.
HasTwoStepVerification char Has 2 Step Verification writable User must use Two-Step verification to log in.
Initials varchar2(10) Initials writable Initials.
Language varchar2(30) Language writable Language (culture) that is used in Exact Online.
LastLogin datetime Last Login writable The last time this user logged in.
LastName varchar2(50) Last Name writable Last name.
MiddleName varchar2 Middle Name writable Middle name.
Mobile varchar2(25) Mobile writable Mobile phone.
Modified datetime Modified writable Last modified date.
Modifier guid Modifier writable User ID of the last modifier.
ModifierFullName varchar2(240) Modified Full Name writable Name of the last modifier.
Nationality varchar2 Nationality writable Nationality.
Notes varchar2 Notes writable Remarks.
Phone varchar2(25) Phone writable Phone number.
PhoneExtension varchar2(15) Phone Extension writable Phone number extension.
ProfileCode varchar2 Profile Code writable Profile code.
StartDate datetime Start Date writable Startdate after which the login is allowed. If the start date is NULL the login is allowed as well.
StartDivision int32 Start Division writable Start Division.
Title varchar2 Title writable Title.
UserID guid User ID writable Primary key.
UserName varchar2 User Name writable Login name of the user.
UserTypesList varchar2 User Types List writable Obsolete.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: