Excel Add-In for Dropbox

Build 24.0.9062

Folders

Returns folders from a user's account.

Table Specific Information

The following scopes are required to access this view: files.metadata.read

Select

The 本製品 uses the Dropbox API to process search criteria that refer to the Id or FolderPath columns. The 本製品 processes other filters client-side within the 本製品. 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 本製品 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062