Folders
Returns folders from a user's account.
Table Specific Information
The following scopes are required to access this view: files.metadata.readSelect
The provider uses the Dropbox API to process search criteria that refer to the Id or FolderPath columns. The provider processes other filters client-side within the provider. 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 provider 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. |