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]
Parameters
Parameter | Label | Required | Options | Description | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pageSize | PageSize | NO | ||||||||||||||||
Query | Search Criteria (Keep blank to get all) | NO |
|
File list filter [API reference] | ||||||||||||||
useDomainAdminAccess | UseDomainAdminAccess | NO |
|
Some operations such as searching for shared drives with specific attributes might need Admin access (set this to true) |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
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 |
Input Columns
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. |
Examples
SSIS
Use Google Drive Connector in API Source component to read data or in API Destination component to read/write data:
Lists shared drives using API Source
Google Drive
Lists shared drives

Lists shared drives using API Destination
Google Drive
Lists shared drives
