Provides detailed information about all files stored in a user's Dropbox, including metadata such as size, path, and last modified time.

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

SELECT * FROM Files WHERE Id = 'id:a4ayc_80_OEAAAAAAAAAYa'

SELECT * FROM Files WHERE ParentId = 'id:a4aad_40_OEACHSBDLKAYa'

SELECT * FROM Files WHERE FilePath = '/TestFolder/test.png'

Note that the FilePath filter will only return data for one specific file, since the FilePath is an absolute path. If you want to get data for all the files underneath a specified folder path, filter using ParentId. ParentId is a unique identifier for the containing folder. You can only retrieve the files that are located directly in this folder, not in its subfolders.

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 file. For example, the following queries are processed server side:

DELETE FROM Files WHERE Id = 'id:a4aad_40_OEACHSBDLKAYa'

DELETE FROM Files WHERE Id IN ('id:a4aad_40_OEACHSBDLKAYa', 'id:a4aad_40_OEACHSB3234234')

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	A unique identifier for the file in Dropbox.
Name	String	True	The name of the file, including its extension (for example, report.pdf).
ClientModified	Datetime	True	The timestamp when the file was last modified by the client before being uploaded to Dropbox.
ServerModified	Datetime	True	The timestamp of the most recent modification to the file on Dropbox servers.
Revision	String	True	A unique identifier representing the current revision of the file.
Size	Long	True	The size of the file in bytes.
DisplayPath	String	True	The original cased file path, intended for display purposes.
SymlinkInfoTarget	String	True	If the file is a symbolic link (symlink), this field indicates the target path the symlink points to.
HasExplicitSharedMembers	Boolean	True	Indicates whether the file has explicitly assigned shared members.
ContentHash	String	True	A hash value representing the file's contents, used to verify file integrity.
ReadOnly	Boolean	True	True when the file resides in a shared folder where the user has read-only access.
ParentSharedFolderId	String	True	The Id of the shared folder containing this file.
ModifiedBy	String	True	The identifier of the user who last modified the file.
ParentId	String	True	The unique Id of the folder that contains this file. Use this in filters to retrieve files from a specific folder.
FilePath	String	True	The full path of the file in Dropbox. Use this in filters to retrieve a file by its exact path.