Folders
Query the folders contained in a user's Google Drive.
Select
The add-in will use the Google Sheets API to process WHERE clause conditions built with the server side supported columns and operators. The rest of the filter is executed client side within the add-in.
The columns and operators that support server side filtering are:
- Name supports the 'CONTAINS,=,!=' operators.
- Description supports the 'CONTAINS' operator.
- ModifiedTime supports the '<=,<,=,!=,>,>=' operators.
- OwnerEmail supports the 'IN' operator.
- Starred supports the '=,!=' operators.
- Trashed supports the '=,!=' operators.
- ParentIds supports the 'IN' operator.
- DriveId supports the '=' operator. It is used to get all the folders from the specified Drive.
Note: You must set the connection property SupportsAllDrives to 'true', in order to query from a specific Drive.
All the columns that support server side filtering can be paired with the AND and OR logical operators. For example, the following queries are processed server side:
SELECT * FROM Folders WHERE Name = 'example folder'
SELECT * FROM Folders WHERE OwnerEmail IN ('[email protected]', '[email protected]') AND ModifiedTime >= '2020-04-01T05:30:00'
Columns
| Name | Type | Description |
| Id [KEY] | String | The ID of the folder. |
| Name | String | The name of the folder. 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 folder or folder. |
| CreatedTime | Datetime | The creation date of the folder or folder. |
| ModifiedTime | Datetime | The last modified date of the folder or folder. |
| Size | Long | The size of the folder 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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Query | String | This field accepts a valid Google Drive SDK query, which overrides conditionals in the WHERE clause. |