Docs
Returns metadata about Google Docs stored in a user's Drive, including document titles, creation dates, and sharing settings.
Select
It is also possible to get all the docs from a Drive.
Note: You must set the connection property SupportsAllDrives to 'true', in order to query from a specific Drive.
SELECT * FROM Docs WHERE DriveId = '0ACkq0ZiV0yJCUk9PVA'
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. While this name can appear multiple times within a folder, certain items such as My Drive, Team Drive root folders, and the Application Data folder use a fixed, constant name. |
| DriveId | String | The identifier of the Drive (personal or shared) that contains the file. |
| Description | String | A short, user-defined summary describing the purpose or contents of the file or folder. |
| Extension | String | The file extension that indicates the file type, such as pdf, docx, or txt. |
| CreatedTime | Datetime | The timestamp indicating when the file or folder was initially created in Google Drive. |
| ModifiedTime | Datetime | The timestamp of the most recent update made to the file or folder. |
| Size | Long | The total size of the file in bytes. Not applicable to folders or native Google Docs files. |
| OwnerName | String | The full name of the user who owns the file or folder. |
| OwnerEmail | String | The email address associated with the file or folder's owner. |
| Starred | Boolean | If the value is 'true', the file or folder is marked as starred for easier access. |
| Trashed | Boolean | If the value is 'true', the file or folder 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. |
| ParentIds | String | A comma-separated list of folder IDs, such as abc123, def456, ghi789, that serve as the file's parent directories. |
| ChildIds | String | A semicolon-separated list of identifiers, such as file123; file456; file789, representing child files or folders within this resource. |
| ChildLinks | String | A semicolon-separated list of URLs, such as https://drive.google.com/file1; https://drive.google.com/file2, linking to the child resources. |
| Query | String | A custom query string formatted using the Google Drive Software Development Kit (SDK) query language. This overrides any WHERE clause conditions. |