ODBC Driver for Dropbox

Build 23.0.8791

SharedMembers

Returns shared members from a shared file or folder.

Table Specific Information

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

Select

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

SELECT * FROM SharedMembers WHERE ResourceType = 'file'

SELECT * FROM SharedMembers WHERE ResourceType = 'folder'

SELECT * FROM SharedMembers WHERE ResourceId = 'id:3kmLmQFnf1AAAAAAAAAAAw' AND ResourceType = 'file'

SELECT * FROM SharedMembers WHERE ResourceId = '84528192421' AND ResourceType = 'folder'

Columns

Name Type Description
MemberId String The id of the shared member.
MemberType String The type of the shared member. Either User or Invitee.
ResourceId String The id of the shared file or folder that the shared members belong to.
ResourceType String The type of the resource. Either folder or file.
Email [KEY] String The email of the shared member.
AccessType String The type of the access for this member in the shared folder or file.

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