JDBC Driver for Dropbox

Build 22.0.8462

Users

Get information about multiple user accounts.

Table Specific Information

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

Select

The driver uses the Dropbox API to process search criteria that refer to the Id column. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM Users

SELECT * FROM Users WHERE Id='dbid:23443532432'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type Description
Id [KEY] String The user's unique Dropbox ID.
FirstName String The user's first name.
LastName String The user's last name, or family name.
FamiliarName String Locale-dependent name.
DisplayName String The display name in Dropbox for the user.
AbbreviatedName String An abbreviated form of the person's name.
Email String The user's e-mail address.
IsEmailVerified Boolean Whether the user has verified their e-mail address.
Disabled Boolean Whether the user has been disabled.
Locale String The language that the user specified.
ReferralLink String The user's referral link.
IsPaired Boolean Whether the user has a personal and work account.
AccountType String What type of account this user has.
ProfilePicUrl String URL for the photo representing the user, if one is set.
Country String The user's two-letter country code, if available.
TeamMemberId String This account's unique team member id. This field will only be present if team is present.
TeamRootInfoRootNamespaceId String The namespace ID for user's root namespace.
TeamRootInfoHomeNamespaceId String The namespace ID for user's home namespace.
TeamRootInfoHomePath String The path for user's home directory under the shared team root.
UserRootInfoRootNamespaceId String The namespace ID for user's root namespace.
UserRootInfoHomeNamespaceId String The namespace ID for user's home namespace.
TeamId String The team's unique ID.
TeamName String The name of the team.
TeamSharedFolderMemberPolicy String Who can join folders shared by team members.
TeamSharedFolderJoinPolicy String Which shared folders team members can join.
TeamSharedLinkCreatePolicy String Who can view shared links owned by team members.
TeamOfficeAddinPolicy String Team policy governing the use of the Office Add-In.

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