Create, delete, and query the available TeamDrives for a specific user.
The TeamDrives table supports only a subset of columns for filtering. Below is a table containing those columns with their supported operations. All filters can be connected with 'OR' or 'AND' operators.
|Name||contains, =, !=|
|CreatedTime||<=, <, =, !=, >, >=|
SELECT * FROM TeamDrives ORDER BY NAME DESC LIMIT 2
SELECT * FROM TeamDrives WHERE Name='First Team Drive' AND DomainAdminAccess=true
SELECT * FROM TeamDrives WHERE CreatedTime>='2018-01-01' AND DomainAdminAccess=true
You must specify a value for the field 'Name', in order to insert a new Team Drive.
INSERT INTO TeamDRIVES(Name) VALUES('TestTeamDriveCDATA')
To delete a Team Drive, the Id is required.
DELETE FROM TeamDrives WHERE Id='0ALw8avjM8FrtUk9PVA'
The Id of the team drive.
The name of the team drive.
This field describes the effective capabilities that the current user has for the team drive.
The creation date of the team drive.
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.
If this field is set to true, then all Team Drives of the domain in which you are an administrator are returned.