Groups

Create, update, delete, and query the available Groups in Box.

テーブル固有の情報

すべてのGroup の取得、またはId でのフィルタが可能です。

SELECT * FROM Groups

If you're authenticated as an administrator with user impersonation permissions, you can query groups from multiple user accounts:

SELECT * FROM Groups WHERE AsUserId IN (SELECT Id FROM Users)

Note: User impersonation has the following limitations:

The authenticated user cannot be impersonated unless that user is a service account.
If the authenticated user is a standard user account, they can only query groups associated with their account.
Groups shared with multiple users are only returned for one of the users.

Group の作成は、Name カラムだけで可能です。

INSERT INTO Groups (Name, Provenance, MemberViewabilityLevel) VALUES ('new group', 'google', 'admins_only')

ReadOnly=False のカラムが更新可能です。

UPDATE Groups SET InvitabilityLevel = 'admins_and_members' WHERE Id = '111'

Groups は、Id を指定してDELETE ステートメントを発行することで削除できます。

DELETE FROM Groups WHERE Id = '111'


Name	Type	ReadOnly	Description
ID [KEY]	String	True	The Id of the group.
Name	String	False	The name of the group.
Provenance	String	False	Typically used to track the external source where the group is coming from.
ExternalSyncIdentifier	String	False	Typically used as a group identifier for groups coming from an external source.
Description	String	False	The description of the group.
InvitabilityLevel	String	False	Specifies who can invite this group to folders.
MemberViewabilityLevel	String	False	Specifies who can view the members of this group.
CreatedAt	Datetime	True	The date the group was created at, you need to specify an Id to recieve this column.
ModifiedAt	Datetime	True	The date the group was modified at, you need to specify an Id to recieve this column.
AsUserId	String	False	The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.