FileVersions
The OneDrive table Files in which you can view all the files in a drive.
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.
- FileId supports the '='.
- DriveId supports the '='.
- UserId supports the '='.
SELECT * FROM FileVersions WHERE FileId = '01CYQN2MFPR6NIWVZNMNFL3SL4E3KF7IHY' AND DriveId = 'b!GrEGWax2VE-ssnJNr1E8llqoLptvK-BGjFRpceFzFg5Nwp9Bw2xbR62J0NAouP6z' SELECT * FROM FileVersions WHERE FileId = '01CYQN2MFPR6NIWVZNMNFL3SL4E3KF7IHY' AND createdBy_user_id = '472df319-2978-49d4-9445-9e7019def16f'
Columns
| Name | Type | References | Description |
| FileId [KEY] | String | ||
| lastModifiedBy_user_displayName | String | ||
| lastModifiedBy_user_id | String | ||
| lastModifiedDateTime | Datetime | ||
| size | Long | ||
| id | String | ||
| lastModifiedBy_user_email | String | ||
| DriveId | String | ||
| publication_level | String | ||
| createdBy_user_id | String |