files

Creates, updates, deletes, gets or lists a files resource.

Overview

Name	`files`
Type	Resource
Id	`googleworkspace.drivev2.files`

Fields

The following fields are returned by SELECT queries:

get
list

Name	Datatype	Description
`id`	`string`	The ID of the file.
`alternateLink`	`string`	Output only. A link for opening the file in a relevant Google editor or viewer.
`appDataContents`	`boolean`	Output only. Whether this file is in the Application Data folder.
`canComment`	`boolean`	Output only. Deprecated: Use `capabilities/canComment` instead.
`canReadRevisions`	`boolean`	Output only. Deprecated: Use `capabilities/canReadRevisions` instead.
`capabilities`	`object`	Output only. Capabilities the current user has on this file. Each capability corresponds to a fine-grained action that a user may take.
`clientEncryptionDetails`	`object`	Client Side Encryption related details. Contains details about the encryption state of the file and details regarding the encryption mechanism that clients need to use when decrypting the contents of this item. This will only be present on files and not on folders or shortcuts. (id: ClientEncryptionDetails)
`contentRestrictions`	`array`	Restrictions for accessing the content of the file. Only populated if such a restriction exists.
`copyRequiresWriterPermission`	`boolean`	Whether the options to copy, print, or download this file, should be disabled for readers and commenters.
`copyable`	`boolean`	Output only. Deprecated: Use `capabilities/canCopy` instead.
`createdDate`	`string (date-time)`	Create time for this file (formatted RFC 3339 timestamp).
`defaultOpenWithLink`	`string`	Output only. A link to open this file with the user's default app for this file. Only populated when the drive.apps.readonly scope is used.
`description`	`string`	A short description of the file.
`downloadUrl`	`string`	Output only. Short lived download URL for the file. This field is only populated for files with content stored in Google Drive; it is not populated for Google Docs or shortcut files.
`driveId`	`string`	Output only. ID of the shared drive the file resides in. Only populated for items in shared drives.
`editable`	`boolean`	Output only. Deprecated: Use `capabilities/canEdit` instead.
`embedLink`	`string`	Output only. A link for embedding the file.
`etag`	`string`	Output only. ETag of the file.
`explicitlyTrashed`	`boolean`	Output only. Whether this file has been explicitly trashed, as opposed to recursively trashed.
`exportLinks`	`object`	Output only. Links for exporting Docs Editors files to specific formats.
`fileExtension`	`string`	Output only. The final component of `fullFileExtension` with trailing text that does not appear to be part of the extension removed. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`fileSize`	`string (int64)`	Output only. Size in bytes of blobs and first party editor files. Won't be populated for files that have no size, like shortcuts and folders.
`folderColorRgb`	`string`	Folder color as an RGB hex string if the file is a folder or a shortcut to a folder. The list of supported colors is available in the folderColorPalette field of the About resource. If an unsupported color is specified, it will be changed to the closest color in the palette.
`fullFileExtension`	`string`	Output only. The full file extension; extracted from the title. May contain multiple concatenated extensions, such as "tar.gz". Removing an extension from the title does not clear this field; however, changing the extension on the title does update this field. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`hasAugmentedPermissions`	`boolean`	Output only. Whether there are permissions directly on this file. This field is only populated for items in shared drives.
`hasThumbnail`	`boolean`	Output only. Whether this file has a thumbnail. This does not indicate whether the requesting app has access to the thumbnail. To check access, look for the presence of the thumbnailLink field.
`headRevisionId`	`string`	Output only. The ID of the file's head revision. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`iconLink`	`string`	Output only. A link to the file's icon.
`imageMediaMetadata`	`object`	Output only. Metadata about image media. This will only be present for image types, and its contents will depend on what can be parsed from the image content.
`indexableText`	`object`	Indexable text attributes for the file (can only be written)
`inheritedPermissionsDisabled`	`boolean`	Whether this file has inherited permissions disabled. Inherited permissions are enabled by default.
`isAppAuthorized`	`boolean`	Output only. Whether the file was created or opened by the requesting app.
`kind`	`string`	Output only. The type of file. This is always `drive#file`. (default: drive#file)
`labelInfo`	`object`	Output only. An overview of the labels on the file.
`labels`	`object`	A group of labels for the file.
`lastModifyingUser`	`object`	Information about a Drive user. (id: User)
`lastModifyingUserName`	`string`	Output only. Name of the last user to modify this file.
`lastViewedByMeDate`	`string (date-time)`	Last time this file was viewed by the user (formatted RFC 3339 timestamp).
`linkShareMetadata`	`object`	Contains details about the link URLs that clients are using to refer to this item.
`markedViewedByMeDate`	`string (date-time)`	Deprecated.
`md5Checksum`	`string`	Output only. An MD5 checksum for the content of this file. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`mimeType`	`string`	The MIME type of the file. This is only mutable on update when uploading new content. This field can be left blank, and the mimetype will be determined from the uploaded content's MIME type.
`modifiedByMeDate`	`string (date-time)`	Last time this file was modified by the user (formatted RFC 3339 timestamp). Note that setting modifiedDate will also update the modifiedByMe date for the user which set the date.
`modifiedDate`	`string (date-time)`	Last time this file was modified by anyone (formatted RFC 3339 timestamp). This is only mutable on update when the setModifiedDate parameter is set.
`openWithLinks`	`object`	Output only. A map of the id of each of the user's apps to a link to open this file with that app. Only populated when the drive.apps.readonly scope is used.
`originalFilename`	`string`	The original filename of the uploaded content if available, or else the original value of the `title` field. This is only available for files with binary content in Google Drive.
`ownedByMe`	`boolean`	Output only. Whether the file is owned by the current user. Not populated for items in shared drives.
`ownerNames`	`array`	Output only. Name(s) of the owner(s) of this file. Not populated for items in shared drives.
`owners`	`array`	Output only. The owner of this file. Only certain legacy files may have more than one owner. This field isn't populated for items in shared drives.
`parents`	`array`	The ID of the parent folder containing the file. A file can only have one parent folder; specifying multiple parents isn't supported. If not specified as part of an insert request, the file is placed directly in the user's My Drive folder. If not specified as part of a copy request, the file inherits any discoverable parent of the source file. Update requests must use the `addParents` and `removeParents` parameters to modify the parents list.
`permissionIds`	`array`	Output only. List of permission IDs for users with access to this file.
`permissions`	`array`	Output only. The list of permissions for users with access to this file. Not populated for items in shared drives.
`properties`	`array`	The list of properties.
`quotaBytesUsed`	`string (int64)`	Output only. The number of quota bytes used by this file.
`resourceKey`	`string`	Output only. A key needed to access the item via a shared link.
`selfLink`	`string`	Output only. A link back to this file.
`sha1Checksum`	`string`	Output only. The SHA1 checksum associated with this file, if available. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`sha256Checksum`	`string`	Output only. The SHA256 checksum associated with this file, if available. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`shareable`	`boolean`	Output only. Deprecated: Use `capabilities/canShare` instead.
`shared`	`boolean`	Output only. Whether the file has been shared. Not populated for items in shared drives.
`sharedWithMeDate`	`string (date-time)`	Time at which this file was shared with the user (formatted RFC 3339 timestamp).
`sharingUser`	`object`	Information about a Drive user. (id: User)
`shortcutDetails`	`object`	Shortcut file details. Only populated for shortcut files, which have the mimeType field set to `application/vnd.google-apps.shortcut`. Can only be set on `files.insert` requests.
`spaces`	`array`	Output only. The list of spaces which contain the file. Supported values are `drive`, `appDataFolder` and `photos`.
`teamDriveId`	`string`	Output only. Deprecated: Use `driveId` instead.
`thumbnail`	`object`	A thumbnail for the file. This will only be used if a standard thumbnail cannot be generated.
`thumbnailLink`	`string`	Output only. A short-lived link to the file's thumbnail, if available. Typically lasts on the order of hours. Not intended for direct usage on web applications due to Cross-Origin Resource Sharing (CORS), consider using a proxy server. Only populated when the requesting app can access the file's content. If the file isn't shared publicly, the URL returned in `Files.thumbnailLink` must be fetched using a credentialed request.
`thumbnailVersion`	`string (int64)`	Output only. The thumbnail version for use in thumbnail cache invalidation.
`title`	`string`	The title of this file. Note that for immutable items such as the top level folders of shared drives, My Drive root folder, and Application Data folder the title is constant.
`trashedDate`	`string (date-time)`	The time that the item was trashed (formatted RFC 3339 timestamp). Only populated for items in shared drives.
`trashingUser`	`object`	Information about a Drive user. (id: User)
`userPermission`	`object`	Output only. The permissions for the authenticated user on this file. (id: Permission)
`version`	`string (int64)`	Output only. A monotonically increasing version number for the file. This reflects every change made to the file on the server, even those not visible to the requesting user.
`videoMediaMetadata`	`object`	Output only. Metadata about video media. This will only be present for video types.
`webContentLink`	`string`	Output only. A link for downloading the content of the file in a browser using cookie based authentication. In cases where the content is shared publicly, the content can be downloaded without any credentials.
`webViewLink`	`string`	Output only. A link only available on public folders for viewing their static web assets (HTML, CSS, JS, etc) via Google Drive's Website Hosting.
`writersCanShare`	`boolean`	Whether writers can share the document with other users. Not populated for items in shared drives.

Name	Datatype	Description
`id`	`string`	The ID of the file.
`alternateLink`	`string`	Output only. A link for opening the file in a relevant Google editor or viewer.
`appDataContents`	`boolean`	Output only. Whether this file is in the Application Data folder.
`canComment`	`boolean`	Output only. Deprecated: Use `capabilities/canComment` instead.
`canReadRevisions`	`boolean`	Output only. Deprecated: Use `capabilities/canReadRevisions` instead.
`capabilities`	`object`	Output only. Capabilities the current user has on this file. Each capability corresponds to a fine-grained action that a user may take.
`clientEncryptionDetails`	`object`	Client Side Encryption related details. Contains details about the encryption state of the file and details regarding the encryption mechanism that clients need to use when decrypting the contents of this item. This will only be present on files and not on folders or shortcuts. (id: ClientEncryptionDetails)
`contentRestrictions`	`array`	Restrictions for accessing the content of the file. Only populated if such a restriction exists.
`copyRequiresWriterPermission`	`boolean`	Whether the options to copy, print, or download this file, should be disabled for readers and commenters.
`copyable`	`boolean`	Output only. Deprecated: Use `capabilities/canCopy` instead.
`createdDate`	`string (date-time)`	Create time for this file (formatted RFC 3339 timestamp).
`defaultOpenWithLink`	`string`	Output only. A link to open this file with the user's default app for this file. Only populated when the drive.apps.readonly scope is used.
`description`	`string`	A short description of the file.
`downloadUrl`	`string`	Output only. Short lived download URL for the file. This field is only populated for files with content stored in Google Drive; it is not populated for Google Docs or shortcut files.
`driveId`	`string`	Output only. ID of the shared drive the file resides in. Only populated for items in shared drives.
`editable`	`boolean`	Output only. Deprecated: Use `capabilities/canEdit` instead.
`embedLink`	`string`	Output only. A link for embedding the file.
`etag`	`string`	Output only. ETag of the file.
`explicitlyTrashed`	`boolean`	Output only. Whether this file has been explicitly trashed, as opposed to recursively trashed.
`exportLinks`	`object`	Output only. Links for exporting Docs Editors files to specific formats.
`fileExtension`	`string`	Output only. The final component of `fullFileExtension` with trailing text that does not appear to be part of the extension removed. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`fileSize`	`string (int64)`	Output only. Size in bytes of blobs and first party editor files. Won't be populated for files that have no size, like shortcuts and folders.
`folderColorRgb`	`string`	Folder color as an RGB hex string if the file is a folder or a shortcut to a folder. The list of supported colors is available in the folderColorPalette field of the About resource. If an unsupported color is specified, it will be changed to the closest color in the palette.
`fullFileExtension`	`string`	Output only. The full file extension; extracted from the title. May contain multiple concatenated extensions, such as "tar.gz". Removing an extension from the title does not clear this field; however, changing the extension on the title does update this field. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`hasAugmentedPermissions`	`boolean`	Output only. Whether there are permissions directly on this file. This field is only populated for items in shared drives.
`hasThumbnail`	`boolean`	Output only. Whether this file has a thumbnail. This does not indicate whether the requesting app has access to the thumbnail. To check access, look for the presence of the thumbnailLink field.
`headRevisionId`	`string`	Output only. The ID of the file's head revision. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`iconLink`	`string`	Output only. A link to the file's icon.
`imageMediaMetadata`	`object`	Output only. Metadata about image media. This will only be present for image types, and its contents will depend on what can be parsed from the image content.
`indexableText`	`object`	Indexable text attributes for the file (can only be written)
`inheritedPermissionsDisabled`	`boolean`	Whether this file has inherited permissions disabled. Inherited permissions are enabled by default.
`isAppAuthorized`	`boolean`	Output only. Whether the file was created or opened by the requesting app.
`kind`	`string`	Output only. The type of file. This is always `drive#file`. (default: drive#file)
`labelInfo`	`object`	Output only. An overview of the labels on the file.
`labels`	`object`	A group of labels for the file.
`lastModifyingUser`	`object`	Information about a Drive user. (id: User)
`lastModifyingUserName`	`string`	Output only. Name of the last user to modify this file.
`lastViewedByMeDate`	`string (date-time)`	Last time this file was viewed by the user (formatted RFC 3339 timestamp).
`linkShareMetadata`	`object`	Contains details about the link URLs that clients are using to refer to this item.
`markedViewedByMeDate`	`string (date-time)`	Deprecated.
`md5Checksum`	`string`	Output only. An MD5 checksum for the content of this file. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`mimeType`	`string`	The MIME type of the file. This is only mutable on update when uploading new content. This field can be left blank, and the mimetype will be determined from the uploaded content's MIME type.
`modifiedByMeDate`	`string (date-time)`	Last time this file was modified by the user (formatted RFC 3339 timestamp). Note that setting modifiedDate will also update the modifiedByMe date for the user which set the date.
`modifiedDate`	`string (date-time)`	Last time this file was modified by anyone (formatted RFC 3339 timestamp). This is only mutable on update when the setModifiedDate parameter is set.
`openWithLinks`	`object`	Output only. A map of the id of each of the user's apps to a link to open this file with that app. Only populated when the drive.apps.readonly scope is used.
`originalFilename`	`string`	The original filename of the uploaded content if available, or else the original value of the `title` field. This is only available for files with binary content in Google Drive.
`ownedByMe`	`boolean`	Output only. Whether the file is owned by the current user. Not populated for items in shared drives.
`ownerNames`	`array`	Output only. Name(s) of the owner(s) of this file. Not populated for items in shared drives.
`owners`	`array`	Output only. The owner of this file. Only certain legacy files may have more than one owner. This field isn't populated for items in shared drives.
`parents`	`array`	The ID of the parent folder containing the file. A file can only have one parent folder; specifying multiple parents isn't supported. If not specified as part of an insert request, the file is placed directly in the user's My Drive folder. If not specified as part of a copy request, the file inherits any discoverable parent of the source file. Update requests must use the `addParents` and `removeParents` parameters to modify the parents list.
`permissionIds`	`array`	Output only. List of permission IDs for users with access to this file.
`permissions`	`array`	Output only. The list of permissions for users with access to this file. Not populated for items in shared drives.
`properties`	`array`	The list of properties.
`quotaBytesUsed`	`string (int64)`	Output only. The number of quota bytes used by this file.
`resourceKey`	`string`	Output only. A key needed to access the item via a shared link.
`selfLink`	`string`	Output only. A link back to this file.
`sha1Checksum`	`string`	Output only. The SHA1 checksum associated with this file, if available. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`sha256Checksum`	`string`	Output only. The SHA256 checksum associated with this file, if available. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
`shareable`	`boolean`	Output only. Deprecated: Use `capabilities/canShare` instead.
`shared`	`boolean`	Output only. Whether the file has been shared. Not populated for items in shared drives.
`sharedWithMeDate`	`string (date-time)`	Time at which this file was shared with the user (formatted RFC 3339 timestamp).
`sharingUser`	`object`	Information about a Drive user. (id: User)
`shortcutDetails`	`object`	Shortcut file details. Only populated for shortcut files, which have the mimeType field set to `application/vnd.google-apps.shortcut`. Can only be set on `files.insert` requests.
`spaces`	`array`	Output only. The list of spaces which contain the file. Supported values are `drive`, `appDataFolder` and `photos`.
`teamDriveId`	`string`	Output only. Deprecated: Use `driveId` instead.
`thumbnail`	`object`	A thumbnail for the file. This will only be used if a standard thumbnail cannot be generated.
`thumbnailLink`	`string`	Output only. A short-lived link to the file's thumbnail, if available. Typically lasts on the order of hours. Not intended for direct usage on web applications due to Cross-Origin Resource Sharing (CORS), consider using a proxy server. Only populated when the requesting app can access the file's content. If the file isn't shared publicly, the URL returned in `Files.thumbnailLink` must be fetched using a credentialed request.
`thumbnailVersion`	`string (int64)`	Output only. The thumbnail version for use in thumbnail cache invalidation.
`title`	`string`	The title of this file. Note that for immutable items such as the top level folders of shared drives, My Drive root folder, and Application Data folder the title is constant.
`trashedDate`	`string (date-time)`	The time that the item was trashed (formatted RFC 3339 timestamp). Only populated for items in shared drives.
`trashingUser`	`object`	Information about a Drive user. (id: User)
`userPermission`	`object`	Output only. The permissions for the authenticated user on this file. (id: Permission)
`version`	`string (int64)`	Output only. A monotonically increasing version number for the file. This reflects every change made to the file on the server, even those not visible to the requesting user.
`videoMediaMetadata`	`object`	Output only. Metadata about video media. This will only be present for video types.
`webContentLink`	`string`	Output only. A link for downloading the content of the file in a browser using cookie based authentication. In cases where the content is shared publicly, the content can be downloaded without any credentials.
`webViewLink`	`string`	Output only. A link only available on public folders for viewing their static web assets (HTML, CSS, JS, etc) via Google Drive's Website Hosting.
`writersCanShare`	`boolean`	Whether writers can share the document with other users. Not populated for items in shared drives.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
`get`	`select`	`fileId`	`revisionId`, `includeLabels`, `projection`, `supportsTeamDrives`, `includePermissionsForView`, `supportsAllDrives`, `updateViewedDate`, `acknowledgeAbuse`	Gets a file's metadata or content by ID. If you provide the URL parameter `alt=media`, then the response includes the file contents in the response body. Downloading content with `alt=media` only works if the file is stored in Drive. To download Google Docs, Sheets, and Slides use `files.export` instead. For more information, see Download & export files.
`list`	`select`		`corpus`, `pageToken`, `driveId`, `q`, `includeTeamDriveItems`, `includeLabels`, `corpora`, `includeItemsFromAllDrives`, `teamDriveId`, `projection`, `supportsTeamDrives`, `includePermissionsForView`, `orderBy`, `supportsAllDrives`, `spaces`, `maxResults`	Lists the user's files. For more information, see Search for files and folders. This method accepts the `q` parameter, which is a search query combining one or more search terms. This method returns all files by default, including trashed files. If you don't want trashed files to appear in the list, use the `trashed=false` query parameter to remove trashed files from the results.
`insert`	`insert`		`timedTextLanguage`, `supportsAllDrives`, `ocrLanguage`, `timedTextTrackName`, `includeLabels`, `ocr`, `supportsTeamDrives`, `useContentAsIndexableText`, `includePermissionsForView`, `visibility`, `convert`, `enforceSingleParent`, `pinned`	Inserts a new file. This method supports an /upload URI and accepts uploaded media with the following characteristics: - Maximum file size: 5,120 GB - Accepted Media MIME types:`/` Note: Specify a valid MIME type, rather than the literal `/` value. The literal `/` is only used to indicate that any valid MIME type can be uploaded. For more information on uploading files, see Upload file data. Apps creating shortcuts with `files.insert` must specify the MIME type `application/vnd.google-apps.shortcut`. Apps should specify a file extension in the `title` property when inserting files with the API. For example, an operation to insert a JPEG file should specify something like `"title": "cat.jpg"` in the metadata. Subsequent `GET` requests include the read-only `fileExtension` property populated with the extension originally specified in the `title` property. When a Google Drive user requests to download a file, or when the file is downloaded through the sync client, Drive builds a full filename (with extension) based on the title. In cases where the extension is missing, Drive attempts to determine the extension based on the file's MIME type.
`patch`	`update`	`fileId`	`convert`, `setModifiedDate`, `addParents`, `enforceSingleParent`, `newRevision`, `updateViewedDate`, `removeParents`, `pinned`, `timedTextTrackName`, `supportsAllDrives`, `modifiedDateBehavior`, `ocrLanguage`, `timedTextLanguage`, `supportsTeamDrives`, `useContentAsIndexableText`, `includePermissionsForView`, `ocr`, `includeLabels`	Updates a file's metadata and/or content. When calling this method, only populate fields in the request that you want to modify. When updating fields, some fields might change automatically, such as modifiedDate. This method supports patch semantics.
`update`	`replace`	`fileId`	`supportsTeamDrives`, `useContentAsIndexableText`, `includePermissionsForView`, `includeLabels`, `ocr`, `timedTextTrackName`, `timedTextLanguage`, `modifiedDateBehavior`, `ocrLanguage`, `supportsAllDrives`, `removeParents`, `pinned`, `addParents`, `enforceSingleParent`, `convert`, `setModifiedDate`, `updateViewedDate`, `newRevision`	Updates a file's metadata, content, or both. When calling this method, only populate fields in the request that you want to modify. When updating fields, some fields might be changed automatically, such as `modifiedDate`. This method supports patch semantics. This method supports an /upload URI and accepts uploaded media with the following characteristics: - Maximum file size: 5,120 GB - Accepted Media MIME types: `/` (Specify a valid MIME type, rather than the literal `/` value. The literal `/` is only used to indicate that any valid MIME type can be uploaded. For more information, see Google Workspace and Google Drive supported MIME types.) For more information on uploading files, see Upload file data.
`delete`	`delete`	`fileId`	`supportsAllDrives`, `supportsTeamDrives`, `enforceSingleParent`	Permanently deletes a file owned by the user without moving it to the trash. If the file belongs to a shared drive, the user must be an `organizer` on the parent folder. If the target is a folder, all descendants owned by the user are also deleted.
`trash`	`exec`	`fileId`	`supportsTeamDrives`, `includePermissionsForView`, `includeLabels`, `supportsAllDrives`	Moves a file to the trash. The currently authenticated user must own the file or be at least a `fileOrganizer` on the parent for shared drive files.
`copy`	`exec`	`fileId`	`timedTextTrackName`, `timedTextLanguage`, `supportsAllDrives`, `ocrLanguage`, `supportsTeamDrives`, `includePermissionsForView`, `includeLabels`, `ocr`, `convert`, `enforceSingleParent`, `visibility`, `pinned`	Creates a copy of the specified file.
`modify_labels`	`exec`	`fileId`		Modifies the set of labels applied to a file. Returns a list of the labels that were added or modified.
`empty_trash`	`exec`		`enforceSingleParent`, `driveId`	Permanently deletes all of the user's trashed files.
`generate_ids`	`exec`		`type`, `maxResults`, `space`	Generates a set of file IDs which can be provided in insert or copy requests.
`generate_cse_token`	`exec`		`parent`, `fileId`	Generates a CSE token which can be used to create or update CSE files.
`untrash`	`exec`	`fileId`	`supportsAllDrives`, `includeLabels`, `supportsTeamDrives`, `includePermissionsForView`	Restores a file from the trash. The currently authenticated user must own the file or be at least a `fileOrganizer` on the parent for shared drive files.
`watch`	`exec`	`fileId`	`updateViewedDate`, `supportsAllDrives`, `acknowledgeAbuse`, `revisionId`, `includeLabels`, `supportsTeamDrives`, `includePermissionsForView`, `projection`	Subscribes to changes to a file.
`export`	`exec`	`fileId`, `mimeType`		Exports a Google Workspace document to the requested MIME type and returns exported byte content. Note that the exported content is limited to 10MB.
`touch`	`exec`	`fileId`	`includeLabels`, `supportsAllDrives`, `supportsTeamDrives`, `includePermissionsForView`	Set the file's updated time to the current server time.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
`fileId`	`string`
`mimeType`	`string`
`acknowledgeAbuse`	`boolean`
`addParents`	`string`
`convert`	`boolean`
`corpora`	`string`
`corpus`	`string`
`driveId`	`string`
`enforceSingleParent`	`boolean`
`fileId`	`string`
`includeItemsFromAllDrives`	`boolean`
`includeLabels`	`string`
`includePermissionsForView`	`string`
`includeTeamDriveItems`	`boolean`
`maxResults`	`integer (int32)`
`modifiedDateBehavior`	`string`
`newRevision`	`boolean`
`ocr`	`boolean`
`ocrLanguage`	`string`
`orderBy`	`string`
`pageToken`	`string`
`parent`	`string`
`pinned`	`boolean`
`projection`	`string`
`q`	`string`
`removeParents`	`string`
`revisionId`	`string`
`setModifiedDate`	`boolean`
`space`	`string`
`spaces`	`string`
`supportsAllDrives`	`boolean`
`supportsTeamDrives`	`boolean`
`teamDriveId`	`string`
`timedTextLanguage`	`string`
`timedTextTrackName`	`string`
`type`	`string`
`updateViewedDate`	`boolean`
`useContentAsIndexableText`	`boolean`
`visibility`	`string`

`SELECT` examples

get
list

Gets a file's metadata or content by ID. If you provide the URL parameter alt=media, then the response includes the file contents in the response body. Downloading content with alt=media only works if the file is stored in Drive. To download Google Docs, Sheets, and Slides use files.export instead. For more information, see Download & export files.

SELECT
id,
alternateLink,
appDataContents,
canComment,
canReadRevisions,
capabilities,
clientEncryptionDetails,
contentRestrictions,
copyRequiresWriterPermission,
copyable,
createdDate,
defaultOpenWithLink,
description,
downloadUrl,
driveId,
editable,
embedLink,
etag,
explicitlyTrashed,
exportLinks,
fileExtension,
fileSize,
folderColorRgb,
fullFileExtension,
hasAugmentedPermissions,
hasThumbnail,
headRevisionId,
iconLink,
imageMediaMetadata,
indexableText,
inheritedPermissionsDisabled,
isAppAuthorized,
kind,
labelInfo,
labels,
lastModifyingUser,
lastModifyingUserName,
lastViewedByMeDate,
linkShareMetadata,
markedViewedByMeDate,
md5Checksum,
mimeType,
modifiedByMeDate,
modifiedDate,
openWithLinks,
originalFilename,
ownedByMe,
ownerNames,
owners,
parents,
permissionIds,
permissions,
properties,
quotaBytesUsed,
resourceKey,
selfLink,
sha1Checksum,
sha256Checksum,
shareable,
shared,
sharedWithMeDate,
sharingUser,
shortcutDetails,
spaces,
teamDriveId,
thumbnail,
thumbnailLink,
thumbnailVersion,
title,
trashedDate,
trashingUser,
userPermission,
version,
videoMediaMetadata,
webContentLink,
webViewLink,
writersCanShare
FROM googleworkspace.drivev2.files
WHERE fileId = '{{ fileId }}' -- required
AND revisionId = '{{ revisionId }}'
AND includeLabels = '{{ includeLabels }}'
AND projection = '{{ projection }}'
AND supportsTeamDrives = '{{ supportsTeamDrives }}'
AND includePermissionsForView = '{{ includePermissionsForView }}'
AND supportsAllDrives = '{{ supportsAllDrives }}'
AND updateViewedDate = '{{ updateViewedDate }}'
AND acknowledgeAbuse = '{{ acknowledgeAbuse }}'
;

Lists the user's files. For more information, see Search for files and folders. This method accepts the q parameter, which is a search query combining one or more search terms. This method returns all files by default, including trashed files. If you don't want trashed files to appear in the list, use the trashed=false query parameter to remove trashed files from the results.

SELECT
id,
alternateLink,
appDataContents,
canComment,
canReadRevisions,
capabilities,
clientEncryptionDetails,
contentRestrictions,
copyRequiresWriterPermission,
copyable,
createdDate,
defaultOpenWithLink,
description,
downloadUrl,
driveId,
editable,
embedLink,
etag,
explicitlyTrashed,
exportLinks,
fileExtension,
fileSize,
folderColorRgb,
fullFileExtension,
hasAugmentedPermissions,
hasThumbnail,
headRevisionId,
iconLink,
imageMediaMetadata,
indexableText,
inheritedPermissionsDisabled,
isAppAuthorized,
kind,
labelInfo,
labels,
lastModifyingUser,
lastModifyingUserName,
lastViewedByMeDate,
linkShareMetadata,
markedViewedByMeDate,
md5Checksum,
mimeType,
modifiedByMeDate,
modifiedDate,
openWithLinks,
originalFilename,
ownedByMe,
ownerNames,
owners,
parents,
permissionIds,
permissions,
properties,
quotaBytesUsed,
resourceKey,
selfLink,
sha1Checksum,
sha256Checksum,
shareable,
shared,
sharedWithMeDate,
sharingUser,
shortcutDetails,
spaces,
teamDriveId,
thumbnail,
thumbnailLink,
thumbnailVersion,
title,
trashedDate,
trashingUser,
userPermission,
version,
videoMediaMetadata,
webContentLink,
webViewLink,
writersCanShare
FROM googleworkspace.drivev2.files
WHERE corpus = '{{ corpus }}'
AND pageToken = '{{ pageToken }}'
AND driveId = '{{ driveId }}'
AND q = '{{ q }}'
AND includeTeamDriveItems = '{{ includeTeamDriveItems }}'
AND includeLabels = '{{ includeLabels }}'
AND corpora = '{{ corpora }}'
AND includeItemsFromAllDrives = '{{ includeItemsFromAllDrives }}'
AND teamDriveId = '{{ teamDriveId }}'
AND projection = '{{ projection }}'
AND supportsTeamDrives = '{{ supportsTeamDrives }}'
AND includePermissionsForView = '{{ includePermissionsForView }}'
AND orderBy = '{{ orderBy }}'
AND supportsAllDrives = '{{ supportsAllDrives }}'
AND spaces = '{{ spaces }}'
AND maxResults = '{{ maxResults }}'
;

`INSERT` examples

insert
Manifest

Inserts a new file. This method supports an /upload URI and accepts uploaded media with the following characteristics: - Maximum file size: 5,120 GB - Accepted Media MIME types:*/* Note: Specify a valid MIME type, rather than the literal */* value. The literal */* is only used to indicate that any valid MIME type can be uploaded. For more information on uploading files, see Upload file data. Apps creating shortcuts with files.insert must specify the MIME type application/vnd.google-apps.shortcut. Apps should specify a file extension in the title property when inserting files with the API. For example, an operation to insert a JPEG file should specify something like "title": "cat.jpg" in the metadata. Subsequent GET requests include the read-only fileExtension property populated with the extension originally specified in the title property. When a Google Drive user requests to download a file, or when the file is downloaded through the sync client, Drive builds a full filename (with extension) based on the title. In cases where the extension is missing, Drive attempts to determine the extension based on the file's MIME type.

INSERT INTO googleworkspace.drivev2.files (
data__trashedDate,
data__explicitlyTrashed,
data__thumbnail,
data__driveId,
data__webViewLink,
data__ownerNames,
data__alternateLink,
data__modifiedDate,
data__shareable,
data__markedViewedByMeDate,
data__shortcutDetails,
data__webContentLink,
data__thumbnailLink,
data__createdDate,
data__imageMediaMetadata,
data__etag,
data__copyRequiresWriterPermission,
data__inheritedPermissionsDisabled,
data__id,
data__sha256Checksum,
data__quotaBytesUsed,
data__userPermission,
data__defaultOpenWithLink,
data__md5Checksum,
data__downloadUrl,
data__spaces,
data__permissions,
data__hasAugmentedPermissions,
data__version,
data__owners,
data__videoMediaMetadata,
data__iconLink,
data__properties,
data__description,
data__lastViewedByMeDate,
data__shared,
data__labels,
data__lastModifyingUserName,
data__folderColorRgb,
data__modifiedByMeDate,
data__clientEncryptionDetails,
data__selfLink,
data__sha1Checksum,
data__appDataContents,
data__sharedWithMeDate,
data__title,
data__canReadRevisions,
data__headRevisionId,
data__fullFileExtension,
data__originalFilename,
data__openWithLinks,
data__canComment,
data__editable,
data__ownedByMe,
data__thumbnailVersion,
data__permissionIds,
data__resourceKey,
data__kind,
data__fileExtension,
data__writersCanShare,
data__labelInfo,
data__parents,
data__contentRestrictions,
data__isAppAuthorized,
data__hasThumbnail,
data__trashingUser,
data__linkShareMetadata,
data__indexableText,
data__embedLink,
data__sharingUser,
data__capabilities,
data__copyable,
data__fileSize,
data__teamDriveId,
data__mimeType,
data__lastModifyingUser,
timedTextLanguage,
supportsAllDrives,
ocrLanguage,
timedTextTrackName,
includeLabels,
ocr,
supportsTeamDrives,
useContentAsIndexableText,
includePermissionsForView,
visibility,
convert,
enforceSingleParent,
pinned
)
SELECT 
'{{ trashedDate }}',
{{ explicitlyTrashed }},
'{{ thumbnail }}',
'{{ driveId }}',
'{{ webViewLink }}',
'{{ ownerNames }}',
'{{ alternateLink }}',
'{{ modifiedDate }}',
{{ shareable }},
'{{ markedViewedByMeDate }}',
'{{ shortcutDetails }}',
'{{ webContentLink }}',
'{{ thumbnailLink }}',
'{{ createdDate }}',
'{{ imageMediaMetadata }}',
'{{ etag }}',
{{ copyRequiresWriterPermission }},
{{ inheritedPermissionsDisabled }},
'{{ id }}',
'{{ sha256Checksum }}',
'{{ quotaBytesUsed }}',
'{{ userPermission }}',
'{{ defaultOpenWithLink }}',
'{{ md5Checksum }}',
'{{ downloadUrl }}',
'{{ spaces }}',
'{{ permissions }}',
{{ hasAugmentedPermissions }},
'{{ version }}',
'{{ owners }}',
'{{ videoMediaMetadata }}',
'{{ iconLink }}',
'{{ properties }}',
'{{ description }}',
'{{ lastViewedByMeDate }}',
{{ shared }},
'{{ labels }}',
'{{ lastModifyingUserName }}',
'{{ folderColorRgb }}',
'{{ modifiedByMeDate }}',
'{{ clientEncryptionDetails }}',
'{{ selfLink }}',
'{{ sha1Checksum }}',
{{ appDataContents }},
'{{ sharedWithMeDate }}',
'{{ title }}',
{{ canReadRevisions }},
'{{ headRevisionId }}',
'{{ fullFileExtension }}',
'{{ originalFilename }}',
'{{ openWithLinks }}',
{{ canComment }},
{{ editable }},
{{ ownedByMe }},
'{{ thumbnailVersion }}',
'{{ permissionIds }}',
'{{ resourceKey }}',
'{{ kind }}',
'{{ fileExtension }}',
{{ writersCanShare }},
'{{ labelInfo }}',
'{{ parents }}',
'{{ contentRestrictions }}',
{{ isAppAuthorized }},
{{ hasThumbnail }},
'{{ trashingUser }}',
'{{ linkShareMetadata }}',
'{{ indexableText }}',
'{{ embedLink }}',
'{{ sharingUser }}',
'{{ capabilities }}',
{{ copyable }},
'{{ fileSize }}',
'{{ teamDriveId }}',
'{{ mimeType }}',
'{{ lastModifyingUser }}',
'{{ timedTextLanguage }}',
'{{ supportsAllDrives }}',
'{{ ocrLanguage }}',
'{{ timedTextTrackName }}',
'{{ includeLabels }}',
'{{ ocr }}',
'{{ supportsTeamDrives }}',
'{{ useContentAsIndexableText }}',
'{{ includePermissionsForView }}',
'{{ visibility }}',
'{{ convert }}',
'{{ enforceSingleParent }}',
'{{ pinned }}'
RETURNING
id,
alternateLink,
appDataContents,
canComment,
canReadRevisions,
capabilities,
clientEncryptionDetails,
contentRestrictions,
copyRequiresWriterPermission,
copyable,
createdDate,
defaultOpenWithLink,
description,
downloadUrl,
driveId,
editable,
embedLink,
etag,
explicitlyTrashed,
exportLinks,
fileExtension,
fileSize,
folderColorRgb,
fullFileExtension,
hasAugmentedPermissions,
hasThumbnail,
headRevisionId,
iconLink,
imageMediaMetadata,
indexableText,
inheritedPermissionsDisabled,
isAppAuthorized,
kind,
labelInfo,
labels,
lastModifyingUser,
lastModifyingUserName,
lastViewedByMeDate,
linkShareMetadata,
markedViewedByMeDate,
md5Checksum,
mimeType,
modifiedByMeDate,
modifiedDate,
openWithLinks,
originalFilename,
ownedByMe,
ownerNames,
owners,
parents,
permissionIds,
permissions,
properties,
quotaBytesUsed,
resourceKey,
selfLink,
sha1Checksum,
sha256Checksum,
shareable,
shared,
sharedWithMeDate,
sharingUser,
shortcutDetails,
spaces,
teamDriveId,
thumbnail,
thumbnailLink,
thumbnailVersion,
title,
trashedDate,
trashingUser,
userPermission,
version,
videoMediaMetadata,
webContentLink,
webViewLink,
writersCanShare
;

# Description fields are for documentation purposes
- name: files
props:
  - name: trashedDate
    value: "{{ trashedDate }}"
    description: |
      The time that the item was trashed (formatted RFC 3339 timestamp). Only populated for items in shared drives.
  - name: explicitlyTrashed
    value: {{ explicitlyTrashed }}
    description: |
      Output only. Whether this file has been explicitly trashed, as opposed to recursively trashed.
  - name: thumbnail
    description: |
      A thumbnail for the file. This will only be used if a standard thumbnail cannot be generated.
    value:
      mimeType: "{{ mimeType }}"
      image: "{{ image }}"
  - name: driveId
    value: "{{ driveId }}"
    description: |
      Output only. ID of the shared drive the file resides in. Only populated for items in shared drives.
  - name: webViewLink
    value: "{{ webViewLink }}"
    description: |
      Output only. A link only available on public folders for viewing their static web assets (HTML, CSS, JS, etc) via Google Drive's Website Hosting.
  - name: ownerNames
    value:
      - "{{ ownerNames }}"
    description: |
      Output only. Name(s) of the owner(s) of this file. Not populated for items in shared drives.
  - name: alternateLink
    value: "{{ alternateLink }}"
    description: |
      Output only. A link for opening the file in a relevant Google editor or viewer.
  - name: modifiedDate
    value: "{{ modifiedDate }}"
    description: |
      Last time this file was modified by anyone (formatted RFC 3339 timestamp). This is only mutable on update when the setModifiedDate parameter is set.
  - name: shareable
    value: {{ shareable }}
    description: |
      Output only. Deprecated: Use `capabilities/canShare` instead.
  - name: markedViewedByMeDate
    value: "{{ markedViewedByMeDate }}"
    description: |
      Deprecated.
  - name: shortcutDetails
    description: |
      Shortcut file details. Only populated for shortcut files, which have the mimeType field set to `application/vnd.google-apps.shortcut`. Can only be set on `files.insert` requests.
    value:
      targetMimeType: "{{ targetMimeType }}"
      targetId: "{{ targetId }}"
      targetResourceKey: "{{ targetResourceKey }}"
  - name: webContentLink
    value: "{{ webContentLink }}"
    description: |
      Output only. A link for downloading the content of the file in a browser using cookie based authentication. In cases where the content is shared publicly, the content can be downloaded without any credentials.
  - name: thumbnailLink
    value: "{{ thumbnailLink }}"
    description: |
      Output only. A short-lived link to the file's thumbnail, if available. Typically lasts on the order of hours. Not intended for direct usage on web applications due to [Cross-Origin Resource Sharing (CORS)](https://developer.mozilla.org/en-US/docs/Web/HTTP/CORS), consider using a proxy server. Only populated when the requesting app can access the file's content. If the file isn't shared publicly, the URL returned in `Files.thumbnailLink` must be fetched using a credentialed request.
  - name: createdDate
    value: "{{ createdDate }}"
    description: |
      Create time for this file (formatted RFC 3339 timestamp).
  - name: imageMediaMetadata
    description: |
      Output only. Metadata about image media. This will only be present for image types, and its contents will depend on what can be parsed from the image content.
    value:
      maxApertureValue: {{ maxApertureValue }}
      cameraMake: "{{ cameraMake }}"
      height: {{ height }}
      exposureTime: {{ exposureTime }}
      aperture: {{ aperture }}
      meteringMode: "{{ meteringMode }}"
      date: "{{ date }}"
      cameraModel: "{{ cameraModel }}"
      exposureBias: {{ exposureBias }}
      exposureMode: "{{ exposureMode }}"
      colorSpace: "{{ colorSpace }}"
      focalLength: {{ focalLength }}
      isoSpeed: {{ isoSpeed }}
      subjectDistance: {{ subjectDistance }}
      whiteBalance: "{{ whiteBalance }}"
      rotation: {{ rotation }}
      location:
        latitude: {{ latitude }}
        altitude: {{ altitude }}
        longitude: {{ longitude }}
      sensor: "{{ sensor }}"
      width: {{ width }}
      lens: "{{ lens }}"
      flashUsed: {{ flashUsed }}
  - name: etag
    value: "{{ etag }}"
    description: |
      Output only. ETag of the file.
  - name: copyRequiresWriterPermission
    value: {{ copyRequiresWriterPermission }}
    description: |
      Whether the options to copy, print, or download this file, should be disabled for readers and commenters.
  - name: inheritedPermissionsDisabled
    value: {{ inheritedPermissionsDisabled }}
    description: |
      Whether this file has inherited permissions disabled. Inherited permissions are enabled by default.
  - name: id
    value: "{{ id }}"
    description: |
      The ID of the file.
  - name: sha256Checksum
    value: "{{ sha256Checksum }}"
    description: |
      Output only. The SHA256 checksum associated with this file, if available. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
  - name: quotaBytesUsed
    value: "{{ quotaBytesUsed }}"
    description: |
      Output only. The number of quota bytes used by this file.
  - name: userPermission
    description: |
      Output only. The permissions for the authenticated user on this file.
    value:
      selfLink: "{{ selfLink }}"
      permissionDetails:
        - additionalRoles: "{{ additionalRoles }}"
          role: "{{ role }}"
          inheritedFrom: "{{ inheritedFrom }}"
          inherited: {{ inherited }}
          permissionType: "{{ permissionType }}"
      etag: "{{ etag }}"
      deleted: {{ deleted }}
      additionalRoles:
        - "{{ additionalRoles }}"
      photoLink: "{{ photoLink }}"
      inheritedPermissionsDisabled: {{ inheritedPermissionsDisabled }}
      id: "{{ id }}"
      kind: "{{ kind }}"
      expirationDate: "{{ expirationDate }}"
      withLink: {{ withLink }}
      emailAddress: "{{ emailAddress }}"
      type: "{{ type }}"
      value: "{{ value }}"
      domain: "{{ domain }}"
      teamDrivePermissionDetails:
        - teamDrivePermissionType: "{{ teamDrivePermissionType }}"
          role: "{{ role }}"
          inheritedFrom: "{{ inheritedFrom }}"
          inherited: {{ inherited }}
          additionalRoles: "{{ additionalRoles }}"
      pendingOwner: {{ pendingOwner }}
      view: "{{ view }}"
      name: "{{ name }}"
      authKey: "{{ authKey }}"
      role: "{{ role }}"
  - name: defaultOpenWithLink
    value: "{{ defaultOpenWithLink }}"
    description: |
      Output only. A link to open this file with the user's default app for this file. Only populated when the drive.apps.readonly scope is used.
  - name: md5Checksum
    value: "{{ md5Checksum }}"
    description: |
      Output only. An MD5 checksum for the content of this file. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
  - name: downloadUrl
    value: "{{ downloadUrl }}"
    description: |
      Output only. Short lived download URL for the file. This field is only populated for files with content stored in Google Drive; it is not populated for Google Docs or shortcut files.
  - name: spaces
    value:
      - "{{ spaces }}"
    description: |
      Output only. The list of spaces which contain the file. Supported values are `drive`, `appDataFolder` and `photos`.
  - name: permissions
    description: |
      Output only. The list of permissions for users with access to this file. Not populated for items in shared drives.
    value:
      - selfLink: "{{ selfLink }}"
        permissionDetails: "{{ permissionDetails }}"
        etag: "{{ etag }}"
        deleted: {{ deleted }}
        additionalRoles: "{{ additionalRoles }}"
        photoLink: "{{ photoLink }}"
        inheritedPermissionsDisabled: {{ inheritedPermissionsDisabled }}
        id: "{{ id }}"
        kind: "{{ kind }}"
        expirationDate: "{{ expirationDate }}"
        withLink: {{ withLink }}
        emailAddress: "{{ emailAddress }}"
        type: "{{ type }}"
        value: "{{ value }}"
        domain: "{{ domain }}"
        teamDrivePermissionDetails: "{{ teamDrivePermissionDetails }}"
        pendingOwner: {{ pendingOwner }}
        view: "{{ view }}"
        name: "{{ name }}"
        authKey: "{{ authKey }}"
        role: "{{ role }}"
  - name: hasAugmentedPermissions
    value: {{ hasAugmentedPermissions }}
    description: |
      Output only. Whether there are permissions directly on this file. This field is only populated for items in shared drives.
  - name: version
    value: "{{ version }}"
    description: |
      Output only. A monotonically increasing version number for the file. This reflects every change made to the file on the server, even those not visible to the requesting user.
  - name: owners
    description: |
      Output only. The owner of this file. Only certain legacy files may have more than one owner. This field isn't populated for items in shared drives.
    value:
      - permissionId: "{{ permissionId }}"
        picture:
          url: "{{ url }}"
        kind: "{{ kind }}"
        emailAddress: "{{ emailAddress }}"
        displayName: "{{ displayName }}"
        isAuthenticatedUser: {{ isAuthenticatedUser }}
  - name: videoMediaMetadata
    description: |
      Output only. Metadata about video media. This will only be present for video types.
    value:
      durationMillis: "{{ durationMillis }}"
      width: {{ width }}
      height: {{ height }}
  - name: iconLink
    value: "{{ iconLink }}"
    description: |
      Output only. A link to the file's icon.
  - name: properties
    description: |
      The list of properties.
    value:
      - kind: "{{ kind }}"
        selfLink: "{{ selfLink }}"
        visibility: "{{ visibility }}"
        key: "{{ key }}"
        value: "{{ value }}"
        etag: "{{ etag }}"
  - name: description
    value: "{{ description }}"
    description: |
      A short description of the file.
  - name: lastViewedByMeDate
    value: "{{ lastViewedByMeDate }}"
    description: |
      Last time this file was viewed by the user (formatted RFC 3339 timestamp).
  - name: shared
    value: {{ shared }}
    description: |
      Output only. Whether the file has been shared. Not populated for items in shared drives.
  - name: labels
    description: |
      A group of labels for the file.
    value:
      starred: {{ starred }}
      viewed: {{ viewed }}
      modified: {{ modified }}
      trashed: {{ trashed }}
      restricted: {{ restricted }}
      hidden: {{ hidden }}
  - name: lastModifyingUserName
    value: "{{ lastModifyingUserName }}"
    description: |
      Output only. Name of the last user to modify this file.
  - name: folderColorRgb
    value: "{{ folderColorRgb }}"
    description: |
      Folder color as an RGB hex string if the file is a folder or a shortcut to a folder. The list of supported colors is available in the folderColorPalette field of the About resource. If an unsupported color is specified, it will be changed to the closest color in the palette.
  - name: modifiedByMeDate
    value: "{{ modifiedByMeDate }}"
    description: |
      Last time this file was modified by the user (formatted RFC 3339 timestamp). Note that setting modifiedDate will also update the modifiedByMe date for the user which set the date.
  - name: clientEncryptionDetails
    description: |
      Client Side Encryption related details. Contains details about the encryption state of the file and details regarding the encryption mechanism that clients need to use when decrypting the contents of this item. This will only be present on files and not on folders or shortcuts.
    value:
      encryptionState: "{{ encryptionState }}"
      decryptionMetadata:
        kaclsName: "{{ kaclsName }}"
        encryptionResourceKeyHash: "{{ encryptionResourceKeyHash }}"
        wrappedKey: "{{ wrappedKey }}"
        aes256GcmChunkSize: "{{ aes256GcmChunkSize }}"
        keyFormat: "{{ keyFormat }}"
        kaclsId: "{{ kaclsId }}"
        jwt: "{{ jwt }}"
  - name: selfLink
    value: "{{ selfLink }}"
    description: |
      Output only. A link back to this file.
  - name: sha1Checksum
    value: "{{ sha1Checksum }}"
    description: |
      Output only. The SHA1 checksum associated with this file, if available. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
  - name: appDataContents
    value: {{ appDataContents }}
    description: |
      Output only. Whether this file is in the Application Data folder.
  - name: sharedWithMeDate
    value: "{{ sharedWithMeDate }}"
    description: |
      Time at which this file was shared with the user (formatted RFC 3339 timestamp).
  - name: title
    value: "{{ title }}"
    description: |
      The title of this file. Note that for immutable items such as the top level folders of shared drives, My Drive root folder, and Application Data folder the title is constant.
  - name: canReadRevisions
    value: {{ canReadRevisions }}
    description: |
      Output only. Deprecated: Use `capabilities/canReadRevisions` instead.
  - name: headRevisionId
    value: "{{ headRevisionId }}"
    description: |
      Output only. The ID of the file's head revision. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
  - name: fullFileExtension
    value: "{{ fullFileExtension }}"
    description: |
      Output only. The full file extension; extracted from the title. May contain multiple concatenated extensions, such as "tar.gz". Removing an extension from the title does not clear this field; however, changing the extension on the title does update this field. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
  - name: originalFilename
    value: "{{ originalFilename }}"
    description: |
      The original filename of the uploaded content if available, or else the original value of the `title` field. This is only available for files with binary content in Google Drive.
  - name: openWithLinks
    value: "{{ openWithLinks }}"
    description: |
      Output only. A map of the id of each of the user's apps to a link to open this file with that app. Only populated when the drive.apps.readonly scope is used.
  - name: canComment
    value: {{ canComment }}
    description: |
      Output only. Deprecated: Use `capabilities/canComment` instead.
  - name: editable
    value: {{ editable }}
    description: |
      Output only. Deprecated: Use `capabilities/canEdit` instead.
  - name: ownedByMe
    value: {{ ownedByMe }}
    description: |
      Output only. Whether the file is owned by the current user. Not populated for items in shared drives.
  - name: thumbnailVersion
    value: "{{ thumbnailVersion }}"
    description: |
      Output only. The thumbnail version for use in thumbnail cache invalidation.
  - name: permissionIds
    value:
      - "{{ permissionIds }}"
    description: |
      Output only. List of permission IDs for users with access to this file.
  - name: resourceKey
    value: "{{ resourceKey }}"
    description: |
      Output only. A key needed to access the item via a shared link.
  - name: kind
    value: "{{ kind }}"
    description: |
      Output only. The type of file. This is always `drive#file`.
    default: drive#file
  - name: fileExtension
    value: "{{ fileExtension }}"
    description: |
      Output only. The final component of `fullFileExtension` with trailing text that does not appear to be part of the extension removed. This field is only populated for files with content stored in Google Drive; it is not populated for Docs Editors or shortcut files.
  - name: writersCanShare
    value: {{ writersCanShare }}
    description: |
      Whether writers can share the document with other users. Not populated for items in shared drives.
  - name: labelInfo
    description: |
      Output only. An overview of the labels on the file.
    value:
      labels:
        - id: "{{ id }}"
          kind: "{{ kind }}"
          fields: "{{ fields }}"
          revisionId: "{{ revisionId }}"
  - name: parents
    description: |
      The ID of the parent folder containing the file. A file can only have one parent folder; specifying multiple parents isn't supported. If not specified as part of an insert request, the file is placed directly in the user's My Drive folder. If not specified as part of a copy request, the file inherits any discoverable parent of the source file. Update requests must use the `addParents` and `removeParents` parameters to modify the parents list.
    value:
      - kind: "{{ kind }}"
        parentLink: "{{ parentLink }}"
        selfLink: "{{ selfLink }}"
        id: "{{ id }}"
        isRoot: {{ isRoot }}
  - name: contentRestrictions
    description: |
      Restrictions for accessing the content of the file. Only populated if such a restriction exists.
    value:
      - reason: "{{ reason }}"
        restrictingUser:
          permissionId: "{{ permissionId }}"
          picture:
            url: "{{ url }}"
          kind: "{{ kind }}"
          emailAddress: "{{ emailAddress }}"
          displayName: "{{ displayName }}"
          isAuthenticatedUser: {{ isAuthenticatedUser }}
        type: "{{ type }}"
        ownerRestricted: {{ ownerRestricted }}
        systemRestricted: {{ systemRestricted }}
        readOnly: {{ readOnly }}
        restrictionDate: "{{ restrictionDate }}"
  - name: isAppAuthorized
    value: {{ isAppAuthorized }}
    description: |
      Output only. Whether the file was created or opened by the requesting app.
  - name: hasThumbnail
    value: {{ hasThumbnail }}
    description: |
      Output only. Whether this file has a thumbnail. This does not indicate whether the requesting app has access to the thumbnail. To check access, look for the presence of the thumbnailLink field.
  - name: trashingUser
    description: |
      Information about a Drive user.
    value:
      permissionId: "{{ permissionId }}"
      picture:
        url: "{{ url }}"
      kind: "{{ kind }}"
      emailAddress: "{{ emailAddress }}"
      displayName: "{{ displayName }}"
      isAuthenticatedUser: {{ isAuthenticatedUser }}
  - name: linkShareMetadata
    description: |
      Contains details about the link URLs that clients are using to refer to this item.
    value:
      securityUpdateEnabled: {{ securityUpdateEnabled }}
      securityUpdateEligible: {{ securityUpdateEligible }}
  - name: indexableText
    description: |
      Indexable text attributes for the file (can only be written)
    value:
      text: "{{ text }}"
  - name: embedLink
    value: "{{ embedLink }}"
    description: |
      Output only. A link for embedding the file.
  - name: sharingUser
    description: |
      Information about a Drive user.
    value:
      permissionId: "{{ permissionId }}"
      picture:
        url: "{{ url }}"
      kind: "{{ kind }}"
      emailAddress: "{{ emailAddress }}"
      displayName: "{{ displayName }}"
      isAuthenticatedUser: {{ isAuthenticatedUser }}
  - name: capabilities
    description: |
      Output only. Capabilities the current user has on this file. Each capability corresponds to a fine-grained action that a user may take.
    value:
      canModifyEditorContentRestriction: {{ canModifyEditorContentRestriction }}
      canRemoveContentRestriction: {{ canRemoveContentRestriction }}
      canTrash: {{ canTrash }}
      canShare: {{ canShare }}
      canRemoveMyDriveParent: {{ canRemoveMyDriveParent }}
      canChangeCopyRequiresWriterPermission: {{ canChangeCopyRequiresWriterPermission }}
      canDelete: {{ canDelete }}
      canReadRevisions: {{ canReadRevisions }}
      canMoveItemWithinTeamDrive: {{ canMoveItemWithinTeamDrive }}
      canUntrash: {{ canUntrash }}
      canMoveItemOutOfDrive: {{ canMoveItemOutOfDrive }}
      canEdit: {{ canEdit }}
      canMoveItemWithinDrive: {{ canMoveItemWithinDrive }}
      canDeleteChildren: {{ canDeleteChildren }}
      canListChildren: {{ canListChildren }}
      canModifyLabels: {{ canModifyLabels }}
      canMoveItemIntoTeamDrive: {{ canMoveItemIntoTeamDrive }}
      canDisableInheritedPermissions: {{ canDisableInheritedPermissions }}
      canModifyContent: {{ canModifyContent }}
      canMoveTeamDriveItem: {{ canMoveTeamDriveItem }}
      canEnableInheritedPermissions: {{ canEnableInheritedPermissions }}
      canMoveChildrenOutOfTeamDrive: {{ canMoveChildrenOutOfTeamDrive }}
      canMoveChildrenOutOfDrive: {{ canMoveChildrenOutOfDrive }}
      canModifyContentRestriction: {{ canModifyContentRestriction }}
      canAddChildren: {{ canAddChildren }}
      canRemoveChildren: {{ canRemoveChildren }}
      canComment: {{ canComment }}
      canModifyOwnerContentRestriction: {{ canModifyOwnerContentRestriction }}
      canReadLabels: {{ canReadLabels }}
      canChangeSecurityUpdateEnabled: {{ canChangeSecurityUpdateEnabled }}
      canAddFolderFromAnotherDrive: {{ canAddFolderFromAnotherDrive }}
      canCopy: {{ canCopy }}
      canMoveChildrenWithinTeamDrive: {{ canMoveChildrenWithinTeamDrive }}
      canAcceptOwnership: {{ canAcceptOwnership }}
      canReadDrive: {{ canReadDrive }}
      canRename: {{ canRename }}
      canMoveChildrenWithinDrive: {{ canMoveChildrenWithinDrive }}
      canReadTeamDrive: {{ canReadTeamDrive }}
      canDownload: {{ canDownload }}
      canTrashChildren: {{ canTrashChildren }}
      canAddMyDriveParent: {{ canAddMyDriveParent }}
      canChangeRestrictedDownload: {{ canChangeRestrictedDownload }}
      canMoveItemOutOfTeamDrive: {{ canMoveItemOutOfTeamDrive }}
  - name: copyable
    value: {{ copyable }}
    description: |
      Output only. Deprecated: Use `capabilities/canCopy` instead.
  - name: fileSize
    value: "{{ fileSize }}"
    description: |
      Output only. Size in bytes of blobs and first party editor files. Won't be populated for files that have no size, like shortcuts and folders.
  - name: teamDriveId
    value: "{{ teamDriveId }}"
    description: |
      Output only. Deprecated: Use `driveId` instead.
  - name: mimeType
    value: "{{ mimeType }}"
    description: |
      The MIME type of the file. This is only mutable on update when uploading new content. This field can be left blank, and the mimetype will be determined from the uploaded content's MIME type.
  - name: lastModifyingUser
    description: |
      Information about a Drive user.
    value:
      permissionId: "{{ permissionId }}"
      picture:
        url: "{{ url }}"
      kind: "{{ kind }}"
      emailAddress: "{{ emailAddress }}"
      displayName: "{{ displayName }}"
      isAuthenticatedUser: {{ isAuthenticatedUser }}
  - name: timedTextLanguage
    value: "{{ timedTextLanguage }}"
  - name: supportsAllDrives
    value: {{ supportsAllDrives }}
  - name: ocrLanguage
    value: "{{ ocrLanguage }}"
  - name: timedTextTrackName
    value: "{{ timedTextTrackName }}"
  - name: includeLabels
    value: "{{ includeLabels }}"
  - name: ocr
    value: {{ ocr }}
  - name: supportsTeamDrives
    value: {{ supportsTeamDrives }}
  - name: useContentAsIndexableText
    value: {{ useContentAsIndexableText }}
  - name: includePermissionsForView
    value: "{{ includePermissionsForView }}"
  - name: visibility
    value: "{{ visibility }}"
  - name: convert
    value: {{ convert }}
  - name: enforceSingleParent
    value: {{ enforceSingleParent }}
  - name: pinned
    value: {{ pinned }}

`UPDATE` examples

patch

Updates a file's metadata and/or content. When calling this method, only populate fields in the request that you want to modify. When updating fields, some fields might change automatically, such as modifiedDate. This method supports patch semantics.

UPDATE googleworkspace.drivev2.files
SET 
data__trashedDate = '{{ trashedDate }}',
data__explicitlyTrashed = {{ explicitlyTrashed }},
data__thumbnail = '{{ thumbnail }}',
data__driveId = '{{ driveId }}',
data__webViewLink = '{{ webViewLink }}',
data__ownerNames = '{{ ownerNames }}',
data__alternateLink = '{{ alternateLink }}',
data__modifiedDate = '{{ modifiedDate }}',
data__shareable = {{ shareable }},
data__markedViewedByMeDate = '{{ markedViewedByMeDate }}',
data__shortcutDetails = '{{ shortcutDetails }}',
data__webContentLink = '{{ webContentLink }}',
data__thumbnailLink = '{{ thumbnailLink }}',
data__createdDate = '{{ createdDate }}',
data__imageMediaMetadata = '{{ imageMediaMetadata }}',
data__etag = '{{ etag }}',
data__copyRequiresWriterPermission = {{ copyRequiresWriterPermission }},
data__inheritedPermissionsDisabled = {{ inheritedPermissionsDisabled }},
data__id = '{{ id }}',
data__sha256Checksum = '{{ sha256Checksum }}',
data__quotaBytesUsed = '{{ quotaBytesUsed }}',
data__userPermission = '{{ userPermission }}',
data__defaultOpenWithLink = '{{ defaultOpenWithLink }}',
data__md5Checksum = '{{ md5Checksum }}',
data__downloadUrl = '{{ downloadUrl }}',
data__spaces = '{{ spaces }}',
data__permissions = '{{ permissions }}',
data__hasAugmentedPermissions = {{ hasAugmentedPermissions }},
data__version = '{{ version }}',
data__owners = '{{ owners }}',
data__videoMediaMetadata = '{{ videoMediaMetadata }}',
data__iconLink = '{{ iconLink }}',
data__properties = '{{ properties }}',
data__description = '{{ description }}',
data__lastViewedByMeDate = '{{ lastViewedByMeDate }}',
data__shared = {{ shared }},
data__labels = '{{ labels }}',
data__lastModifyingUserName = '{{ lastModifyingUserName }}',
data__folderColorRgb = '{{ folderColorRgb }}',
data__modifiedByMeDate = '{{ modifiedByMeDate }}',
data__clientEncryptionDetails = '{{ clientEncryptionDetails }}',
data__selfLink = '{{ selfLink }}',
data__sha1Checksum = '{{ sha1Checksum }}',
data__appDataContents = {{ appDataContents }},
data__sharedWithMeDate = '{{ sharedWithMeDate }}',
data__title = '{{ title }}',
data__canReadRevisions = {{ canReadRevisions }},
data__headRevisionId = '{{ headRevisionId }}',
data__fullFileExtension = '{{ fullFileExtension }}',
data__originalFilename = '{{ originalFilename }}',
data__openWithLinks = '{{ openWithLinks }}',
data__canComment = {{ canComment }},
data__editable = {{ editable }},
data__ownedByMe = {{ ownedByMe }},
data__thumbnailVersion = '{{ thumbnailVersion }}',
data__permissionIds = '{{ permissionIds }}',
data__resourceKey = '{{ resourceKey }}',
data__kind = '{{ kind }}',
data__fileExtension = '{{ fileExtension }}',
data__writersCanShare = {{ writersCanShare }},
data__labelInfo = '{{ labelInfo }}',
data__parents = '{{ parents }}',
data__contentRestrictions = '{{ contentRestrictions }}',
data__isAppAuthorized = {{ isAppAuthorized }},
data__hasThumbnail = {{ hasThumbnail }},
data__trashingUser = '{{ trashingUser }}',
data__linkShareMetadata = '{{ linkShareMetadata }}',
data__indexableText = '{{ indexableText }}',
data__embedLink = '{{ embedLink }}',
data__sharingUser = '{{ sharingUser }}',
data__capabilities = '{{ capabilities }}',
data__copyable = {{ copyable }},
data__fileSize = '{{ fileSize }}',
data__teamDriveId = '{{ teamDriveId }}',
data__mimeType = '{{ mimeType }}',
data__lastModifyingUser = '{{ lastModifyingUser }}'
WHERE 
fileId = '{{ fileId }}' --required
AND convert = {{ convert}}
AND setModifiedDate = {{ setModifiedDate}}
AND addParents = '{{ addParents}}'
AND enforceSingleParent = {{ enforceSingleParent}}
AND newRevision = {{ newRevision}}
AND updateViewedDate = {{ updateViewedDate}}
AND removeParents = '{{ removeParents}}'
AND pinned = {{ pinned}}
AND timedTextTrackName = '{{ timedTextTrackName}}'
AND supportsAllDrives = {{ supportsAllDrives}}
AND modifiedDateBehavior = '{{ modifiedDateBehavior}}'
AND ocrLanguage = '{{ ocrLanguage}}'
AND timedTextLanguage = '{{ timedTextLanguage}}'
AND supportsTeamDrives = {{ supportsTeamDrives}}
AND useContentAsIndexableText = {{ useContentAsIndexableText}}
AND includePermissionsForView = '{{ includePermissionsForView}}'
AND ocr = {{ ocr}}
AND includeLabels = '{{ includeLabels}}'
RETURNING
id,
alternateLink,
appDataContents,
canComment,
canReadRevisions,
capabilities,
clientEncryptionDetails,
contentRestrictions,
copyRequiresWriterPermission,
copyable,
createdDate,
defaultOpenWithLink,
description,
downloadUrl,
driveId,
editable,
embedLink,
etag,
explicitlyTrashed,
exportLinks,
fileExtension,
fileSize,
folderColorRgb,
fullFileExtension,
hasAugmentedPermissions,
hasThumbnail,
headRevisionId,
iconLink,
imageMediaMetadata,
indexableText,
inheritedPermissionsDisabled,
isAppAuthorized,
kind,
labelInfo,
labels,
lastModifyingUser,
lastModifyingUserName,
lastViewedByMeDate,
linkShareMetadata,
markedViewedByMeDate,
md5Checksum,
mimeType,
modifiedByMeDate,
modifiedDate,
openWithLinks,
originalFilename,
ownedByMe,
ownerNames,
owners,
parents,
permissionIds,
permissions,
properties,
quotaBytesUsed,
resourceKey,
selfLink,
sha1Checksum,
sha256Checksum,
shareable,
shared,
sharedWithMeDate,
sharingUser,
shortcutDetails,
spaces,
teamDriveId,
thumbnail,
thumbnailLink,
thumbnailVersion,
title,
trashedDate,
trashingUser,
userPermission,
version,
videoMediaMetadata,
webContentLink,
webViewLink,
writersCanShare;

`REPLACE` examples

update

Updates a file's metadata, content, or both. When calling this method, only populate fields in the request that you want to modify. When updating fields, some fields might be changed automatically, such as modifiedDate. This method supports patch semantics. This method supports an /upload URI and accepts uploaded media with the following characteristics: - Maximum file size: 5,120 GB - Accepted Media MIME types: */* (Specify a valid MIME type, rather than the literal */* value. The literal */* is only used to indicate that any valid MIME type can be uploaded. For more information, see Google Workspace and Google Drive supported MIME types.) For more information on uploading files, see Upload file data.

REPLACE googleworkspace.drivev2.files
SET 
data__trashedDate = '{{ trashedDate }}',
data__explicitlyTrashed = {{ explicitlyTrashed }},
data__thumbnail = '{{ thumbnail }}',
data__driveId = '{{ driveId }}',
data__webViewLink = '{{ webViewLink }}',
data__ownerNames = '{{ ownerNames }}',
data__alternateLink = '{{ alternateLink }}',
data__modifiedDate = '{{ modifiedDate }}',
data__shareable = {{ shareable }},
data__markedViewedByMeDate = '{{ markedViewedByMeDate }}',
data__shortcutDetails = '{{ shortcutDetails }}',
data__webContentLink = '{{ webContentLink }}',
data__thumbnailLink = '{{ thumbnailLink }}',
data__createdDate = '{{ createdDate }}',
data__imageMediaMetadata = '{{ imageMediaMetadata }}',
data__etag = '{{ etag }}',
data__copyRequiresWriterPermission = {{ copyRequiresWriterPermission }},
data__inheritedPermissionsDisabled = {{ inheritedPermissionsDisabled }},
data__id = '{{ id }}',
data__sha256Checksum = '{{ sha256Checksum }}',
data__quotaBytesUsed = '{{ quotaBytesUsed }}',
data__userPermission = '{{ userPermission }}',
data__defaultOpenWithLink = '{{ defaultOpenWithLink }}',
data__md5Checksum = '{{ md5Checksum }}',
data__downloadUrl = '{{ downloadUrl }}',
data__spaces = '{{ spaces }}',
data__permissions = '{{ permissions }}',
data__hasAugmentedPermissions = {{ hasAugmentedPermissions }},
data__version = '{{ version }}',
data__owners = '{{ owners }}',
data__videoMediaMetadata = '{{ videoMediaMetadata }}',
data__iconLink = '{{ iconLink }}',
data__properties = '{{ properties }}',
data__description = '{{ description }}',
data__lastViewedByMeDate = '{{ lastViewedByMeDate }}',
data__shared = {{ shared }},
data__labels = '{{ labels }}',
data__lastModifyingUserName = '{{ lastModifyingUserName }}',
data__folderColorRgb = '{{ folderColorRgb }}',
data__modifiedByMeDate = '{{ modifiedByMeDate }}',
data__clientEncryptionDetails = '{{ clientEncryptionDetails }}',
data__selfLink = '{{ selfLink }}',
data__sha1Checksum = '{{ sha1Checksum }}',
data__appDataContents = {{ appDataContents }},
data__sharedWithMeDate = '{{ sharedWithMeDate }}',
data__title = '{{ title }}',
data__canReadRevisions = {{ canReadRevisions }},
data__headRevisionId = '{{ headRevisionId }}',
data__fullFileExtension = '{{ fullFileExtension }}',
data__originalFilename = '{{ originalFilename }}',
data__openWithLinks = '{{ openWithLinks }}',
data__canComment = {{ canComment }},
data__editable = {{ editable }},
data__ownedByMe = {{ ownedByMe }},
data__thumbnailVersion = '{{ thumbnailVersion }}',
data__permissionIds = '{{ permissionIds }}',
data__resourceKey = '{{ resourceKey }}',
data__kind = '{{ kind }}',
data__fileExtension = '{{ fileExtension }}',
data__writersCanShare = {{ writersCanShare }},
data__labelInfo = '{{ labelInfo }}',
data__parents = '{{ parents }}',
data__contentRestrictions = '{{ contentRestrictions }}',
data__isAppAuthorized = {{ isAppAuthorized }},
data__hasThumbnail = {{ hasThumbnail }},
data__trashingUser = '{{ trashingUser }}',
data__linkShareMetadata = '{{ linkShareMetadata }}',
data__indexableText = '{{ indexableText }}',
data__embedLink = '{{ embedLink }}',
data__sharingUser = '{{ sharingUser }}',
data__capabilities = '{{ capabilities }}',
data__copyable = {{ copyable }},
data__fileSize = '{{ fileSize }}',
data__teamDriveId = '{{ teamDriveId }}',
data__mimeType = '{{ mimeType }}',
data__lastModifyingUser = '{{ lastModifyingUser }}'
WHERE 
fileId = '{{ fileId }}' --required
AND supportsTeamDrives = {{ supportsTeamDrives}}
AND useContentAsIndexableText = {{ useContentAsIndexableText}}
AND includePermissionsForView = '{{ includePermissionsForView}}'
AND includeLabels = '{{ includeLabels}}'
AND ocr = {{ ocr}}
AND timedTextTrackName = '{{ timedTextTrackName}}'
AND timedTextLanguage = '{{ timedTextLanguage}}'
AND modifiedDateBehavior = '{{ modifiedDateBehavior}}'
AND ocrLanguage = '{{ ocrLanguage}}'
AND supportsAllDrives = {{ supportsAllDrives}}
AND removeParents = '{{ removeParents}}'
AND pinned = {{ pinned}}
AND addParents = '{{ addParents}}'
AND enforceSingleParent = {{ enforceSingleParent}}
AND convert = {{ convert}}
AND setModifiedDate = {{ setModifiedDate}}
AND updateViewedDate = {{ updateViewedDate}}
AND newRevision = {{ newRevision}}
RETURNING
id,
alternateLink,
appDataContents,
canComment,
canReadRevisions,
capabilities,
clientEncryptionDetails,
contentRestrictions,
copyRequiresWriterPermission,
copyable,
createdDate,
defaultOpenWithLink,
description,
downloadUrl,
driveId,
editable,
embedLink,
etag,
explicitlyTrashed,
exportLinks,
fileExtension,
fileSize,
folderColorRgb,
fullFileExtension,
hasAugmentedPermissions,
hasThumbnail,
headRevisionId,
iconLink,
imageMediaMetadata,
indexableText,
inheritedPermissionsDisabled,
isAppAuthorized,
kind,
labelInfo,
labels,
lastModifyingUser,
lastModifyingUserName,
lastViewedByMeDate,
linkShareMetadata,
markedViewedByMeDate,
md5Checksum,
mimeType,
modifiedByMeDate,
modifiedDate,
openWithLinks,
originalFilename,
ownedByMe,
ownerNames,
owners,
parents,
permissionIds,
permissions,
properties,
quotaBytesUsed,
resourceKey,
selfLink,
sha1Checksum,
sha256Checksum,
shareable,
shared,
sharedWithMeDate,
sharingUser,
shortcutDetails,
spaces,
teamDriveId,
thumbnail,
thumbnailLink,
thumbnailVersion,
title,
trashedDate,
trashingUser,
userPermission,
version,
videoMediaMetadata,
webContentLink,
webViewLink,
writersCanShare;

`DELETE` examples

delete

Permanently deletes a file owned by the user without moving it to the trash. If the file belongs to a shared drive, the user must be an organizer on the parent folder. If the target is a folder, all descendants owned by the user are also deleted.

DELETE FROM googleworkspace.drivev2.files
WHERE fileId = '{{ fileId }}' --required
AND supportsAllDrives = '{{ supportsAllDrives }}'
AND supportsTeamDrives = '{{ supportsTeamDrives }}'
AND enforceSingleParent = '{{ enforceSingleParent }}'
;

Lifecycle Methods

Moves a file to the trash. The currently authenticated user must own the file or be at least a fileOrganizer on the parent for shared drive files.

EXEC googleworkspace.drivev2.files.trash 
@fileId='{{ fileId }}' --required, 
@supportsTeamDrives={{ supportsTeamDrives }}, 
@includePermissionsForView='{{ includePermissionsForView }}', 
@includeLabels='{{ includeLabels }}', 
@supportsAllDrives={{ supportsAllDrives }}
;

Creates a copy of the specified file.

EXEC googleworkspace.drivev2.files.copy 
@fileId='{{ fileId }}' --required, 
@timedTextTrackName='{{ timedTextTrackName }}', 
@timedTextLanguage='{{ timedTextLanguage }}', 
@supportsAllDrives={{ supportsAllDrives }}, 
@ocrLanguage='{{ ocrLanguage }}', 
@supportsTeamDrives={{ supportsTeamDrives }}, 
@includePermissionsForView='{{ includePermissionsForView }}', 
@includeLabels='{{ includeLabels }}', 
@ocr={{ ocr }}, 
@convert={{ convert }}, 
@enforceSingleParent={{ enforceSingleParent }}, 
@visibility='{{ visibility }}', 
@pinned={{ pinned }} 
@@json=
'{
"trashedDate": "{{ trashedDate }}", 
"explicitlyTrashed": {{ explicitlyTrashed }}, 
"thumbnail": "{{ thumbnail }}", 
"driveId": "{{ driveId }}", 
"webViewLink": "{{ webViewLink }}", 
"ownerNames": "{{ ownerNames }}", 
"alternateLink": "{{ alternateLink }}", 
"modifiedDate": "{{ modifiedDate }}", 
"shareable": {{ shareable }}, 
"markedViewedByMeDate": "{{ markedViewedByMeDate }}", 
"shortcutDetails": "{{ shortcutDetails }}", 
"webContentLink": "{{ webContentLink }}", 
"thumbnailLink": "{{ thumbnailLink }}", 
"createdDate": "{{ createdDate }}", 
"imageMediaMetadata": "{{ imageMediaMetadata }}", 
"etag": "{{ etag }}", 
"copyRequiresWriterPermission": {{ copyRequiresWriterPermission }}, 
"inheritedPermissionsDisabled": {{ inheritedPermissionsDisabled }}, 
"id": "{{ id }}", 
"sha256Checksum": "{{ sha256Checksum }}", 
"quotaBytesUsed": "{{ quotaBytesUsed }}", 
"userPermission": "{{ userPermission }}", 
"defaultOpenWithLink": "{{ defaultOpenWithLink }}", 
"md5Checksum": "{{ md5Checksum }}", 
"downloadUrl": "{{ downloadUrl }}", 
"spaces": "{{ spaces }}", 
"permissions": "{{ permissions }}", 
"hasAugmentedPermissions": {{ hasAugmentedPermissions }}, 
"version": "{{ version }}", 
"owners": "{{ owners }}", 
"videoMediaMetadata": "{{ videoMediaMetadata }}", 
"iconLink": "{{ iconLink }}", 
"properties": "{{ properties }}", 
"description": "{{ description }}", 
"lastViewedByMeDate": "{{ lastViewedByMeDate }}", 
"shared": {{ shared }}, 
"labels": "{{ labels }}", 
"lastModifyingUserName": "{{ lastModifyingUserName }}", 
"folderColorRgb": "{{ folderColorRgb }}", 
"modifiedByMeDate": "{{ modifiedByMeDate }}", 
"clientEncryptionDetails": "{{ clientEncryptionDetails }}", 
"selfLink": "{{ selfLink }}", 
"sha1Checksum": "{{ sha1Checksum }}", 
"appDataContents": {{ appDataContents }}, 
"sharedWithMeDate": "{{ sharedWithMeDate }}", 
"title": "{{ title }}", 
"canReadRevisions": {{ canReadRevisions }}, 
"headRevisionId": "{{ headRevisionId }}", 
"fullFileExtension": "{{ fullFileExtension }}", 
"originalFilename": "{{ originalFilename }}", 
"openWithLinks": "{{ openWithLinks }}", 
"canComment": {{ canComment }}, 
"editable": {{ editable }}, 
"ownedByMe": {{ ownedByMe }}, 
"thumbnailVersion": "{{ thumbnailVersion }}", 
"permissionIds": "{{ permissionIds }}", 
"resourceKey": "{{ resourceKey }}", 
"kind": "{{ kind }}", 
"fileExtension": "{{ fileExtension }}", 
"writersCanShare": {{ writersCanShare }}, 
"labelInfo": "{{ labelInfo }}", 
"parents": "{{ parents }}", 
"contentRestrictions": "{{ contentRestrictions }}", 
"isAppAuthorized": {{ isAppAuthorized }}, 
"hasThumbnail": {{ hasThumbnail }}, 
"trashingUser": "{{ trashingUser }}", 
"linkShareMetadata": "{{ linkShareMetadata }}", 
"indexableText": "{{ indexableText }}", 
"embedLink": "{{ embedLink }}", 
"sharingUser": "{{ sharingUser }}", 
"capabilities": "{{ capabilities }}", 
"copyable": {{ copyable }}, 
"fileSize": "{{ fileSize }}", 
"teamDriveId": "{{ teamDriveId }}", 
"mimeType": "{{ mimeType }}", 
"lastModifyingUser": "{{ lastModifyingUser }}"
}'
;

Modifies the set of labels applied to a file. Returns a list of the labels that were added or modified.

EXEC googleworkspace.drivev2.files.modify_labels 
@fileId='{{ fileId }}' --required 
@@json=
'{
"labelModifications": "{{ labelModifications }}", 
"kind": "{{ kind }}"
}'
;

Permanently deletes all of the user's trashed files.

EXEC googleworkspace.drivev2.files.empty_trash 
@enforceSingleParent={{ enforceSingleParent }}, 
@driveId='{{ driveId }}'
;

Generates a set of file IDs which can be provided in insert or copy requests.

EXEC googleworkspace.drivev2.files.generate_ids 
@type='{{ type }}', 
@maxResults='{{ maxResults }}', 
@space='{{ space }}'
;

Generates a CSE token which can be used to create or update CSE files.

EXEC googleworkspace.drivev2.files.generate_cse_token 
@parent='{{ parent }}', 
@fileId='{{ fileId }}'
;

Restores a file from the trash. The currently authenticated user must own the file or be at least a fileOrganizer on the parent for shared drive files.

EXEC googleworkspace.drivev2.files.untrash 
@fileId='{{ fileId }}' --required, 
@supportsAllDrives={{ supportsAllDrives }}, 
@includeLabels='{{ includeLabels }}', 
@supportsTeamDrives={{ supportsTeamDrives }}, 
@includePermissionsForView='{{ includePermissionsForView }}'
;

Subscribes to changes to a file.

EXEC googleworkspace.drivev2.files.watch 
@fileId='{{ fileId }}' --required, 
@updateViewedDate={{ updateViewedDate }}, 
@supportsAllDrives={{ supportsAllDrives }}, 
@acknowledgeAbuse={{ acknowledgeAbuse }}, 
@revisionId='{{ revisionId }}', 
@includeLabels='{{ includeLabels }}', 
@supportsTeamDrives={{ supportsTeamDrives }}, 
@includePermissionsForView='{{ includePermissionsForView }}', 
@projection='{{ projection }}' 
@@json=
'{
"resourceId": "{{ resourceId }}", 
"id": "{{ id }}", 
"resourceUri": "{{ resourceUri }}", 
"params": "{{ params }}", 
"kind": "{{ kind }}", 
"payload": {{ payload }}, 
"expiration": "{{ expiration }}", 
"address": "{{ address }}", 
"type": "{{ type }}", 
"token": "{{ token }}"
}'
;

Exports a Google Workspace document to the requested MIME type and returns exported byte content. Note that the exported content is limited to 10MB.

EXEC googleworkspace.drivev2.files.export 
@fileId='{{ fileId }}' --required, 
@mimeType='{{ mimeType }}' --required
;

Set the file's updated time to the current server time.

EXEC googleworkspace.drivev2.files.touch 
@fileId='{{ fileId }}' --required, 
@includeLabels='{{ includeLabels }}', 
@supportsAllDrives={{ supportsAllDrives }}, 
@supportsTeamDrives={{ supportsTeamDrives }}, 
@includePermissionsForView='{{ includePermissionsForView }}'
;

Overview​

Fields​

Methods​

Parameters​

SELECT examples​

INSERT examples​

UPDATE examples​

REPLACE examples​

DELETE examples​

Lifecycle Methods​