Returns folders from a user's account.

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 Id or FolderPath columns. The connector processes other filters client-side within the connector. For example, the following queries are processed server side.

SELECT * FROM Folders WHERE Id = 'id:a4ayc_80_OEAAAAAAAAAXz'

SELECT * FROM Folders WHERE FolderPath = '/Test Folder'

Delete

The connector uses the Dropbox API to process search criteria that refer to the Id column in order to perform a DELETE operation on a folder. For example, the following queries are processed server side:

DELETE FROM Folders WHERE Id = 'id:a4ayc_80_OEAAAAAAAAAYa'

DELETE FROM Folders WHERE Id IN ('id:a4ayc_80_OEAAAAAAAAAYa', 'id:a4aad_40_OEACHSB3234234')

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	A unique identifier for the folder.
Name	String	True	The name of the folder.
DisplayPath	String	True	The cased path to be used for display purposes only.
ReadOnly	Boolean	True	True if the file or folder is inside a read-only shared folder.
ParentSharedFolderId	String	True	The id of the parent shared folder if applicable.
SharedFolderId	String	True	If this folder is a shared folder mount point, the ID of the shared folder mounted at this location.
TraverseOnly	Boolean	True	Specifies that the folder can only be traversed and the user can only see a limited subset of the contents of this folder because they don't have read access to this folder.
NoAccess	Boolean	True	Specifies that the folder cannot be accessed by the user.
FolderPath	String	True	The folder path used for retrieving subfolders under. Set this in the filter to retreive only folders under the specified path.