---
title: "List trashed tables"
method: GET
path: "/tables/trash/"
tags: ["tables"]
---

# List trashed tables

`GET /tables/trash/`

## Request

- Base URL: `https://api.getoneprofile.ai` (the document declares no server; this is the origin it was published from)
- URL: `https://api.getoneprofile.ai/tables/trash/`
- Auth: one of:
  - API key in header `X-API-Key`
  - HTTP bearer

List the organisation's trashed tables, newest deletion first. Each one can be restored in full, or destroyed early with the purge endpoint; otherwise the retention sweep destroys it once it is old enough. A table that went to Trash with its folder is not listed: the folder is, under the trashed folders listing, and it comes back with its folder. `name__contains` narrows it by name, as the Trash page's search does.

## Query parameters

- `filters` ListTrashedTablesFilterParamsSchema, required: Query parameters for filtering the tables in Trash.
  - `name__contains` string, nullable: Filter by name (case-insensitive contains).
- `limit` integer: The number of items to return.
- `order_by` 'id' | 'created_at' | 'updated_at' | 'name'
- `order_direction` 'asc' | 'desc'
- `cursor` string, nullable: Set the cursor to the next or previous page. You can get the cursor from the previous page's response.

## Response `200`

Successful Response

- PaginatedResponseTableReadSchema
  - `data` TableReadSchema[]: The list of ResponseItems.
    - `ai_made` boolean: Whether the AI Assistant created this table through a granted action. The owner is still the person who approved it.
    - `archived_at` string, date-time, nullable: When somebody archived it; null for a table on the list. An archived table is left out of All, its folder, Favorites and Recent, and still found by search and opened as before.
    - `auto_run` boolean, required: Whether data changes request recompute runs by themselves. Column-definition changes always recompute.
    - `created_at` string, date-time, required
    - `deleted_at` string, date-time, nullable: When the table was moved to trash; null for a live table.
    - `description` string, nullable, required
    - `folder_id` string, uuid, nullable: The folder it sits in; null for the top level.
    - `folder_path` TableFolderCrumbSchema[]: The folders on the way to it, from the top level down; empty at the top level. What the list says under a search result and the table's own breadcrumb shows.
      - `id` string, uuid, required
      - `name` string, required
    - `former_tags` string[]: The tags it carried when folders replaced tags, when it carried more than one and so waits for somebody to file it. Empty once it is filed.
    - `id` string, uuid, required
    - `is_favorite` boolean: Whether the CALLING USER starred this table. Per-user, so a teammate may see a different value. Always false for API-key callers, which have no user to have preferences.
    - `keep_existing_results` boolean, required: Whether a manual run-all only fills the errored, empty and stale cells rather than recomputing every cell in scope.
    - `last_viewed_at` string, date-time, nullable: When the calling user last opened this table; null means never.
    - `name` string, required
    - `owner_display_name` string, nullable: The owner's name, resolved for display. Null when there is no owner or the account has no name to show.
    - `owner_user_id` string, nullable: Who created the table. Null for tables older than this field and for anything a background job created. NOT an access control: every member of the organisation can open and edit every table.
    - `row_count` integer, required: Exact row count, maintained atomically by row mutations.
    - `shared_as_template` boolean: Whether this table's shape is readable by anyone with the link, with no sign-in. Never its rows.
    - `updated_at` string, date-time, required
  - `next_page_cursor` string, nullable: The cursor to the next page. If there are no more pages, this is None.
  - `previous_page_cursor` string, nullable: The cursor to the previous page. If there are no previous pages, this is None.

## Other responses

- `401`: Unauthorized
- `403`: Forbidden
- `422`: Invalid request made to the API.
- `500`: Internal server error.
- `502`: Bad gateway error.
- `503`: Service unavailable.

---

[API](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile.md) · [All operations](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile/llms.txt) · [OpenAPI document](https://skmtc.dev/getoneprofile/apis/api-reference-oneprofile/revisions/dc5ac3c84444?raw)