Reference

Endpoint Lists shared drives

Name

list_shared_drives

Description

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

Related Tables

SharedDrives

Parameters

Parameter Required Options
Name: pageSize

Label: PageSize
Name: Query

Label: Search Criteria (Keep blank to get all)

File list filter
Option Value
None
By name (exact name match) name='abc'
By name (contains sub string) name contains 'abc'
By name (does not contain) not name contains 'abc'
By text (search inside file) fullText contains 'abc'
By created time createdTime > '2012-06-04T12:00:00'
Name: useDomainAdminAccess

Label: UseDomainAdminAccess

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

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(500) 500
Name DT_WSTR nvarchar(50) 50
ColorRgb DT_WSTR nvarchar(100) 100
Kind DT_WSTR nvarchar(500) 500
BackgroundImageLink DT_WSTR nvarchar(1000) 1000
CanAddChildren DT_BOOL bit
CanComment DT_BOOL bit
CanCopy DT_BOOL bit
CanDeleteDrive DT_BOOL bit
CanDownload DT_BOOL bit
CanEdit DT_BOOL bit
CanListChildren DT_BOOL bit
CanManageMembers DT_BOOL bit
CanReadRevisions DT_BOOL bit
CanRename DT_BOOL bit
CanRenameDrive DT_BOOL bit
CanChangeDriveBackground DT_BOOL bit
CanShare DT_BOOL bit
CanChangeCopyRequiresWriterPermissionRestriction DT_BOOL bit
CanChangeDomainUsersOnlyRestriction DT_BOOL bit
CanChangeDriveMembersOnlyRestriction DT_BOOL bit
CanChangeSharingFoldersRequiresOrganizerPermissionRestriction DT_BOOL bit
CanResetDriveRestrictions DT_BOOL bit
CanDeleteChildren DT_BOOL bit
CanTrashChildren DT_BOOL bit
CreatedTime DT_DBTIMESTAMP datetime
Hidden DT_BOOL bit
CopyRequiresWriterPermission DT_BOOL bit
DomainUsersOnly DT_BOOL bit
DriveMembersOnly DT_BOOL bit
AdminManagedRestrictions DT_BOOL bit
SharingFoldersRequiresOrganizerPermission DT_BOOL bit
If the column you are looking for is missing, consider customizing Google Drive Connector.

Input Columns

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

Examples

SSIS

Use Google Drive Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the SharedDrives table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Google Drive
Read / write Google Drive data inside your app; perform many Google Drive operations without coding, just using easy to use high performance API Connector for Google Drive
Google Drive
SharedDrives
There are no parameters to configure.
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the SharedDrives table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to lists shared drives:

API Destination - Google Drive
Read / write Google Drive data inside your app; perform many Google Drive operations without coding, just using easy to use high performance API Connector for Google Drive
Google Drive
SharedDrives
Select
There are no parameters to configure.
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List all shared drives

List all shared drives 

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

Get information about shared drive

Get information about shared drive 

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).

SQL Server

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

List all shared drives

List all shared drives 

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

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

Get information about shared drive

Get information about shared drive 

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).