JDBC Driver for Box

Build 22.0.8462

UserEvents

Query the available Events in Box.

Table Specific Information

User events are logs that are saved after a change in a user's account.

Select

Query all the current user's events:

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.
AsUserId String The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

The allowed values are all, changes, sync, admin_logs.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462