List deleted files / folders
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 Trash table using API Destination
This Endpoint belongs to Trash 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:
List deleted files / folders
SELECT * FROM list_deleted_files
Select from trash
Shows deleted items in Trash
SELECT * FROM Trash
List files from trash for a shared drive
Shows deleted items in Trash
SELECT * FROM Trash
WITH(
DriveType='drive'
,DriveId='1j0HFOP4gsoExxxxxx' --get id from select * from SharedDrives
)
list_deleted_files
endpoint belongs to
Trash
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 deleted files / folders
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM list_deleted_files';
EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];
Select from trash
Shows deleted items in Trash
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Trash';
EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];
List files from trash for a shared drive
Shows deleted items in Trash
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Trash
WITH(
DriveType=''drive''
,DriveId=''1j0HFOP4gsoExxxxxx'' --get id from select * from SharedDrives
)';
EXEC (@MyQuery) AT [LS_TO_GOOGLE_DRIVE_IN_GATEWAY];
list_deleted_files
endpoint belongs to
Trash
table(s), and can therefore be used via those table(s).