Videos
Lists video files in Drive and provides metadata like duration, resolution, and playback compatibility.
Select
It is also possible to get all the videos 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.
SELECT * FROM Videos WHERE DriveId = '0ACkq0ZiV0yJCUk9PVA'
Note: You must set the connection property SupportsAllDrives to true in order to query from a specific Drive.
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier assigned to the video file in Google Drive. |
| Name | String | The display name of the video file. This name may not be unique within a folder. Fixed items like the root of My Drive or Team Drives have constant names. |
| DriveId | String | The identifier of the Drive (personal or shared) that stores the video file. |
| Description | String | A user-defined summary or annotation describing the content or context of the video. |
| Extension | String | The file extension for the video file format, such as mp4, mov, or webm. |
| CreatedTime | Datetime | The timestamp when the video was first uploaded to Google Drive. |
| ModifiedTime | Datetime | The timestamp of the most recent change made to the video file. |
| Size | Long | The total size of the video file in bytes. |
| OwnerName | String | The full name of the user who owns the video file. |
| OwnerEmail | String | The email address associated with the video's owner. |
| Starred | Boolean | If the value is 'true', the video file is marked as starred by the user. |
| Trashed | Boolean | If the value is 'true', the video file has been moved to the trash. |
| Viewed | Boolean | If the value is 'true', the video file has been played or previewed by the authenticated user. |
| ParentIds | String | The unique ID 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. |