SSIS Components for Google Drive

Build 20.0.7656

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.

ColumnSupported Operators
Namecontains, =, !=
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.

Name Type Description
DomainAdminAccess Boolean

If this field is set to true, then all Team Drives of the domain in which you are an administrator are returned.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7656