FileVersions
The OneDrive table Files in which you can view all the files in a drive.
Table Specific Information
SELECT
The driver 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 |