Power BI Connector for Box

Build 21.0.8137

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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137