Docs
Returns metadata about Google Docs stored in a user's Drive, including document titles, creation dates, and sharing settings.
Select
It is possible to retrieve all the documents from a Drive.
The driver 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 driver.
- DriveId supports the following operator: =
For example, the following query is processed server-side:
SELECT * FROM Docs WHERE DriveId = '0ACkq0ZiV0yJCUk9PVA'
Note: You must set the connection property SupportsAllDrives to true to query from a specific Drive.
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. |
| Description | String | A user-defined summary describing the purpose or contents of the file or folder. |
| Extension | String | The file extension that reflects its format, such as pdf, csv, or jpg. |
| 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. |
| Size | Long | The total size of the file in bytes. This does not apply to folders or native Google Workspace files. |
| 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. |
| 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. |
| ParentIds | String | The unique identifier of the parent folder that contains the file. If omitted, the file is located in the root directory. |
| Query | String | Accepts a custom query string using the Google Drive Software Development Kit (SDK) language. Overrides any conditions defined in the WHERE clause. |