FileVersions
Query the available file versions in the box.
Table Specific Information
File Versions contains information about older versions of a file. This table supports only SELECT operation.
Select
FileId is required to search all the FileVersions in your files.
SELECT * FROM FileVersions WHERE FileId='585442984153'
Columns
| Name | Type | Description |
| Id [KEY] | String | The ID of the file version. |
| FileId | String | The ID of the file. |
| CreatedAt | Datetime | The date the content of the file was created at. |
| ModifiedAt | Datetime | The date the content of the file was modified at. |
| ModifiedById | String | The Id of the user that last modified the file. |
| ModifiedByName | String | The Name of the user that last modified the file. |
| ModifiedByLogin | String | The Login of the user that last modified the file. |
| ModifiedByType | String | The Type of the user that last modified the file. |
| Name | String | The name of the file. |
| PurgedAt | Datetime | The date the content of the file was purged at. |
| RestoredAt | Datetime | The date the content of the file was modified at. |
| RestoredById | String | The Id of the user that last modified the file. |
| RestoredByLogin | String | The Name of the user that last modified the file. |
| RestoredByName | String | The Login of the user that last modified the file. |
| RestoredByType | String | The Type of the user that last modified the file. |
| Sha1 | String | The SHA-1 encryption of the file version. |
| Size | Int64 | The size of the file version. |
| TrashedAt | Datetime | The date the file version was trashed at. |
| TrashedById | String | The Id of the user that trashed the file. |
| TrashedByLogin | String | The Name of the user that trashed the file. |
| TrashedByName | String | The Login of the user that trashed the file. |
| TrashedByType | String | The Type of the user that trashed the file. |
| Type | String | Type of file versions. |
| AsUserId | String | The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts. |