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 driver uses the Dropbox API to process search criteria that refer to the ResourceId and ResourceType columns. The driver processes other filters client-side within the driver. For example, the following queries are processed server side.

SELECT * FROM SharedMembers

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'

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
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.