Users
Create, update, delete, and query the available Users in Box.
テーブル固有の情報
Select
カレントユーザー、Id で指定されたエンタープライズ内の一人のユーザー、もしくはエンタープライズ内のすべてのユーザーを取得することができます。
SELECT * FROM Users
エンタープライズ内のユーザーの情報を取得することもできます。
SELECT * FROM Users WHERE Id = '1'
Insert
エンタープライズにユーザーを招待することができます。次のクエリは、エンタープライズへの参加の招待メールを送信します。
INSERT INTO Users(Login, Name, Role) VALUES('[email protected]', 'Username', 'coadmin')
Update
ReadOnly=False のカラムが更新可能です。
UPDATE Users SET Name = 'Test', Role = 'user', IsExemptFromDeviceLimits = false WHERE Id = '111'
Delete
Users は、Id を指定してDELETE ステートメントを発行することで削除できます。
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AsUserId | String |
The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts. |