Query the Google Videos contained in a user's Google Drive.
It is also possible to get all the videos from a Team Drive.
Note: You must set the connection property TeamDriveSupport to 'true', in order to query from a specific Team Drive.
SELECT * FROM Videos WHERE TeamDriveId='0ACkq0ZiV0yJCUk9PVA'
|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.|
|TeamDriveId||String||The Id of the teamDrive.|
|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.|
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.
|Query||String||This field accepts a valid Google Drive SDK query, which overrides conditionals in the WHERE clause.|