> ## Documentation Index
> Fetch the complete documentation index at: https://docs.extruct.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# List Tables

> List root tables visible to the authenticated user.

Supports filtering by table kind, ownership scope, free-text search, and tags. Results can be sorted by creation time, name, or row count.

## Overview

This endpoint returns the root tables visible to the authenticated user.
You can filter by table kind, ownership scope, free-text search, and tags.
Results can be sorted by creation time, name, or row count.

## Example request

```bash theme={null}
export EXTRUCT_API_TOKEN="YOUR_API_TOKEN"

curl --get "https://api.extruct.ai/v1/tables" \
  -H "Authorization: Bearer ${EXTRUCT_API_TOKEN}" \
  --data-urlencode "scope=organization" \
  --data-urlencode "search=acme" \
  --data-urlencode "tags=portfolio" \
  --data-urlencode "tags=priority" \
  --data-urlencode "sort=-num_rows" \
  --data-urlencode "offset=0" \
  --data-urlencode "limit=20"
```

## Key parameters

* `kind` (optional): filter by table kind (`generic`, `company`, `people`).
* `scope` (optional): filter by ownership.
  `personal` returns the caller's own tables.
  `organization` returns all tables visible within the caller's organization, including the caller's own tables.
* `search` (optional): case-insensitive search across table names and descriptions.
* `tags` (optional): repeat this parameter to match tables with any of the selected tags.
* `sort` (optional): one of `-created_at`, `created_at`, `name`, `-name`, `num_rows`, `-num_rows`.
* `offset` (optional): number of matching tables to skip before returning results.
* `limit` (optional): maximum number of tables to return. Defaults to `50`; maximum is `100`.

## Success signal

A successful response returns an array of table objects.
Each item includes summary fields such as `id`, `created_at`, `updated_at`, `name`, `description`, `tags`, `kind`, `settings`, `scope`, `owner`, and `num_rows`.
The response also includes pagination headers:

* `x-extruct-pagination-total`
* `x-extruct-pagination-total-pages`
* `x-extruct-pagination-limit`
* `x-extruct-pagination-offset`
* `x-extruct-pagination-page`

## Common errors

### `401 Unauthorized`

Check that your header is `Authorization: Bearer ${EXTRUCT_API_TOKEN}`.

### `400 Bad Request`

Most often caused by `limit` values above `100`.

### `422 Unprocessable Entity`

Most often caused by unsupported query values for `kind`, `scope`, or `sort`.

## Related endpoints

* [Create Table Endpoint](/api-reference/tables/create-table)
* [Get Table Endpoint](/api-reference/tables/get-table)

## Related guides

* [AI Tables Basics](/api-guides/ai-tables/ai-table-basics)


## OpenAPI

````yaml get /v1/tables
openapi: 3.1.0
info:
  title: FastAPI
  version: 0.1.0
servers: []
security: []
paths:
  /v1/tables:
    get:
      tags:
        - tables
      summary: List Tables
      description: >-
        List root tables visible to the authenticated user.


        Supports filtering by table kind, ownership scope, free-text search, and
        tags. Results can be sorted by creation time, name, or row count.
      operationId: list_tables_v1_tables_get
      parameters:
        - name: kind
          in: query
          required: false
          schema:
            anyOf:
              - $ref: '#/components/schemas/TableKind'
              - type: 'null'
            description: Filter by table kind
          description: Filter by table kind
        - name: scope
          in: query
          required: false
          schema:
            anyOf:
              - $ref: '#/components/schemas/Scope'
              - type: 'null'
            description: >-
              Filter by ownership: personal returns the caller's own tables;
              organization returns all tables visible within the caller's
              organization, including the caller's own tables.
          description: >-
            Filter by ownership: personal returns the caller's own tables;
            organization returns all tables visible within the caller's
            organization, including the caller's own tables.
        - name: search
          in: query
          required: false
          schema:
            anyOf:
              - type: string
              - type: 'null'
            description: Case-insensitive search across table names and descriptions.
          description: Case-insensitive search across table names and descriptions.
        - name: tags
          in: query
          required: false
          schema:
            anyOf:
              - items:
                  type: string
                type: array
              - type: 'null'
            description: >-
              Repeat this parameter to match tables with any of the provided
              tags.
          description: Repeat this parameter to match tables with any of the provided tags.
        - name: sort
          in: query
          required: false
          schema:
            anyOf:
              - type: string
                enum:
                  - '-created_at'
                  - created_at
                  - name
                  - '-name'
                  - num_rows
                  - '-num_rows'
              - type: 'null'
            description: Sort order for the returned tables.
          description: Sort order for the returned tables.
        - name: offset
          in: query
          required: false
          schema:
            anyOf:
              - type: integer
                minimum: 0
              - type: 'null'
            description: Number of matching tables to skip.
        - name: limit
          in: query
          required: false
          schema:
            anyOf:
              - type: integer
                minimum: 1
                maximum: 100
                default: 50
              - type: 'null'
            description: Maximum number of tables to return. Defaults to 50. Maximum 100.
      responses:
        '200':
          description: Successful Response
          headers:
            x-extruct-pagination-total:
              schema:
                type: integer
              description: Total number of matching tables.
            x-extruct-pagination-total-pages:
              schema:
                type: integer
              description: Total number of pages for the current limit.
            x-extruct-pagination-limit:
              schema:
                type: integer
              description: Applied page size.
            x-extruct-pagination-offset:
              schema:
                type: integer
              description: Applied pagination offset.
            x-extruct-pagination-page:
              schema:
                type: integer
              description: Current 1-based page number.
          content:
            application/json:
              schema:
                type: array
                items:
                  $ref: '#/components/schemas/TableListItemOutput'
        '400':
          description: Bad Request
          content:
            application/json:
              schema:
                type: object
                properties:
                  detail:
                    type: string
                required:
                  - detail
        '422':
          description: Validation Error
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/HTTPValidationError'
      security:
        - HTTPBearer: []
components:
  schemas:
    TableKind:
      type: string
      enum:
        - generic
        - company
        - people
      title: TableKind
    Scope:
      type: string
      enum:
        - personal
        - organization
      title: Scope
      description: Ownership scope for filtering resources
    TableListItemOutput:
      properties:
        id:
          type: string
          title: Id
        created_at:
          type: string
          format: date-time
          title: Created At
        updated_at:
          type: string
          format: date-time
          title: Updated At
        name:
          type: string
          title: Name
        description:
          anyOf:
            - type: string
            - type: 'null'
        tags:
          anyOf:
            - items:
                type: string
              type: array
            - type: 'null'
        kind:
          $ref: '#/components/schemas/TableKind'
        settings:
          $ref: '#/components/schemas/TableSettings'
        scope:
          $ref: '#/components/schemas/Scope'
        owner:
          $ref: '#/components/schemas/OwnerInfo'
        num_rows:
          type: integer
          title: Num Rows
      type: object
      required:
        - id
        - created_at
        - updated_at
        - name
        - description
        - tags
        - kind
        - settings
        - scope
        - owner
        - num_rows
      title: TableListItemOutput
      description: Table list item returned by GET /v1/tables.
    HTTPValidationError:
      properties:
        detail:
          items:
            $ref: '#/components/schemas/ValidationError'
          type: array
          title: Detail
      type: object
      title: HTTPValidationError
    TableSettings:
      properties:
        exclude_from_search:
          type: boolean
          title: Exclude From Search
          default: false
      type: object
      title: TableSettings
    OwnerInfo:
      properties:
        id:
          type: string
          title: Id
        email:
          type: string
          title: Email
      type: object
      required:
        - id
        - email
      title: OwnerInfo
    ValidationError:
      properties:
        loc:
          items:
            anyOf:
              - type: string
              - type: integer
          type: array
          title: Location
        msg:
          type: string
          title: Message
        type:
          type: string
          title: Error Type
      type: object
      required:
        - loc
        - msg
        - type
      title: ValidationError
  securitySchemes:
    HTTPBearer:
      type: http
      scheme: bearer

````