FileVersions
Tracks the version history of each file in OneDrive, allowing review or rollback of previous file states.
Table Specific Information
SELECT
The add-in will use the Microsoft OneDrive API to process WHERE clause conditions built with the following column and operator. The filter labeled 'createdBy_user_id' is required to execute the query successfully.
- FileId supports the '='.
- DriveId supports the '='.
- UserId supports the '='.
- createdBy_user_id supports the '='.
SELECT * FROM FileVersions WHERE FileId = '01CYQN2MFPR6NIWVZNMNFL3SL4E3KF7IHY' AND DriveId = 'b!GrEGWax2VE-ssnJNr1E8llqoLptvK-BGjFRpceFzFg5Nwp9Bw2xbR62J0NAouP6z' AND createdBy_user_id = '472df319-2978-49d4-9445-9e7019def16f' SELECT * FROM FileVersions WHERE FileId = '01CYQN2MFPR6NIWVZNMNFL3SL4E3KF7IHY' AND createdBy_user_id = '472df319-2978-49d4-9445-9e7019def16f' SELECT * FROM FileVersions WHERE createdBy_user_id = '472df319-2978-49d4-9445-9e7019def16f'
Columns
| Name | Type | References | Description |
| FileId [KEY] | String | Identifier of the original file to which this version belongs. | |
| lastModifiedBy_user_displayName | String | Display name of the user who made the most recent modification to this file version. | |
| lastModifiedBy_user_id | String | Unique identifier of the user who last modified this file version. | |
| lastModifiedDateTime | Datetime | Timestamp indicating when this file version was last modified. | |
| size | Long | Size of the file version in bytes. | |
| id | String | Unique identifier assigned to this specific version of the file. | |
| lastModifiedBy_user_email | String | Email address of the user who last modified this file version. | |
| DriveId | String | Identifier of the OneDrive or SharePoint drive where the file version is stored. | |
| publication_level | String | The publication state of the version, such as draft or published. | |
| createdBy_user_id | String | Unique identifier of the user who originally created this version of the file. |