Google Drive Connector
Documentation
Version: 10
Documentation
Endpoint

List files (Recursive)

Name

list_files

Description

List files / folders with search criteria

Related Tables

Files , FilesList

Parameters

Parameter Label Required Options Description
DriveType Drive Type YES
Option Value
My Drive user
Shared Drive drive
All Drives allDrives
Default search context is User's drive. Bodies of items (files/documents) to which the query applies. Supported bodies are 'user', 'domain', 'drive', and 'allDrives'. Prefer 'user' or 'drive' to 'allDrives' for efficiency. By default, corpora is set to 'user'. However, this can change depending on the filter set through the 'Query' parameter.
Query Search Criteria NO
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'
List items from a folder 'your-folder-id' in parents and trashed=false
List deleted items from a folder 'your-folder-id' in parents and trashed=true
By Parent Folder Id 'your-folder-id' in parents
By created time createdTime > '2012-06-04T12:00:00'
By modified time modifiedTime > '2012-06-04T12:00:00'
Allow only shared files and folders sharedWithMe=true
Exclude trashed files trashed=false
Include files from trash mimeType!='application/vnd.google-apps.folder'
Exclude files from trash mimeType!='application/vnd.google-apps.folder' and trashed!=true
Exclude Folders mimeType!='application/vnd.google-apps.folder'
Exclude App Script mimeType!='application/vnd.google-apps.script'
Search for spreadsheet mimeType = 'application/vnd.google-apps.spreadsheet'
Search for multiple files type mimeType contains 'application/vnd.google-apps.spreadsheet' OR mimeType contains 'application/vnd.google-apps.document' OR mimeType contains 'application/vnd.google-apps.presentation' OR mimeType contains 'application/vnd.google-apps.drawing'
Data filter (e.g. somecolumn -eq 'somevalue' ) , User can select multiple filter criteria using 'AND','OR' operator , Note*:- please refer the link for more filter criteria : https://zappysys.com/links?url=https://developers.google.com/drive/api/guides/search-files [API reference]
DriveId Shared DriveId NO By default file lists from MyDrive but if you like to search other Shared drive (formally known as Team drive) then set this parameter.
pageSize PageSize NO
SupportsAllDrives Supports all drives (e.g. My and Shared) NO
Option Value
true true
false false
Whether the requesting application supports both My Drives and shared drives.
IncludeItemsFromAllDrives Include items from all drives (e.g. My and Shared) NO
Option Value
true true
false false
Spaces Spaces to include in corpora (comma separed) NO
IncludePermissionsForView Include Permissions For View NO
Option Value
true true
false false
IncludeLabels Include Labels NO
Option Value
true true
false false

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(440) 440 False
Kind DT_WSTR nvarchar(200) 200 False
Name DT_WSTR nvarchar(780) 780 False
MimeType DT_WSTR nvarchar(650) 650 False
CreatedTime DT_DBTIMESTAMP datetime False
ModifiedTime DT_DBTIMESTAMP datetime False
Size DT_WSTR nvarchar(200) 200 False
Version DT_WSTR nvarchar(200) 200 False
Shared DT_BOOL bit False
Starred DT_BOOL bit False
Trashed DT_BOOL bit False
FileExtension DT_WSTR nvarchar(200) 200 False
DriveId DT_WSTR nvarchar(500) 500 False
CopyRequiresWriterPermission DT_BOOL bit False
Md5Checksum DT_WSTR nvarchar(500) 500 False
WritersCanShare DT_BOOL bit False
ViewedByMe DT_BOOL bit False
Parents DT_WSTR nvarchar(500) 500 False
ThumbnailLink DT_WSTR nvarchar(4000) 4000 False
IconLink DT_WSTR nvarchar(1000) 1000 False
LastModifyingUserDisplayName DT_WSTR nvarchar(500) 500 False
LastModifyingUserKind DT_WSTR nvarchar(100) 100 False
LastModifyingUserMe DT_BOOL bit False
LastModifyingUserPermissionId DT_WSTR nvarchar(500) 500 False
LastModifyingUserEmailAddress DT_WSTR nvarchar(500) 500 False
LastModifyingUserPhotoLink DT_WSTR nvarchar(1000) 1000 False
Owners DT_WSTR nvarchar(4000) 4000 False
HeadRevisionId DT_WSTR nvarchar(1000) 1000 False
WebViewLink DT_WSTR nvarchar(1000) 1000 False
WebContentLink DT_WSTR nvarchar(1000) 1000 False
ViewersCanCopyContent DT_BOOL bit False
Permissions DT_WSTR nvarchar(4000) 4000 False
HasThumbnail DT_BOOL bit False
Spaces DT_WSTR nvarchar(500) 500 False
ExplicitlyTrashed DT_BOOL bit False
ModifiedByMeTime DT_DBTIMESTAMP datetime False
ViewedByMeTime DT_DBTIMESTAMP datetime False
QuotaBytesUsed DT_WSTR nvarchar(50) 50 False
OriginalFilename DT_WSTR nvarchar(500) 500 False
OwnedByMe DT_BOOL bit False
FullFileExtension DT_WSTR nvarchar(50) 50 False
IsAppAuthorized DT_BOOL bit False
CanChangeViewersCanCopyContent DT_BOOL bit False
CanEdit DT_BOOL bit False
CanCopy DT_BOOL bit False
CanComment DT_BOOL bit False
CanAddChildren DT_BOOL bit False
CanDelete DT_BOOL bit False
CanDownload DT_BOOL bit False
CanListChildren DT_BOOL bit False
CanRemoveChildren DT_BOOL bit False
CanRename DT_BOOL bit False
CanTrash DT_BOOL bit False
CanReadRevisions DT_BOOL bit False
CanChangeCopyRequiresWriterPermission DT_BOOL bit False
CanMoveItemIntoTeamDrive DT_BOOL bit False
CanUntrash DT_BOOL bit False
CanModifyContent DT_BOOL bit False
CanMoveItemOutOfDrive DT_BOOL bit False
CanAddMyDriveParent DT_BOOL bit False
CanRemoveMyDriveParent DT_BOOL bit False
CanMoveItemWithinDrive DT_BOOL bit False
CanShare DT_BOOL bit False
CanMoveChildrenWithinDrive DT_BOOL bit False
CanModifyContentRestriction DT_BOOL bit False
CanChangeSecurityUpdateEnabled DT_BOOL bit False
CanAcceptOwnership DT_BOOL bit False
CanReadLabels DT_BOOL bit False
CanModifyLabels DT_BOOL bit False
CanModifyEditorContentRestriction DT_BOOL bit False
CanModifyOwnerContentRestriction DT_BOOL bit False
CanRemoveContentRestriction DT_BOOL bit False
CanMoveChildrenOutOfDrive DT_BOOL bit False
CanReadDrive DT_BOOL bit False
CanReadTeamDrive DT_BOOL bit False
CanMoveTeamDriveItem DT_BOOL bit False
CanMoveItemWithinTeamDrive DT_BOOL bit False
CanMoveItemOutOfTeamDrive DT_BOOL bit False
CanDeleteChildren DT_BOOL bit False
CanMoveChildrenOutOfTeamDrive DT_BOOL bit False
CanMoveChildrenWithinTeamDrive DT_BOOL bit False
CanTrashChildren DT_BOOL bit False
CanAddFolderFromAnotherDrive DT_BOOL bit False
ThumbnailVersion DT_WSTR nvarchar(50) 50 False
ModifiedByMe DT_BOOL bit False
PermissionIds DT_WSTR nvarchar(500) 500 False
ImageMediaMetadataWidth DT_I4 int False
ImageMediaMetadataHeight DT_I4 int False
ImageMediaMetadataRotation DT_I4 int False
LinkShareMetadataSecurityUpdateEligible DT_BOOL bit False
LinkShareMetadataSecurityUpdateEnabled DT_BOOL bit False
Sha1Checksum DT_WSTR nvarchar(500) 500 False
Sha256Checksum DT_WSTR nvarchar(1000) 1000 False
HasAugmentedPermissions DT_BOOL bit False
If the column you are looking for is missing, consider customizing Google Drive Connector.

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:

Read from Files table using API Destination

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

Google Drive
Files
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

List files 

SELECT * FROM list_files

List / search files from my drive

List or search files from my drive (use search query expression). Uncomment Query part to invoke filter 

SELECT * FROM Files
WITH(
	--Query='name  contains "ZappySys*.*"', --includes files where name contains "zappysys" word
)

List / search files from a single shared drive

List or search files from a specific shared drive by driveId and search query expression. Uncomment Query part to invoke filter 

SELECT * FROM Files
WITH(
	--Query='name  contains "ZappySys*.*"', --includes files where name contains "zappysys" word
	DriveId='0AFWIggplk2z6Uk9PVA', 
	DriveType='drive',
	SupportsAllDrives='true',
	IncludeItemsFromAllDrives='true'
)

List / search files from all shared drives

List or search files from all shared drives by driveId and search query expression. Uncomment Query part to invoke filter 

SELECT * FROM Files
WITH(
	--Query='name  contains "ZappySys*.*"', --includes files where name contains "zappysys" word
	DriveType='allDrives',
	SupportsAllDrives='true',
	IncludeItemsFromAllDrives='true'
)

Get file list

Downloads a file 

SELECT * FROM Files

Get files list

Gets files list 

SELECT * FROM FilesList

list_files endpoint belongs to Files , FilesList 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 files 

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

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

List / search files from my drive

List or search files from my drive (use search query expression). Uncomment Query part to invoke filter 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Files
WITH(
	--Query=''name  contains "ZappySys*.*"'', --includes files where name contains "zappysys" word
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

List / search files from a single shared drive

List or search files from a specific shared drive by driveId and search query expression. Uncomment Query part to invoke filter 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Files
WITH(
	--Query=''name  contains "ZappySys*.*"'', --includes files where name contains "zappysys" word
	DriveId=''0AFWIggplk2z6Uk9PVA'', 
	DriveType=''drive'',
	SupportsAllDrives=''true'',
	IncludeItemsFromAllDrives=''true''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

List / search files from all shared drives

List or search files from all shared drives by driveId and search query expression. Uncomment Query part to invoke filter 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Files
WITH(
	--Query=''name  contains "ZappySys*.*"'', --includes files where name contains "zappysys" word
	DriveType=''allDrives'',
	SupportsAllDrives=''true'',
	IncludeItemsFromAllDrives=''true''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

Get file list

Downloads a file 

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

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

Get files list

Gets files list 

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

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

list_files endpoint belongs to Files , FilesList table(s), and can therefore be used via those table(s).