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 connector uses the Dropbox API to process search criteria that refer to the ResourceId and ResourceType columns. The connector processes other filters client-side within the connector. 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.

Tableau Connector for Dropbox

SharedMembers

Table Specific Information

Select

Columns