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

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

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

Gets file information

SELECT * FROM FileInfo
  WITH (Id='1EVzXFVBQIh3LcJvfcLhI1UWhW3qUxFkM')
  --You can get file Id by selecting from 'list_files' endpoint

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

SQL Server

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

Get file information

Gets file information

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM FileInfo
  WITH (Id=''1EVzXFVBQIh3LcJvfcLhI1UWhW3qUxFkM'')
  --You can get file Id by selecting from ''list_files'' endpoint';

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];