Endpoint Get file info

Name

get_file_info

Description

Gets information of a file [API reference]

Related Tables

FileInfo , Files , FilesList , Folders

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 FileInfo 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

FileInfo

Required Parameters
Id	Fill-in the parameter...

API Destination

This Endpoint belongs to the FileInfo table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get file info:

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

FileInfo

Select, Lookup

Required Parameters
Id	Fill-in the parameter...

ODBC application

Use these SQL queries in your ODBC application data source:

Get file information

<p>Returns metadata for a single file (e.g. name, size, MIME type, created time). Supply the file ID.</p>

SELECT * FROM FileInfo
WITH(Id='1EVzXFVBQIh3LcJvfcLhI1UWhW3qUxFkM')

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:

Get file information

<p>Returns metadata for a single file (e.g. name, size, MIME type, created time). Supply the file ID.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM FileInfo
WITH(Id=''1EVzXFVBQIh3LcJvfcLhI1UWhW3qUxFkM'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_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];