Create, update, delete, and query the available Users in Box.
Table Specific Information
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'
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@test.com', 'Username', 'coadmin')
Any column where ReadOnly=False can be updated.
UPDATE Users SET Name = 'Test', Role = 'user', IsExemptFromDeviceLimits = false WHERE Id = '111'
Users can be deleted by providing an Id and issuing a DELETE statement.
DELETE FROM Users WHERE Id = '111'
The Id of the user. When selecting you can set this to the value me to retrieve information for the logged-user.
The login of the user.
The name of the user.
The id of the user's enterprise. Set this to null to disassociate the user from the enterprise.
The role of the user.
The preferred language of the user.
If the user is allowed to use Box Sync or not.
The job title of the user.
The phone of the user.
The address of the user.
The amount of space the user is allowed to use.
The amount of space the user has used.
The maximum upload size the user is allowed to upload.
The tracking codes of the user, separated by commas.
The date the content of the user was created at.
The preferred timezone of the user.
If the user is exempt from device limitations or not.
If the user is exempt from login verification or not.
The status of the user.
If the user should be asked to change his password on the next login or not.
The date the user was created.
The date the user was modified.
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.
The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.