Users
Create, update, delete, and query the available Users in Box.
Table Specific Information
Select
You can retrieve information about the current User, a User in your enterprise specified by Id, or all the Users in the enterprise.
SELECT * FROM Users
You can also retrieve the information of any User who is in your enterprise:
SELECT * FROM Users WHERE Id = '1'
Insert
You can invite a User to your enterprise. The following query will send an invitation email to join your enterprise.
INSERT INTO Users(Login, Name, Role) VALUES('[email protected]', 'Username', 'coadmin')
Update
Any column where ReadOnly=False can be updated.
UPDATE Users SET Name = 'Test', Role = 'user', IsExemptFromDeviceLimits = false WHERE Id = '111'
Delete
Users can be deleted by providing an Id and issuing a DELETE statement.
DELETE FROM Users WHERE Id = '111'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
The Id of the user. When selecting you can set this to the value me to retrieve information for the logged-user. |
| Login | String | False |
The login of the user. |
| Name | String | False |
The name of the user. |
| EnterpriseId | String | False |
The id of the user's enterprise. Set this to null to disassociate the user from the enterprise. |
| Role | String | False |
The role of the user. |
| Language | String | False |
The preferred language of the user. |
| IsSyncEnabled | Boolean | False |
If the user is allowed to use Box Sync or not. |
| JobTitle | String | False |
The job title of the user. |
| Phone | String | False |
The phone of the user. |
| Address | String | False |
The address of the user. |
| SpaceAmount | Long | False |
The amount of space the user is allowed to use. |
| SpaceUsed | Long | False |
The amount of space the user has used. |
| MaxUploadSize | Long | False |
The maximum upload size the user is allowed to upload. |
| TrackingCodes | String | False |
The tracking codes of the user, separated by commas. |
| CanSeeManagedUsers | Boolean | False |
The date the content of the user was created at. |
| TimeZone | String | False |
The preferred timezone of the user. |
| IsExemptFromDeviceLimits | Boolean | False |
If the user is exempt from device limitations or not. |
| IsExemptFromLoginVerification | Boolean | False |
If the user is exempt from login verification or not. |
| Status | String | False |
The status of the user. |
| IsPasswordResetRequired | Boolean | False |
If the user should be asked to change his password on the next login or not. |
| CreatedAt | Datetime | True |
The date the user was created. |
| ModifiedAt | Datetime | True |
The date the user was modified. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AsUserId | String |
The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts. |