Revisions
The metadata for a revision to a file.
Select
The Revisions table supports the following columns for filtering. The provider uses the Google Drive API to process WHERE clause conditions built with these columns, offering optimal performance.
| Column | Supported Operators |
| Id | = |
| FileId | = |
To retrieve all revisions for a file:
SELECT * FROM Revisions WHERE FileId = 'your-file-id'
To retrieve a specific revision by encoded ID:
SELECT * FROM Revisions WHERE FileId = 'your-file-id' AND Id = '12345678901234567890'
Update
To update a revision, specify the Id and FileId:
UPDATE Revisions SET KeepForever = true WHERE Id = '12345678901234567890' AND FileId = 'your-file-id'
Delete
To delete a revision, specify the Id and FileId:
DELETE FROM Revisions WHERE Id = '12345678901234567890' AND FileId = 'your-file-id'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
The unique identifier of the revision. |
| FileId [KEY] | String | False |
The unique identifier of the file. |
| MIMEType | String | True |
The MIME type of the revision. |
| Published | Boolean | False |
Whether this revision is published. This is only applicable to Docs Editors files. |
| KeepForever | Boolean | False |
Whether to keep this revision forever, even if it is no longer the head revision. This field is only applicable to files with binary content in Drive. |
| MD5Checksum | String | True |
The MD5 checksum of the revision's content. This is only applicable to files with binary content in Drive. |
| ModifiedTime | Datetime | True |
The last time the revision was modified. |
| IsPublishAuto | Boolean | False |
Whether subsequent revisions will be automatically republished. This is only applicable to Docs Editors files. |
| IsPublishedOutsideDomain | Boolean | False |
Whether this revision is published outside the domain. This is only applicable to Docs Editors files. |
| PublishedLink | String | True |
A link to the published revision. This is only populated for Docs Editors files. |
| OriginalFilename | String | True |
The original filename used to create this revision. This is only applicable to files with binary content in Drive. |
| Size | Long | True |
The size of the revision's content in bytes. This is only applicable to files with binary content in Drive. |
| LastModifiedByName | String | True |
The display name of the last user to modify the revision. This field is only populated when the last modification was performed by a signed-in user. |
| LastModifiedByEmail | String | True |
The email address of the last user to modify the revision. This field is only populated when the last modification was performed by a signed-in user. |
| ExportLinks | Object | True |
Links for exporting Docs Editors files to specific formats. |
| Kind | String | True |
Identifies what kind of resource this is. Value: the fixed string 'drive#revision' |