Docs
Query the Google Docs contained in a user's Google Drive.
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 ID of the file. |
| Name | String | The name of the file. This is not necessarily unique within a folder. Note that for immutable items such as the top level folders of Team Drives, My Drive root folder, and Application Data folder the name is constant. |
| DriveId | String | The Id of the Drive. |
| Description | String | A short description of the file or folder. |
| Extension | String | The extension of the file. |
| CreatedTime | Datetime | The creation date of the file or folder. |
| ModifiedTime | Datetime | The last modified date of the file or folder. |
| Size | Long | The size of the file in bytes. |
| OwnerName | String | The name of the resource's owner. |
| OwnerEmail | String | The email of the resource's owner. |
| Starred | Boolean | This field sets whether or not the resource is starred. |
| Trashed | Boolean | This field sets whether or not the resource has been moved to the trash. |
| Viewed | Boolean | This field sets whether or not the resource has been viewed by the current user. |
| ParentIds | String | A comma-separated list of parent folder Ids. |
| ChildIds | String | A semicolon-separated list of child resource Ids. |
| ChildLinks | String | A semicolon-separated list of child resource links. |
| Query | String | This field accepts a valid Google Drive SDK query, which overrides conditionals in the WHERE clause. |