Reference

Endpoint List files (Recursive)

Name

list_files

Description

List files / folders with search criteria

Related Tables

Files , FilesList

Parameters

Parameter Required Options
Name: DriveType

Label: Drive Type

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. 		YES
Option Value
My Drive user
Shared Drive drive
All Drives allDrives
Name: Query

Label: Search Criteria

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
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'
Name: DriveId

Label: Shared DriveId

By default file lists from MyDrive but if you like to search other Shared drive (formally known as Team drive) then set this parameter.
Name: pageSize

Label: PageSize
Name: SupportsAllDrives

Label: Supports all drives (e.g. My and Shared)

Whether the requesting application supports both My Drives and shared drives.
Option Value
true true
false false
Name: IncludeItemsFromAllDrives

Label: Include items from all drives (e.g. My and Shared)
Option Value
true true
false false
Name: Spaces

Label: Spaces to include in corpora (comma separed)
Name: IncludePermissionsForView

Label: Include Permissions For View
Option Value
true true
false false
Name: IncludeLabels

Label: Include Labels
Option Value
true true
false false

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Id DT_WSTR nvarchar(440) 440
Kind DT_WSTR nvarchar(200) 200
Name DT_WSTR nvarchar(780) 780
MimeType DT_WSTR nvarchar(650) 650
CreatedTime DT_DBTIMESTAMP datetime
ModifiedTime DT_DBTIMESTAMP datetime
Size DT_WSTR nvarchar(200) 200
Version DT_WSTR nvarchar(200) 200
Shared DT_BOOL bit
Starred DT_BOOL bit
Trashed DT_BOOL bit
FileExtension DT_WSTR nvarchar(200) 200
DriveId DT_WSTR nvarchar(500) 500
CopyRequiresWriterPermission DT_BOOL bit
Md5Checksum DT_WSTR nvarchar(500) 500
WritersCanShare DT_BOOL bit
ViewedByMe DT_BOOL bit
Parents DT_WSTR nvarchar(500) 500
ThumbnailLink DT_WSTR nvarchar(4000) 4000
IconLink DT_WSTR nvarchar(1000) 1000
LastModifyingUserDisplayName DT_WSTR nvarchar(500) 500
LastModifyingUserKind DT_WSTR nvarchar(100) 100
LastModifyingUserMe DT_BOOL bit
LastModifyingUserPermissionId DT_WSTR nvarchar(500) 500
LastModifyingUserEmailAddress DT_WSTR nvarchar(500) 500
LastModifyingUserPhotoLink DT_WSTR nvarchar(1000) 1000
Owners DT_WSTR nvarchar(4000) 4000
HeadRevisionId DT_WSTR nvarchar(1000) 1000
WebViewLink DT_WSTR nvarchar(1000) 1000
WebContentLink DT_WSTR nvarchar(1000) 1000
ViewersCanCopyContent DT_BOOL bit
Permissions DT_WSTR nvarchar(4000) 4000
HasThumbnail DT_BOOL bit
Spaces DT_WSTR nvarchar(500) 500
ExplicitlyTrashed DT_BOOL bit
ModifiedByMeTime DT_DBTIMESTAMP datetime
ViewedByMeTime DT_DBTIMESTAMP datetime
QuotaBytesUsed DT_WSTR nvarchar(50) 50
OriginalFilename DT_WSTR nvarchar(500) 500
OwnedByMe DT_BOOL bit
FullFileExtension DT_WSTR nvarchar(50) 50
IsAppAuthorized DT_BOOL bit
CanChangeViewersCanCopyContent DT_BOOL bit
CanEdit DT_BOOL bit
CanCopy DT_BOOL bit
CanComment DT_BOOL bit
CanAddChildren DT_BOOL bit
CanDelete DT_BOOL bit
CanDownload DT_BOOL bit
CanListChildren DT_BOOL bit
CanRemoveChildren DT_BOOL bit
CanRename DT_BOOL bit
CanTrash DT_BOOL bit
CanReadRevisions DT_BOOL bit
CanChangeCopyRequiresWriterPermission DT_BOOL bit
CanMoveItemIntoTeamDrive DT_BOOL bit
CanUntrash DT_BOOL bit
CanModifyContent DT_BOOL bit
CanMoveItemOutOfDrive DT_BOOL bit
CanAddMyDriveParent DT_BOOL bit
CanRemoveMyDriveParent DT_BOOL bit
CanMoveItemWithinDrive DT_BOOL bit
CanShare DT_BOOL bit
CanMoveChildrenWithinDrive DT_BOOL bit
CanModifyContentRestriction DT_BOOL bit
CanChangeSecurityUpdateEnabled DT_BOOL bit
CanAcceptOwnership DT_BOOL bit
CanReadLabels DT_BOOL bit
CanModifyLabels DT_BOOL bit
CanModifyEditorContentRestriction DT_BOOL bit
CanModifyOwnerContentRestriction DT_BOOL bit
CanRemoveContentRestriction DT_BOOL bit
CanMoveChildrenOutOfDrive DT_BOOL bit
CanReadDrive DT_BOOL bit
CanReadTeamDrive DT_BOOL bit
CanMoveTeamDriveItem DT_BOOL bit
CanMoveItemWithinTeamDrive DT_BOOL bit
CanMoveItemOutOfTeamDrive DT_BOOL bit
CanDeleteChildren DT_BOOL bit
CanMoveChildrenOutOfTeamDrive DT_BOOL bit
CanMoveChildrenWithinTeamDrive DT_BOOL bit
CanTrashChildren DT_BOOL bit
CanAddFolderFromAnotherDrive DT_BOOL bit
ThumbnailVersion DT_WSTR nvarchar(50) 50
ModifiedByMe DT_BOOL bit
PermissionIds DT_WSTR nvarchar(500) 500
ImageMediaMetadataWidth DT_I4 int
ImageMediaMetadataHeight DT_I4 int
ImageMediaMetadataRotation DT_I4 int
LinkShareMetadataSecurityUpdateEligible DT_BOOL bit
LinkShareMetadataSecurityUpdateEnabled DT_BOOL bit
Sha1Checksum DT_WSTR nvarchar(500) 500
Sha256Checksum DT_WSTR nvarchar(1000) 1000
HasAugmentedPermissions 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 Files 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
Files
Optional Parameters
Search Criteria mimeType!='application/vnd.google-apps.folder' AND trashed!=true
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Files table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to list files:

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
Files
Select
Optional Parameters
Search Criteria mimeType!='application/vnd.google-apps.folder' AND trashed!=true
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

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