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 = '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	A query string used to search across trashed items.
Id [KEY]	String	False	The unique identifier of the trashed item.
Name	String	False	The name of the trashed item.
Type	String	False	The type of trashed item, such as file, folder, or web_link.
Sha1	String	False	The SHA-1 hash of the trashed item for file integrity verification.
Etag	String	False	The entity tag of the trashed item used for version control.
SequenceId	String	False	The sequence Id of the trashed item, used for internal ordering and version tracking.
Description	String	False	The description or notes about the trashed item.
Size	Int64	False	The size of the trashed item in bytes.
CreatedAt	Datetime	False	The date and time when the trashed item was originally created.
ModifiedAt	Datetime	False	The date and time when the trashed item was last modified.
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 originally created.
ContentModifiedAt	Datetime	False	The date and time when the content of the item was last modified.
CreatedById	String	False	The Id of the user who created the trashed item.
CreatedByName	String	False	The name of the user who created the trashed item.
CreatedByLogin	String	False	The login of the user who created the trashed item.
SharedLink	String	False	The shared link associated with the trashed item, if one exists.
ModifiedBy	String	False	The Id of the user who last modified the trashed item.
ModifiedByName	String	False	The name of the user who last modified the trashed item.
ModifiedByLogin	String	False	The login of the user who last modified the trashed item.
OwnedById	String	False	The Id of the user who owns the trashed item.
OwnedByName	String	False	The name of the user who owns the trashed item.
OwnedByLogin	String	False	The login of the user who owns the trashed item.
ParentId	String	False	The Id of the parent folder containing the trashed item.
ItemStatus	String	False	The current status of the trashed item, such as active, trashed, or purged.
AsUserId	String	False	The Id of the user you want to impersonate. Only works with Admin, Co-Admin, and Service Accounts.

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.