Excel Add-In for Dropbox

Build 24.0.9062

Events

Retrieves team events.

Table Specific Information

The following scopes are required to access this view: events.read

Select

The 本製品 uses the Dropbox API to process search criteria that refer to the StartTime or EndTime columns. The 本製品 processes other filters client-side within the 本製品. For example, the following queries are processed server side.

SELECT * FROM Events WHERE StartTime = '2020-04-05'

SELECT * FROM Events WHERE EndTime = '2020-04-05'

SELECT * FROM Events WHERE StartTime = '2020-04-05' AND EndTime = '2020-06-12'

Columns

Name Type Description
Timestamp Timestamp The Dropbox timestamp representing when the action was taken.
Category String The category that this type of action belongs to.
Type String The particular type of action taken.
Description String The description of the event type.
DetailsTag String The variable event schema applicable to this type of action, instantiated with respect to this particular action.
ErrorUserFriendlyMessage String The user-friendly error message.
IsEmmManaged Boolean Indicator whether the EMM is managed or not.
LoginMethod String The login method.
AppInfoTag String Info about the app.
AppInfoAppId String The ID of the app.
AppInfoDisplayName String The display name of the app.
IsGroupOwner Boolean Indicator whether the user is group owner.
IsCompanyManaged Boolean Indicator whether the company is managed.
ActorTag String The entity who actually performed the action. Might be missing due to historical data gap.
ActorAdminTag String The adming tag.
ActorAdminAccountId String Account ID of the admin.
ActorAdminDisplayName String Display name of the admin.
ActorAdminEmail String Email of the admin.
ActorAdminTeamMemberId String Team member ID of the admin.
ActorAppTag String The tag of the app.
ActorAppId String The ID of the app.
ActorAppDisplayName String The display name of the app.
ContextTag String The user or team on whose behalf the actor performed the action. Might be missing due to historical data gap.
ContextAccountId String Account ID of the context.
ContextDisplayName String Display name of the context.
ContextEmail String Email of the context.
ContextTeamMemberId String Team member ID of the context.
AccessMethodTag String The method that was used to perform the action.
EndUserWebSessionId String Web session ID.
EndUserDesktopSessionId String Desktop session ID.
EndUserMobileSessionId String Mobile session ID.
SignInAsWebSessionId String Sign-in-as session ID.
ContentManagerWebSessionId String Content manager session ID.
AdminConsoleWebSessionId String Admin console session ID.
EnterpriseConsoleSessionId String Enterprise console session ID.
ApiSessionRequestId String API request ID.
GeoLocationIpAddress String IP Address.
GeoLocationCity String City of the geolocation.
GeoLocationRegion String Region of the geolocation.
GeoLocationCountry String Country of the geolocation.
InvolveNonTeamMembers Boolean Indicator if the event includes a non team member.

Pseudo-Columns

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

Name Type Description
StartTime Timestamp Filter by start time.
EndTime Timestamp Filter by end time.

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