EndPoint Search items (i.e. files / folders)
Parameters
Parameter | Label | Required | Options | Description | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DriveType | Drive Type | YES |
|
Default search context is User's drive. Bodies of items (files/documents) to which the query applies. Supported bodies are 'user', 'domain', 'drive', and 'allDrives'. Prefer 'user' or 'drive' to 'allDrives' for efficiency. By default, corpora is set to 'user'. However, this can change depending on the filter set through the 'Query' parameter. | ||||||||||||||||||||||||||||||||||||
DriveId | Shared DriveId | NO | By default file lists from MyDrive but if you like to search other Shared drive (formally known as Team drive) then set this parameter. | |||||||||||||||||||||||||||||||||||||
pageSize | PageSize | NO | ||||||||||||||||||||||||||||||||||||||
SupportsAllDrives | Supports all drives (e.g. My and Shared) | NO |
|
Whether the requesting application supports both My Drives and shared drives. | ||||||||||||||||||||||||||||||||||||
IncludeItemsFromAllDrives | Include items from all drives (e.g. My and Shared) | NO |
|
|||||||||||||||||||||||||||||||||||||
Spaces | Spaces to include in corpora (comma separed) | NO | ||||||||||||||||||||||||||||||||||||||
IncludePermissionsForView | Include Permissions For View | NO |
|
|||||||||||||||||||||||||||||||||||||
IncludeLabels | Include Labels | NO |
|
|||||||||||||||||||||||||||||||||||||
Query | Search Criteria | NO |
|
Data filter (e.g. somecolumn -eq 'somevalue' ) , User can select multiple filter criteria using 'AND','OR' operator , Note*:- please refer the link for more filter criteria : https://zappysys.com/links?url=https://developers.google.com/drive/api/guides/search-files [API reference] |
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:
Search items (i.e. files / folders) using API Source
Google Drive
Search items (i.e. files / folders)

Search items (i.e. files / folders) using API Destination
Google Drive
Search items (i.e. files / folders)

ODBC application
Use these SQL queries in your ODBC application data source:
Get items list using query
Gets items list using query
SELECT Id, Kind, Name, MimeType
FROM list_items
WITH (Query = 'name contains ''.txt''')
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get items list using query
Gets items list using query
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT Id, Kind, Name, MimeType
FROM list_items
WITH (Query = ''name contains ''''.txt'''''')';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_GOOGLE_DRIVE_IN_DATA_GATEWAY];