Collaborations

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

テーブル固有の情報

Collaborations はFolders およびGroups の間のコネクションであり、一つのGroup は特定のCollaboration とコラボレートできます。

Collaborations テーブルをクエリするには、Id、FolderId、もしくはGroupId を指定します。

SELECT * FROM Collaborations WHERE Id = '123'

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

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

Collaborations に挿入するには、Folder にGroup もしくはUser を紐付けてRole を割り当てます。

INSERT INTO Collaborations (Role, ItemId, ItemType, AccessibleById, AccessibleByType) VALUES ('admin', '1', 'folder', '2', 'user')

Collaboration では、Role およびStatus だけが更新可能です。

UPDATE Collaborations SET Role = 'viewer', Status = 'accepted' WHERE Id = '100'

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

DELETE FROM Collaborations WHERE Id = '100'


Name	Type	ReadOnly	Description
Id [KEY]	String	True	The Id of the collaboration.
CreatedAt	Datetime	True	The date the collaboration was created at.
ModifiedAt	Datetime	True	The date the collaboration was modified at.
AcknowledgedAt	Datetime	True	The date the collaboration was acknowledged.
CreatedById	String	True	The Id of the user that created the collaboration.
Status	String	False	The status of the collaboration.
Role	String	False	The role of the user or group of the collaborator. Allowed values are editor, viewer, previewer, uploader, previewer uploader, viewer uploader, co-owner, or owner
ItemId	String	False	The Id of the item the collaboration is related to.
ItemType	String	False	The type of the item the collaboration is related to.
AccessibleById	String	False	The Id of the group/user that can access this collaboration.
AccessibleByType	String	False	The type of the entity of Accessible_By_Id. 使用できる値は次のとおりです。group, user
AccessibleByLogin	String	False	The login of the the Accessible_By_Id.
AsUserId	String	False	The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
FolderId	String	The Id of the folder the collaboration is related to.
GroupId	String	The Id of the group the collaboration is related to.