FileVersions
Tracks the version history of each file in OneDrive, allowing review or rollback of previous file states.
Table Specific Information
SELECT
The 本製品 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. |