Memberships

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

テーブル固有の情報

Membership はUser とGroup のリレーションです。

Memberships テーブルからのSelect には、Id、GroupId、またはUserId を指定してください。

SELECT * FROM Memberships WHERE Id = '123'

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

SELECT * FROM Memberships 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 memberships associated with their account.
Memberships shared with multiple users are only returned for one of the users.

Memberships に挿入するには、Group（GroupId）とUser（UserId）を紐付けます。

INSERT INTO Memberships (GroupId, UserId) VALUES (1001, 123)

Member のロールだけが更新可能です。デフォルトのロールは'Member' で、'admin' のオプションが可能です。

UPDATE Memberships SET Role = 'admin' WHERE Id = '100'

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

DELETE FROM Memberships  WHERE Id = '100'


Name	Type	ReadOnly	Description
Id [KEY]	String	True	The Id of the membership.
Role	String	False	The role of the user that is in this membership.
CreatedAt	Datetime	True	The date the membership was created at, you need to specify an Id to recieve this column.
ModifiedAt	Datetime	True	The date the membership was modified at, you need to specify an Id to recieve this column.
UserName	String	True	The name of the user of the membership.
UserLogin	String	True	The login of the user of the membership.
UserId	String	False	The id of the user of the membership.
GroupName	String	False	The group name of the membership.
GroupId	String	False	The group of the membership.
AsUserId	String	False	The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.