Power BI Connector for Box

Build 21.0.8137

UserEvents

Query the available Events in Box.

テーブル固有の情報

User events はユーザーアカウントで変更後に保存されたログです。

Select

カレントユーザーのすべてのイベントをクエリします:

SELECT * FROM UserEvents

Columns

Name Type Description
Id [KEY] String The Id of the event.
SourceId String The Id of the source that triggered the event.
SourceType String The type of the source that triggered the event.
CreatedById String The Id of the user that created the event.
CreatedByName String The Name of the user that created the event.
CreatedByLogin String The Login of the user that created the event.
CreatedAt Datetime The date the event was created at. This can only be used when requesting the events with a StreamType of admin_logs
RecordedAt Datetime The date the event was recorded at.
SessionId String The Id of the session of the event.
EventType String The type of the event.
ClassificationName String The classification name of the event.

Pseudo-Columns

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

Name Type Description
StreamType String The type of events to stream.

使用できる値は次のとおりです。all, changes, sync, admin_logs

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