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.
Note: You must set the connection property SupportsAllDrives to 'true', in order to query from a specific Drive.
SELECT * FROM Videos WHERE DriveId = '0ACkq0ZiV0yJCUk9PVA'
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 | A comma-separated list of parent folder IDs, such as abc123, def456, ghi789, that organize the video file within Drive. |
| ChildIds | String | A semicolon-separated list of child resource IDs, such as file001; file002; file003, applicable if the video is part of a container structure. |
| ChildLinks | String | A semicolon-separated list of URLs, such as https://drive.google.com/file1; https://drive.google.com/file2, that point to child items related to the video file. |
| Query | String | A query string written using the Google Drive Software Development Kit (SDK) syntax to override default filters or conditions. |