Lists folders within a user's Dropbox account, along with metadata including folder paths and creation details.

Table Specific Information

The following scope is required to access this view: files.metadata.read

Select

The connector uses the Dropbox API to process search criteria that refer to the Id, FolderPath, or exact matches on the DisplayPath column. Other filters are processed client-side within the connector.

For example, the following queries are processed server-side:

-- Retrieves a specific folder by its unique Id
SELECT * FROM Folders WHERE Id = 'id:a4ayc_80_OEAAAAAAAAAXz';

-- Retrieves folders under the specified path (server-side filtering)
SELECT * FROM Folders WHERE FolderPath = '/Test Folder';

-- Retrieves exactly one folder with this display path (server-side filtering)
SELECT * FROM Folders WHERE DisplayPath = '/folder1/folderA/folderB/folderC';

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:

-- Deletes a folder by Id
DELETE FROM Folders WHERE Id = 'id:a4ayc_80_OEAAAAAAAAAYa';

-- Deletes multiple folders by Id
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 in Dropbox.
Name	String	True	The name of the folder.
DisplayPath	String	True	The original cased folder path, used for display purposes.
ReadOnly	Boolean	True	True when the folder is located in a shared folder where the user has read-only permissions.
ParentSharedFolderId	String	True	The Id of the shared folder that contains this folder, if applicable.
SharedFolderId	String	True	The Id of the shared folder that is mounted at this location, if this folder is a shared-folder mount point.
TraverseOnly	Boolean	True	True when the user can only traverse the folder path and has limited visibility into its contents, due to restricted access permissions.
NoAccess	Boolean	True	True when the user has no access to the folder and cannot view or interact with its contents.
FolderPath	String	True	The Dropbox folder path used to retrieve subfolders. Use this in filters to return folders under a specified path.