Endpoint List files (Recursive)

Name

list_files

Description

List files / folders with search criteria

Related Tables

Files , FilesList

Parameters

Output Columns

Input Columns

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 and write Google Drive data effortlessly. Integrate, manage, and automate files, folders, and shared drives — almost no coding required.

Google Drive

Files

Optional Parameters
Search Criteria	mimeType!='application/vnd.google-apps.folder' AND trashed!=true

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 and write Google Drive data effortlessly. Integrate, manage, and automate files, folders, and shared drives — almost no coding required.

Google Drive

Files

Select

Optional Parameters
Search Criteria	mimeType!='application/vnd.google-apps.folder' AND trashed!=true

ODBC application

Use these SQL queries in your ODBC application data source:

List / search files from my drive

<p>Lists or searches files in the user's My Drive. Use the <code>Query</code> parameter to filter by name or other criteria (e.g. <code>name contains "ZappySys*.*"</code>).</p>

SELECT * FROM Files
WITH(
	--Query='name contains "ZappySys*.*"',
)

List / search files from a single shared drive

<p>Lists or searches files in one shared drive. Supply <code>DriveId</code> and set <code>DriveType='drive'</code>, <code>SupportsAllDrives='true'</code>, and <code>IncludeItemsFromAllDrives='true'</code>. Optionally use <code>Query</code> to filter.</p>

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

List / search files from all shared drives

<p>Lists or searches files across all shared drives the user can access. Set <code>DriveType='allDrives'</code> with <code>SupportsAllDrives</code> and <code>IncludeItemsFromAllDrives</code>. Optionally use <code>Query</code> to filter.</p>

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

List files

<p>Returns the list of files in the user's drive (or filtered by WITH options).</p>

SELECT * FROM Files

Get files list

<p>Returns the list of files (excluding folders) from the drive.</p>

SELECT * FROM FilesList

SQL Server

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

List / search files from my drive

<p>Lists or searches files in the user's My Drive. Use the <code>Query</code> parameter to filter by name or other criteria (e.g. <code>name contains "ZappySys*.*"</code>).</p>

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

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

List / search files from a single shared drive

<p>Lists or searches files in one shared drive. Supply <code>DriveId</code> and set <code>DriveType='drive'</code>, <code>SupportsAllDrives='true'</code>, and <code>IncludeItemsFromAllDrives='true'</code>. Optionally use <code>Query</code> to filter.</p>

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

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

List / search files from all shared drives

<p>Lists or searches files across all shared drives the user can access. Set <code>DriveType='allDrives'</code> with <code>SupportsAllDrives</code> and <code>IncludeItemsFromAllDrives</code>. Optionally use <code>Query</code> to filter.</p>

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

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

List files

<p>Returns the list of files in the user's drive (or filtered by WITH options).</p>

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

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];

Get files list

<p>Returns the list of files (excluding folders) from the drive.</p>

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

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];