Excel Add-In for Box

Build 21.0.8137

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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AsUserId String The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137