Excel Add-In for Box

Build 23.0.8770

Groups

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

テーブル固有の情報

Select

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

SELECT * FROM Groups

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.

Pseudo-Columns

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

Name Type Description
AsUserId String

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.8770