Google Drive Connector
Google Drive Connector Help
Version 7
ZappySys Logo File Version: v7
Supported Engine: 4

EndPoint Search items (i.e. files / folders)


Name

list_items

Description

Lists items (i.e. files / folders) with search criteria

Parameters

Parameter Label Required Options Description
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.
DriveType Drive Type YES
Option Value
My Drive user
Shared Drive drive
All Drives allDrives
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.
pageSize PageSize NO
SupportsAllDrives Supports all drives (e.g. My and Shared) NO
Option Value
true true
false false
Whether the requesting application supports both My Drives and shared drives.
IncludeItemsFromAllDrives Include items from all drives (e.g. My and Shared) NO
Option Value
true true
false false
Spaces Spaces to include in corpora (comma separed) NO
IncludePermissionsForView Include Permissions For View NO
Option Value
true true
false false
IncludeLabels Include Labels NO
Option Value
true true
false false
Query Search Criteria NO
Option Value
None
By name (exact name match) name='abc'
By name (contains sub string) name contains 'abc'
By name (does not contain) not name contains 'abc'
By text (search inside file) fullText contains 'abc'
By created time createdTime > '2012-06-04T12:00:00'
By modified time modifiedTime > '2012-06-04T12:00:00'
Allow only shared files and folders sharedWithMe=true
Exclude trashed files or folders trashed=false
Exclude Folders mimeType!='application/vnd.google-apps.folder'
Include files from trash mimeType!='application/vnd.google-apps.folder'
Exclude files from trash mimeType!='application/vnd.google-apps.folder' and trashed!=true
Exclude App Script mimeType!='application/vnd.google-apps.script'
Search for spreadsheet mimeType = 'application/vnd.google-apps.spreadsheet'
Search for multiple files type mimeType contains 'application/vnd.google-apps.spreadsheet' OR mimeType contains 'application/vnd.google-apps.document' OR mimeType contains 'application/vnd.google-apps.presentation' OR mimeType contains 'application/vnd.google-apps.drawing'
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 Help..]

Output Columns

Label DataType Length Raw Description
Id DT_WSTR 440 False
Kind DT_WSTR 200 False
Name DT_WSTR 780 False
MimeType DT_WSTR 650 False
CreatedTime DT_DBTIMESTAMP 0 False
ModifiedTime DT_DBTIMESTAMP 0 False
Size DT_WSTR 200 False
Version DT_WSTR 200 False
Shared DT_BOOL 0 False
Starred DT_BOOL 0 False
Trashed DT_BOOL 0 False
FileExtension DT_WSTR 200 False
DriveId DT_WSTR 500 False
CopyRequiresWriterPermission DT_BOOL 0 False
Md5Checksum DT_WSTR 500 False
WritersCanShare DT_BOOL 0 False
ViewedByMe DT_BOOL 0 False
Parents DT_WSTR 500 False
ThumbnailLink DT_WSTR 4000 False
IconLink DT_WSTR 1000 False
LastModifyingUserDisplayName DT_WSTR 500 False
LastModifyingUserKind DT_WSTR 100 False
LastModifyingUserMe DT_BOOL 0 False
LastModifyingUserPermissionId DT_WSTR 500 False
LastModifyingUserEmailAddress DT_WSTR 500 False
LastModifyingUserPhotoLink DT_WSTR 1000 False
Owners DT_WSTR 4000 False
HeadRevisionId DT_WSTR 1000 False
WebViewLink DT_WSTR 1000 False
WebContentLink DT_WSTR 1000 False
ViewersCanCopyContent DT_BOOL 0 False
Permissions DT_WSTR 4000 False
HasThumbnail DT_BOOL 0 False
Spaces DT_WSTR 500 False
ExplicitlyTrashed DT_BOOL 0 False
ModifiedByMeTime DT_DBTIMESTAMP 0 False
ViewedByMeTime DT_DBTIMESTAMP 0 False
QuotaBytesUsed DT_WSTR 50 False
OriginalFilename DT_WSTR 500 False
OwnedByMe DT_BOOL 0 False
FullFileExtension DT_WSTR 50 False
IsAppAuthorized DT_BOOL 0 False
CanChangeViewersCanCopyContent DT_BOOL 0 False
CanEdit DT_BOOL 0 False
CanCopy DT_BOOL 0 False
CanComment DT_BOOL 0 False
CanAddChildren DT_BOOL 0 False
CanDelete DT_BOOL 0 False
CanDownload DT_BOOL 0 False
CanListChildren DT_BOOL 0 False
CanRemoveChildren DT_BOOL 0 False
CanRename DT_BOOL 0 False
CanTrash DT_BOOL 0 False
CanReadRevisions DT_BOOL 0 False
CanChangeCopyRequiresWriterPermission DT_BOOL 0 False
CanMoveItemIntoTeamDrive DT_BOOL 0 False
CanUntrash DT_BOOL 0 False
CanModifyContent DT_BOOL 0 False
CanMoveItemOutOfDrive DT_BOOL 0 False
CanAddMyDriveParent DT_BOOL 0 False
CanRemoveMyDriveParent DT_BOOL 0 False
CanMoveItemWithinDrive DT_BOOL 0 False
CanShare DT_BOOL 0 False
CanMoveChildrenWithinDrive DT_BOOL 0 False
CanModifyContentRestriction DT_BOOL 0 False
CanChangeSecurityUpdateEnabled DT_BOOL 0 False
CanAcceptOwnership DT_BOOL 0 False
CanReadLabels DT_BOOL 0 False
CanModifyLabels DT_BOOL 0 False
CanModifyEditorContentRestriction DT_BOOL 0 False
CanModifyOwnerContentRestriction DT_BOOL 0 False
CanRemoveContentRestriction DT_BOOL 0 False
CanMoveChildrenOutOfDrive DT_BOOL 0 False
CanReadDrive DT_BOOL 0 False
CanReadTeamDrive DT_BOOL 0 False
CanMoveTeamDriveItem DT_BOOL 0 False
CanMoveItemWithinTeamDrive DT_BOOL 0 False
CanMoveItemOutOfTeamDrive DT_BOOL 0 False
CanDeleteChildren DT_BOOL 0 False
CanMoveChildrenOutOfTeamDrive DT_BOOL 0 False
CanMoveChildrenWithinTeamDrive DT_BOOL 0 False
CanTrashChildren DT_BOOL 0 False
CanAddFolderFromAnotherDrive DT_BOOL 0 False
ThumbnailVersion DT_WSTR 50 False
ModifiedByMe DT_BOOL 0 False
PermissionIds DT_WSTR 500 False
ImageMediaMetadataWidth DT_I4 0 False
ImageMediaMetadataHeight DT_I4 0 False
ImageMediaMetadataRotation DT_I4 0 False
LinkShareMetadataSecurityUpdateEligible DT_BOOL 0 False
LinkShareMetadataSecurityUpdateEnabled DT_BOOL 0 False
Sha1Checksum DT_WSTR 500 False
Sha256Checksum DT_WSTR 1000 False
HasAugmentedPermissions DT_BOOL 0 False

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.