Lists all available versions of a file stored in Box, enabling tracking of file history and access to prior revisions.

Table Specific Information

File Versions contains information about older versions of a file. This table supports only the SELECT operation.

Select

When selecting from the File Versions view, you must specify FileId, or FileId and Id in the WHERE clause.

SELECT * FROM FileVersions WHERE FileId = '1926408231807';

If you're authenticated as an administrator with user impersonation permissions, you can query file versions from multiple user accounts. For example:

SELECT * FROM FileVersions WHERE AsUserId IN (SELECT Id FROM Users);

Note: User impersonation has the following limitations:

• The authenticated user cannot be impersonated unless that user is a service account.
• If the authenticated user is a standard user account, they can only query file versions associated with their account.
• File versions shared with multiple users are only returned for one of the users.

Columns