Power BI Connector for Box

Build 23.0.8839

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'

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.

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.

AsUserId String False

The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839