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.

SELECT * FROM Folders WHERE DriveId = '0ACkq0ZiV0yJCUk9PVA'

NOTE: specifying a large set of fields may result in lower performance, so we recommend that you restrict your query to only the columns you need for best results.

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier assigned to the folder in Google Drive.
Name	String	The display name of the folder. This name is not guaranteed to be unique within its parent. Immutable folders such as the root of My Drive or Team Drives have a constant name.
DriveId	String	The identifier of the Drive (personal or shared) that contains the folder.
Description	String	A user-defined summary describing the contents or purpose of the folder.
CreatedTime	Datetime	The timestamp indicating when the folder was initially created in Google Drive.
ModifiedTime	Datetime	The timestamp of the most recent update made to the folder.
Size	Long	The size in bytes of the folder's metadata and content references. Does not represent the total size of contents within the folder.
OwnerName	String	The full name of the user who owns the folder.
OwnerEmail	String	The email address associated with the folder's owner.
Starred	Boolean	If the value is 'true', the folder is marked as starred for quick access.
Trashed	Boolean	If the value is 'true', the folder has been moved to the trash.
Viewed	Boolean	If the value is 'true', the folder has been accessed by the authenticated user.
ParentIds	String	A comma-separated list of folder IDs, such as abc123, def456, ghi789, that act as parent directories for this folder.
ChildIds	String	A semicolon-separated list of IDs, such as folder001; folder002; folder003, representing child resources contained in this folder.
ChildLinks	String	A semicolon-separated list of URLs, such as https://drive.google.com/folder1; https://drive.google.com/folder2, linking to child resources.
Query	String	Accepts a Google Drive Software Development Kit (SDK) query string to override default filtering set in the WHERE clause.