Dropbox Tables

DropBoxDeviceSessions

This table stores active device sessions for team members, including web, desktop, and mobile clients.

Scoped Token Permission: sessions.list

Name	Type	Description
SessionID	string	The unique identifier of the device session.
SessionKind	string	The session type discriminator: `web`, `desktop`, or `mobile`.
TeamMemberID	string	The unique Dropbox team member identifier.
IpAddress	string	The IP address associated with the session.
Country	string	The country associated with the session's IP address.
Created	datetime	The date and time the session was created.
Updated	datetime	The date and time the session was last updated.
Expires	datetime	The date and time the session expires.
UserAgent	string	The browser user agent string for web sessions.
Os	string	The operating system of the client.
Browser	string	The browser name for web sessions.
HostName	string	The hostname of the desktop client.

DropBoxEventAssets

This table stores assets (files, folders, etc.) associated with Dropbox team audit events.

Scoped Token Permission: events.read

Name	Type	Description
ID	uniqueidentifier	Unique identifier for the record.
AssetTag	string	The asset type tag (e.g., `file`, `folder`, `paper_document`).
AssetName	string	The display name of the event asset.
AssetPath	string	The path of the event asset.
AssetFileID	string	The file identifier of the event asset.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxEventParticipants

This table stores participants associated with Dropbox team audit events.

Scoped Token Permission: events.read

Name	Type	Description
ID	uniqueidentifier	Unique identifier for the record.
ParticipantTag	string	The participant type tag.
AccountID	string	The Dropbox account identifier for the user.
Email	string	The email address of the user.
DisplayName	string	The display name of the team member.
TeamMemberID	string	The unique Dropbox team member identifier.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxEvents

This table stores Dropbox team audit log events including actor, origin, event type, and detail metadata.

Scoped Token Permission: events.read

Name	Type	Description
ID	uniqueidentifier	Unique identifier for the record.
Timestamp	datetime	The date and time the audit event occurred.
EventCategoryTag	string	The category tag of the audit event.
EventTypeTag	string	The type tag of the audit event.
EventTypeDescription	string	A human-readable description of the event type.
ActorTag	string	The actor type tag (e.g., `user`, `admin`, `app`).
ActorAccountID	string	The account ID of the actor who performed the action.
ActorEmail	string	The email address of the actor.
ActorDisplayName	string	The display name of the actor.
ActorTeamMemberID	string	The team member ID of the actor.
ContextTag	string	The context tag for the event.
ContextTeamMemberID	string	The team member ID in the event context.

DropBoxFeatures

This table stores Dropbox team feature flags such as shared team dropbox, file events, and selective sync availability.

Scoped Token Permission: team_info.read

Name	Type	Description
ID	biginteger	Unique identifier for the record.
UploadApiRateLimit	integer	The team's upload API rate limit.
HasTeamSharedDropbox	boolean	Indicates whether the team has a shared team dropbox.
HasTeamFileEventsEnabled	boolean	Indicates whether team file events are enabled.
HasTeamSelectiveSync	boolean	Indicates whether team selective sync is available.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxFileMembers

This table stores explicit sharing membership for individual files.

Scoped Token Permission: sharing.read

Name	Type	Description
ID	uniqueidentifier	Unique identifier for the record.
FileID	string	The unique Dropbox file or folder identifier.
MemberTypeTag	string	The member type tag: `user`, `group`, or `invitee`.
AccessTypeTag	string	The access level tag for the member (e.g., `owner`, `editor`, `viewer`).
AccountID	string	The Dropbox account identifier for the user.
Email	string	The email address of the user.
DisplayName	string	The display name of the team member.
TeamMemberID	string	The unique Dropbox team member identifier.
GroupID	string	The unique identifier of the Dropbox group.
GroupName	string	The display name of the Dropbox group.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxFiles

This table stores file and folder metadata from the team admin's Dropbox namespace.

Scoped Token Permission: files.metadata.read

Name	Type	Description
FileID	string	The unique Dropbox file or folder identifier.
Tag	string	The item type tag: file or folder.
Name	string	Name of the configuration or entity.
PathLower	string	The lowercased path of the file or folder.
PathDisplay	string	The display path of the file or folder.
ClientModified	datetime	The client modification timestamp.
ServerModified	datetime	The server modification timestamp of the file revision.
Rev	string	The revision identifier of the file.
Size	biginteger	The size of the file in bytes.
ContentHash	string	The content hash of the file revision.
IsDownloadable	boolean	Indicates whether the file is downloadable.
HasExplicitSharedMembers	boolean	Indicates whether the file has explicit shared members.

DropBoxGroupMembers

This table stores membership of Dropbox groups, linking groups to team members with access type.

Scoped Token Permission: groups.read

Name	Type	Description
ID	uniqueidentifier	Unique identifier for the record.
GroupID	string	The unique identifier of the Dropbox group.
TeamMemberID	string	The unique Dropbox team member identifier.
AccountID	string	The Dropbox account identifier for the user.
Email	string	The email address of the user.
DisplayName	string	The display name of the team member.
AccessTypeTag	string	The access level tag for the member (e.g., `owner`, `editor`, `viewer`).
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxGroups

This table stores Dropbox Business groups, including group name, external ID, and member count.

Scoped Token Permission: groups.read

Name	Type	Description
GroupID	string	The unique identifier of the Dropbox group.
GroupName	string	The display name of the Dropbox group.
GroupExternalId	string	An external identifier for the group, if configured.
MemberCount	integer	The number of members in the group.
GroupManagementTypeTag	string	The group management type tag (e.g., `company_managed`, `user_managed`).
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxIntegrations

Table contains 0+ Dropbox integration configurations a customer may have.

Name	Type	Description
ID	integer	Unique identifier for the record.
IntegrationID	integer	The ID of the Integration.
Name	string	Name of the configuration or entity.
IsEnabled	boolean	Whether this integration configuration is enabled or not.
CreatedDate	datetime	The date and time the integration configuration was created.
ModifiedDate	datetime	The date and time the integration configuration was updated.
CreatedBy	varchar	Email address of the user who created the integration configuration.
ModifiedBy	varchar	Email address of the user who modified the integration configuration.
AppKey	varchar	The Dropbox App Key (client ID) for this configuration.

DropBoxLegalHoldHeldRevisions

This table stores file revisions held under a Dropbox legal hold policy.

Scoped Token Permission: team_data.governance.write

Name	Type	Description
ID	uniqueidentifier	Unique identifier for the record.
PolicyID	string	The unique identifier of the legal hold policy.
NewFilename	string	The filename of the held revision.
OriginalRevisionId	string	The original revision identifier of the held file.
OriginalFilePath	string	The original file path of the held revision.
ServerModified	datetime	The server modification timestamp of the file revision.
AuthorMemberId	string	The team member ID of the author of the held revision.
AuthorMemberStatusTag	string	The membership status tag of the revision author.
AuthorEmail	string	The email address of the revision author.
FileType	string	The file type/extension of the held revision.
Size	biginteger	The size of the file in bytes.
ContentHash	string	The content hash of the file revision.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxLegalHoldMembers

This table stores team members subject to a Dropbox legal hold policy.

Scoped Token Permission: team_data.governance.write

Name	Type	Description
ID	uniqueidentifier	Unique identifier for the record.
PolicyID	string	The unique identifier of the legal hold policy.
TeamMemberID	string	The unique Dropbox team member identifier.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxLegalHoldPolicies

This table stores Dropbox legal hold policies including status, activation time, and date range.

Scoped Token Permission: team_data.governance.write

Name	Type	Description
PolicyID	string	The unique identifier of the legal hold policy.
Name	string	Name of the configuration or entity.
Description	string	A description of the legal hold policy.
ActivationTime	datetime	The date and time the legal hold policy was activated.
StatusTag	string	The membership status tag (e.g., `active`, `suspended`, `removed`).
StartDate	string	The start date of the legal hold policy.
EndDate	string	The end date of the legal hold policy, if applicable.
PermanentlyDeletedUsers	integer	The count of permanently deleted users covered by the policy.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxLinkedApps

This table stores third-party applications linked to team member Dropbox accounts.

Scoped Token Permission: sessions.list

Name	Type	Description
TeamMemberID	string	The unique Dropbox team member identifier.
AppID	string	The unique identifier of the linked application.
AppName	string	The display name of the linked application.
IsAppFolder	boolean	Indicates whether the linked app uses an app folder.
Publisher	string	The publisher of the linked application.
PublisherUrl	string	URL to the publisher's website.
LinkedOn	datetime	The date and time the application was linked.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxMemberRoles

This table stores admin roles assigned to Dropbox team members as returned by the members list API.

Scoped Token Permission: members.read

Name	Type	Description
TeamMemberID	string	The unique Dropbox team member identifier.
RoleID	string	The unique identifier of the admin role.
RoleName	string	The display name of the admin role.
RoleDescription	string	A description of the admin role.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxMembers

This table stores information about Dropbox Business team members, including profile details, membership status, and account identifiers.

Scoped Token Permission: members.read

Name	Type	Description
TeamMemberID	string	The unique Dropbox team member identifier.
ExternalId	string	An external identifier for the team member, if configured.
AccountID	string	The Dropbox account identifier for the user.
Email	string	The email address of the user.
EmailVerified	boolean	Indicates whether the user's email address has been verified.
StatusTag	string	The membership status tag (e.g., `active`, `suspended`, `removed`).
GivenName	string	The given (first) name of the team member.
Surname	string	The surname (last name) of the team member.
FamiliarName	string	The familiar name of the team member.
DisplayName	string	The display name of the team member.
AbbreviatedName	string	The abbreviated display name of the team member.
MembershipTypeTag	string	The membership type tag (e.g., `full`, `limited`).

DropBoxNamespaces

This table stores team-accessible namespaces such as team folders, shared folders, member home folders, and app folders.

Scoped Token Permission: team_data.member

Name	Type	Description
NamespaceID	string	The unique identifier of the namespace.
Name	string	Name of the configuration or entity.
NamespaceTypeTag	string	The namespace type tag (e.g., `team_folder`, `shared_folder`, `team_member_folder`, `app_folder`).
TeamMemberID	string	The unique Dropbox team member identifier.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxSharedFolderMembers

This table stores members of shared folders including users and their access levels.

Scoped Token Permission: sharing.read

Name	Type	Description
ID	uniqueidentifier	Unique identifier for the record.
SharedFolderID	string	The unique identifier of the shared folder.
MemberTypeTag	string	The member type tag: `user`, `group`, or `invitee`.
AccessTypeTag	string	The access level tag for the member (e.g., `owner`, `editor`, `viewer`).
AccountID	string	The Dropbox account identifier for the user.
Email	string	The email address of the user.
DisplayName	string	The display name of the team member.
TeamMemberID	string	The unique Dropbox team member identifier.
GroupID	string	The unique identifier of the Dropbox group.
GroupName	string	The display name of the Dropbox group.
IsInherited	boolean	Indicates whether the shared folder membership is inherited.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxSharedFolders

This table stores shared folders accessible to the authenticated admin, including access type and link metadata.

Scoped Token Permission: sharing.read

Name	Type	Description
SharedFolderID	string	The unique identifier of the shared folder.
Name	string	Name of the configuration or entity.
PathLower	string	The lowercased path of the file or folder.
AccessTypeTag	string	The access level tag for the member (e.g., `owner`, `editor`, `viewer`).
IsInsideTeamFolder	boolean	Indicates whether the shared folder is inside a team folder.
IsTeamFolder	boolean	Indicates whether the shared folder is a team folder.
OwnerTeamID	string	The team ID of the shared folder owner.
OwnerTeamName	string	The team name of the shared folder owner.
TimeInvited	datetime	The date and time the user was invited to the shared folder.
LinkCurrentAudienceTag	string	The current audience tag of the shared folder link.
LinkPasswordProtected	boolean	Indicates whether the shared folder link is password protected.
LinkUrl	string	The URL of the shared folder link.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxSharedLinks

This table stores shared links for files and folders including visibility and permission settings.

Scoped Token Permission: sharing.read

Name	Type	Description
ID	biginteger	Unique identifier for the record.
Url	string	The URL of the shared link.
Tag	string	The item type tag: file or folder.
Name	string	Name of the configuration or entity.
PathLower	string	The lowercased path of the file or folder.
LinkID	string	The unique identifier of the shared link.
Size	biginteger	The size of the file in bytes.
ClientModified	datetime	The client modification timestamp.
ServerModified	datetime	The server modification timestamp of the file revision.
Expires	datetime	The date and time the session expires.
ResolvedVisibilityTag	string	The resolved visibility tag of the shared link.
RequestedVisibilityTag	string	The requested visibility tag of the shared link.
CanRevoke	boolean	Indicates whether the shared link can be revoked.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxSharingAllowlistDomains

This table stores approved domains from the Dropbox team sharing allowlist.

Scoped Token Permission: team_info.read

Name	Type	Description
Domain	string	An approved domain on the team sharing allowlist.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxSharingAllowlistEmails

This table stores approved email addresses from the Dropbox team sharing allowlist.

Scoped Token Permission: team_info.read

Name	Type	Description
Email	string	The email address of the user.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxTeamFolders

This table stores Dropbox team folder metadata including name, status, and sync settings.

Scoped Token Permission: team_data.content.read

Name	Type	Description
TeamFolderID	string	The unique identifier of the team folder.
Name	string	Name of the configuration or entity.
StatusTag	string	The membership status tag (e.g., `active`, `suspended`, `removed`).
IsTeamSharedDropbox	boolean	Indicates whether this team folder is the shared team dropbox.
SyncSettingTag	string	The sync setting tag for the team folder.
ConfigID	integer	The ID of the configuration within Compyl.
BatchDate	datetime	The date and time data was synced to our database.

DropBoxTeams

This table stores Dropbox team-level information including licensing counts and team policy settings.

Scoped Token Permission: team_info.read

Name	Type	Description
ID	biginteger	Unique identifier for the record.
Name	string	Name of the configuration or entity.
TeamID	string	The unique identifier of the Dropbox team.
NumLicensedUsers	integer	The number of licensed users on the team.
NumProvisionedUsers	integer	The number of provisioned users on the team.
NumUsedLicenses	integer	The number of licenses currently in use.
PolicyEmmStateTag	string	The team EMM (enterprise mobility management) policy state tag.
PolicyOfficeAddinTag	string	The team Office add-in policy tag.
PolicySharingGroupCreationTag	string	The team policy tag for group creation.
PolicySharingSharedFolderMemberTag	string	The team policy tag for shared folder member restrictions.
PolicySharingSharedFolderJoinTag	string	The team policy tag for shared folder join restrictions.
PolicySharingSharedLinkCreateTag	string	The team policy tag for shared link creation.

Bridge Tables

DropBoxEvents_DropBoxEventAssets

Bridge table linking audit events to event assets.

Name	Type	Description
EventID	uniqueidentifier	The unique identifier of the audit event.
AssetID	uniqueidentifier	The unique identifier of the event asset.
ConfigID	integer	The ID of the configuration within Compyl.

DropBoxEvents_DropBoxEventParticipants

Bridge table linking audit events to event participants.

Name	Type	Description
EventID	uniqueidentifier	The unique identifier of the audit event.
ParticipantID	uniqueidentifier	The unique identifier of the event participant.
ConfigID	integer	The ID of the configuration within Compyl.

DropBoxDeviceSessions

DropBoxEventAssets

DropBoxEventParticipants

DropBoxEvents

DropBoxFeatures

DropBoxFileMembers

DropBoxFiles

DropBoxGroupMembers

DropBoxGroups

DropBoxIntegrations

DropBoxLegalHoldHeldRevisions

DropBoxLegalHoldMembers

DropBoxLegalHoldPolicies

DropBoxLinkedApps

DropBoxMemberRoles

DropBoxMembers

DropBoxNamespaces

DropBoxSharedFolderMembers

DropBoxSharedFolders

DropBoxSharedLinks

DropBoxSharingAllowlistDomains

DropBoxSharingAllowlistEmails

DropBoxTeamFolders

DropBoxTeams

Bridge Tables

DropBoxEvents_DropBoxEventAssets

DropBoxEvents_DropBoxEventParticipants

Learn more...