Returns folders from a user's account.

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

SELECT * FROM Folders

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

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

Delete

The driver 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')

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