TeamDrives

Create, delete, and query the available TeamDrives for a specific user.

Select

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.

Column	Supported 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

Insert

You must specify a value for the field 'Name', in order to insert a new Team Drive.

INSERT INTO TeamDRIVES(Name) VALUES('TestTeamDriveCDATA')

Delete

To delete a Team Drive, the Id is required.

DELETE FROM TeamDrives WHERE Id='0ALw8avjM8FrtUk9PVA'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	The Id of the team drive.
Name	String	False	The name of the team drive.
Capabilities	String	True	This field describes the effective capabilities that the current user has for the team drive.
CreatedTime	Datetime	True	The creation date of the team drive.

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.