Provides detailed information about folder hierarchies and metadata in a user's Google Drive.

Select

It is also possible to get all the folders from a Drive. You must set the connection property SupportsAllDrives to true, in order to query from a specific Drive.

The add-in uses the Google Drive API to process WHERE clause conditions built with the following column. The rest of the filter is executed client-side within the add-in.

SELECT * FROM Folders WHERE DriveId = '0ACkq0ZiV0yJCUk9PVA'

Note: It's recommended to limit your query to only the necessary fields, as specifying a large set of fields can lead to decreased performance.

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier assigned to the file in Google Drive.
Name	String	The display name of the file. This name does not need to be unique within a folder. Items such as the root folder of My Drive, Team Drive roots, and the Application Data folder have fixed names.
DriveId	String	The identifier of the personal or shared drive that contains the file.
ParentIds	String	The unique identifier of the parent folder that contains the file. If omitted, the folder is located in the root directory.
Description	String	A user-defined summary describing the purpose or contents of the file or folder.
CreatedTime	Datetime	The timestamp when the file or folder was first created in Google Drive.
ModifiedTime	Datetime	The timestamp of the most recent change made to the file or folder.
ModifiedByMeTime	Datetime	The last time the user modified the file.
SharedWithMeTime	Datetime	The time when the file was shared with the user.
TrashedTime	Datetime	The time that the file was trashed.
OwnerName	String	The full name of the user who owns the file or folder.
OwnerEmail	String	The email address of the owner of the file or folder.
IsOwnedByMe	Boolean	Indicates whether the current user owns the file.
IsModifiedByMe	Boolean	Indicates whether the file has been modified by the current user.
IsShared	Boolean	Indicates whether the file has been shared with other users.
SharingUserName	String	The display name of the user who shared the file with the current user.
SharingUserEmail	String	The email address of the user who shared the file with the current user.
Permissions	String	The full list of permissions for the resource represented as a JSON aggregate. This is only available if the requesting user can share the file. Not populated for items in shared drives.
PermissionIds	String	The list of permission IDs for users with access to this file.
WritersCanShare	Boolean	Indicates whether users with write access can share the file.
ViewersCanCopyContent	Boolean	Indicates whether viewers and commenters can copy, download, or print the file.
CopyRequiresWriterPermission	Boolean	Indicates whether copying the file requires writer permission.
HasAugmentedPermissions	Boolean	Indicates whether the user has additional permissions on the file.
InheritedPermissionsDisabled	Boolean	Indicates whether the file inherits permissions from its parent.
Starred	Boolean	If the value is 'true', the resource is marked as starred by the user.
Trashed	Boolean	If the value is 'true', the resource has been moved to the trash.
Viewed	Boolean	If the value is 'true', the file or folder has been opened or previewed by the authenticated user.
TrashingUserName	String	The display name of the user who moved the file to trash.
TrashingUserEmail	String	The email address of the user who moved the file to trash.
CanChangeViewersCanCopyContent	Boolean	Whether the user can change whether viewers can copy content, download, or print the file.
CanMoveChildrenOutOfDrive	Boolean	Whether the user can move children out of this drive.
CanReadDrive	Boolean	Whether the user can read the drive to which this resource belongs.
CanEdit	Boolean	Whether the user can edit this resource.
CanCopy	Boolean	Whether the user can copy this resource.
CanComment	Boolean	Whether the user can comment on this resource.
CanAddChildren	Boolean	Whether the user can add children to this folder.
CanDelete	Boolean	Whether the user can delete this resource.
CanListChildren	Boolean	Whether the user can list the children of this folder.
CanRemoveChildren	Boolean	Whether the user can remove children from this folder.
CanRename	Boolean	Whether the user can rename this resource.
CanTrash	Boolean	Whether the user can move this resource to trash.
CanReadTeamDrive	Boolean	Whether the user can read the Team Drive to which this resource belongs.
CanMoveTeamDriveItem	Boolean	Whether the user can move this Team Drive item.
CanChangeCopyRequiresWriterPermission	Boolean	Whether the user can change the copyRequiresWriterPermission restriction of this resource.
CanMoveItemIntoTeamDrive	Boolean	Whether the user can move this item into a Team Drive.
CanUntrash	Boolean	Whether the user can restore this resource from trash.
CanMoveItemWithinTeamDrive	Boolean	Whether the user can move this item within a Team Drive.
CanMoveItemOutOfTeamDrive	Boolean	Whether the user can move this item out of a Team Drive.
CanDeleteChildren	Boolean	Whether the user can delete children of this folder.
CanMoveChildrenOutOfTeamDrive	Boolean	Whether the user can move children out of this Team Drive folder.
CanMoveChildrenWithinTeamDrive	Boolean	Whether the user can move children within this Team Drive folder.
CanTrashChildren	Boolean	Whether the user can move children of this folder to trash.
CanMoveItemOutOfDrive	Boolean	Whether the user can move this item out of this drive.
CanAddMyDriveParent	Boolean	Whether the user can add a parent for this item in My Drive.
CanRemoveMyDriveParent	Boolean	Whether the user can remove a parent from this item in My Drive.
CanMoveItemWithinDrive	Boolean	Whether the user can move this item within this drive.
CanShare	Boolean	Whether the user can share this resource.
CanMoveChildrenWithinDrive	Boolean	Whether the user can move children within this drive.
CanModifyContentRestriction	Boolean	Whether the user can modify content restrictions on this resource.
CanAddFolderFromAnotherDrive	Boolean	Whether the user can add a folder from another drive to this folder.
CanChangeSecurityUpdateEnabled	Boolean	Whether the user can change the security update enabled setting for this file.
CanAcceptOwnership	Boolean	Whether the user can accept ownership of this file.
CanReadLabels	Boolean	Whether the user can read the labels on this resource.
CanModifyLabels	Boolean	Whether the user can modify the labels on this resource.
CanModifyEditorContentRestriction	Boolean	Whether the user can modify editor content restrictions on this resource.
CanModifyOwnerContentRestriction	Boolean	Whether the user can modify owner content restrictions on this resource.
CanRemoveContentRestriction	Boolean	Whether the user can remove content restrictions on this resource.
CanDisableInheritedPermissions	Boolean	Whether the user can disable inherited permissions on this resource.
CanEnableInheritedPermissions	Boolean	Whether the user can enable inherited permissions on this file.
CanChangeItemDownloadRestriction	Boolean	Whether the user can change the download restriction on this file.
IsSecurityUpdateEligible	Boolean	Indicates whether the file is eligible for a security update related to link sharing.
IsSecurityUpdateEnabled	Boolean	Indicates whether the security update for link sharing is enabled on the file.
WebViewLink	String	A link for opening the file in a relevant Google editor or viewer in a browser.
ResourceKey	String	A key required to access the file via a shared link.
IconLink	String	A URL to the icon representing the file type.
FolderColorRGB	String	The color of the folder as an RGB hex string, if set.
ThumbnailVersion	Integer	The version of the file's thumbnail.
Version	Integer	The version number of the file.
HeadRevisionId	String	The ID of the file's head revision.
Properties	Object	A collection of arbitrary key-value pairs which are visible to all apps.
AppProperties	Object	A collection of arbitrary key-value pairs which are private to the requesting app.
Kind	String	Identifies what kind of resource this is. Value: the fixed string drive#file.
Spaces	String	The list of spaces the file is in, such as drive, appDataFolder, or photos.
QuotaBytesUsed	Integer	The number of storage quota bytes used by the file.
IsAppAuthorized	Boolean	Indicates whether the file was created or opened by the requesting app.
Query	String	Accepts a custom query string using the Google Drive Software Development Kit (SDK) language. Overrides any conditions defined in the WHERE clause.