Collaborations
Create, update, delete, and query the available Collaborations in Box.
テーブル固有の情報
Collaborations はFolders およびGroups の間のコネクションであり、一つのGroup は特定のCollaboration とコラボレートできます。
Select
Collaborations テーブルをクエリするには、Id、FolderId、もしくはGroupId を指定します。
SELECT * FROM Collaborations WHERE Id = '123'
Insert
Collaborations に挿入するには、Folder にGroup もしくはUser を紐付けてRole を割り当てます。
INSERT INTO Collaborations(Role, ItemId, ItemType, AccessibleById, AccessibleByType) VALUES('admin', '1', 'folder', '2', 'user')
Update
Collaboration では、Role およびStatus だけが更新可能です。
UPDATE Collaborations SET Role = 'viewer', Status = 'accepted' WHERE Id = '100'
Delete
Collaborations は、Id を指定してDELETE ステートメントを発行することで削除できます。
DELETE FROM Collaborations WHERE Id = '100'
Columns
| 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. |
Pseudo-Columns
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. |
| AsUserId | String |
The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts. |