TrashedItems

Contains items moved to the trash, allowing users to view, query, or permanently delete trashed files and folders.

Table Specific Information

Trashed Items are Files and Folders that have been deleted. This table supports only two operations: Select and Delete. Deleting from this table permanently deletes the File and is not recoverable.

Select

To search in the Trashed Items table for a specific item, specify the type of item (File, Folder, or WEB_LINK).

SELECT * FROM TrashedItems WHERE SearchTerms LIKE '%Untitled%' AND Type = 'file';

To query a single-deleted Folder, you can execute a query like the following:

SELECT * FROM TrashedItems WHERE Id = '123' AND Type = 'folder';

To query a single-deleted WEB_LINK, you can execute a query like the following:

SELECT * FROM TrashedItems WHERE Id = '123' AND Type = 'web_link';

Delete

Delete trashed items by specifying the Id and the Type of item.

DELETE FROM TrashedItems WHERE Id = 'abc123' AND Type = 'file';

Columns


Name	Type	ReadOnly	Description
SearchTerms	String	False	Keywords used to search for items in the trash.
Id [KEY]	String	False	Unique identifier assigned to the trashed item.
Name	String	False	The display name of the trashed item.
Type	String	False	The type of item that was trashed, such as file, folder, or web_link.
Sha1	String	False	The SHA-1 checksum of the trashed file, used for content verification and deduplication.
Etag	String	False	Version identifier for the trashed item, used to track changes and manage concurrency.
SequenceId	String	False	An incremental identifier representing the version sequence of the trashed item.
Description	String	False	A user-provided description of the trashed item.
Size	Integer	False	The size of the trashed item in bytes.
CreatedAt	Datetime	False	The date and time when the item was originally created in Box.
ModifiedAt	Datetime	False	The date and time when the item was last updated before being trashed.
TrashedAt	Datetime	False	The date and time when the item was moved to the trash.
PurgedAt	Datetime	False	The date and time when the item was permanently deleted from the trash.
ContentCreatedAt	Datetime	False	The date and time when the content of the item was first created.
ContentModifiedAt	Datetime	False	The date and time when the content of the item was last modified.
CreatedById	String	False	Identifier of the user who created the item.
CreatedByName	String	False	The full name of the user who created the item.
CreatedByLogin	String	False	The login email of the user who created the item.
SharedLink	String	False	A shareable URL that was generated for the item before it was trashed.
ModifiedBy	String	False	Identifier of the user who last modified the item before it was trashed.
ModifiedByName	String	False	The full name of the user who last modified the item.
ModifiedByLogin	String	False	The login email of the user who last modified the item.
OwnedById	String	False	Identifier of the user who owns the trashed item.
OwnedByName	String	False	The full name of the user who owns the trashed item.
OwnedByLogin	String	False	The login email of the user who owns the trashed item.
ParentId	String	False	Identifier of the parent folder that contained the trashed item.
ItemStatus	String	False	The current state of the trashed item, such as active, trashed, or deleted.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.