Endpoint

Lists shared drives

Name

list_shared_drives

Lists the user's shared drives (i.e. formally known as team drive) with optional search criteria [API reference]

Parameter

Label

Required

Options

Description

pageSize

PageSize

Query

Search Criteria (Keep blank to get all)

File list filter [API reference]

useDomainAdminAccess

UseDomainAdminAccess

Option	Value
true	true
false	false

Some operations such as searching for shared drives with specific attributes might need Admin access (set this to true)

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(500)`	500	`False`
Name	`DT_WSTR`	`nvarchar(50)`	50	`False`
ColorRgb	`DT_WSTR`	`nvarchar(100)`	100	`False`
Kind	`DT_WSTR`	`nvarchar(500)`	500	`False`
BackgroundImageLink	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
CanAddChildren	`DT_BOOL`	`bit`		`False`
CanComment	`DT_BOOL`	`bit`		`False`
CanCopy	`DT_BOOL`	`bit`		`False`
CanDeleteDrive	`DT_BOOL`	`bit`		`False`
CanDownload	`DT_BOOL`	`bit`		`False`
CanEdit	`DT_BOOL`	`bit`		`False`
CanListChildren	`DT_BOOL`	`bit`		`False`
CanManageMembers	`DT_BOOL`	`bit`		`False`
CanReadRevisions	`DT_BOOL`	`bit`		`False`
CanRename	`DT_BOOL`	`bit`		`False`
CanRenameDrive	`DT_BOOL`	`bit`		`False`
CanChangeDriveBackground	`DT_BOOL`	`bit`		`False`
CanShare	`DT_BOOL`	`bit`		`False`
CanChangeCopyRequiresWriterPermissionRestriction	`DT_BOOL`	`bit`		`False`
CanChangeDomainUsersOnlyRestriction	`DT_BOOL`	`bit`		`False`
CanChangeDriveMembersOnlyRestriction	`DT_BOOL`	`bit`		`False`
CanChangeSharingFoldersRequiresOrganizerPermissionRestriction	`DT_BOOL`	`bit`		`False`
CanResetDriveRestrictions	`DT_BOOL`	`bit`		`False`
CanDeleteChildren	`DT_BOOL`	`bit`		`False`
CanTrashChildren	`DT_BOOL`	`bit`		`False`
CreatedTime	`DT_DBTIMESTAMP`	`datetime`		`False`
Hidden	`DT_BOOL`	`bit`		`False`
CopyRequiresWriterPermission	`DT_BOOL`	`bit`		`False`
DomainUsersOnly	`DT_BOOL`	`bit`		`False`
DriveMembersOnly	`DT_BOOL`	`bit`		`False`
AdminManagedRestrictions	`DT_BOOL`	`bit`		`False`
SharingFoldersRequiresOrganizerPermission	`DT_BOOL`	`bit`		`False`

If the column you are looking for is missing, consider customizing Google Drive Connector.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Use Google Drive Connector in API Source component to read data or in API Destination component to read/write data:

This Endpoint belongs to SharedDrives table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Google Drive

SharedDrives

Select

Use these SQL queries in your ODBC application data source:

SELECT * FROM list_shared_drives

SELECT * FROM SharedDrives --WITH(Query='name = "HR"')

SELECT * FROM SharedDrives WITH(Query='name = "HR"')

list_shared_drives endpoint belongs to SharedDrives table(s), and can therefore be used via those table(s).

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM list_shared_drives';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM SharedDrives --WITH(Query=''name = "HR"'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM SharedDrives WITH(Query=''name = "HR"'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

list_shared_drives endpoint belongs to SharedDrives table(s), and can therefore be used via those table(s).