Get file info
Name
get_file_info
Description
Gets information of a file [API reference]
Related Tables
Parameters
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 |
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 FileInfo table using API Destination
This Endpoint belongs to FileInfo table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

ODBC application
Use these SQL queries in your ODBC application data source:
Get file info
SELECT * FROM get_file_info
WHERE Id = 'abcd-1234-id'
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
get_file_info
endpoint belongs to
FileInfo
, Files
, FilesList
, Folders
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:
Get file info
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_file_info
WHERE Id = ''abcd-1234-id''';
EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_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];