Power BI Connector for Box

Build 23.0.8839

Groups

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

テーブル固有の情報

Select

すべてのGroup の取得、またはId でのフィルタが可能です。

SELECT * FROM Groups

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

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

Insert

Group の作成は、Name カラムだけで可能です。

INSERT INTO Groups (Name, Provenance, MemberViewabilityLevel) VALUES ('new group', 'google', 'admins_only')

Update

ReadOnly=False のカラムが更新可能です。

UPDATE Groups SET InvitabilityLevel = 'admins_and_members' WHERE Id = '111'

Delete

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

DELETE FROM Groups WHERE Id = '111'

Columns

Name Type ReadOnly Description
ID [KEY] String True

The Id of the group.

Name String False

The name of the group.

Provenance String False

Typically used to track the external source where the group is coming from.

ExternalSyncIdentifier String False

Typically used as a group identifier for groups coming from an external source.

Description String False

The description of the group.

InvitabilityLevel String False

Specifies who can invite this group to folders.

MemberViewabilityLevel String False

Specifies who can view the members of this group.

CreatedAt Datetime True

The date the group was created at, you need to specify an Id to recieve this column.

ModifiedAt Datetime True

The date the group was modified at, you need to specify an Id to recieve this column.

AsUserId String False

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

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