# Get a table

Source: https://neondeerdata.com/docs/api/lookup-tables/get-table/

Read a table and its field definitions.

## Request

```http
GET /v1/lookup-tables/{table_id}

```

Gets one table and the fields this key can read.

Requires `lookup_tables:read`. The connection also needs access to the relevant tables, objects, or workflows.

MCP action: `get_lookup_table`. Its argument names match the fields below; an HTTP header is passed using its argument name in MCP.

## Parameters

| Name       | Send in | Required | Type or allowed values | Notes |
| ---------- | ------- | -------- | ---------------------- | ----- |
| `table_id` | path    | Yes      | string                 |       |

## Response

| HTTP status | Result     |
| ----------- | ---------- |
| `200`       | The table. |

Required fields are required within their containing object. Notes identify fields that apply only to a particular response alternative.

| Response field             | Type                                                                                                                          | Required in object | Notes |
| -------------------------- | ----------------------------------------------------------------------------------------------------------------------------- | ------------------ | ----- |
| `data`                     | LookupTableDetail                                                                                                             | Yes                |       |
| `data.id`                  | string (uuid)                                                                                                                 | Yes                |       |
| `data.object`              | `"lookup_table"`                                                                                                              | Yes                |       |
| `data.name`                | string                                                                                                                        | Yes                |       |
| `data.fields`              | array of object                                                                                                               | Yes                |       |
| `data.fields[].object`     | `"lookup_field"`                                                                                                              | Yes                |       |
| `data.fields[].key`        | string                                                                                                                        | Yes                |       |
| `data.fields[].name`       | string                                                                                                                        | Yes                |       |
| `data.fields[].type`       | `"text"`, `"number"`, `"boolean"`, `"date"`, `"timestamp"`, `"email"`, `"phone"`, `"domain"`, `"url"`, `"member"`, `"record"` | Yes                |       |
| `data.fields[].filterable` | boolean                                                                                                                       | Yes                |       |
| `data.fields[].unique`     | boolean                                                                                                                       | Yes                |       |

## Errors

| HTTP status | Meaning                                                                                                                                                   |
| ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `400`       | One of: invalid_request, invalid_filter, invalid_value, invalid_cursor, credential_in_url.                                                                |
| `401`       | One of: missing_credential, invalid_credential, credential_expired, credential_revoked.                                                                   |
| `402`       | One of: payment_overdue.                                                                                                                                  |
| `403`       | One of: plan_required, not_available, insufficient_scope, operation_not_allowed, field_not_writable, plan_capacity_exceeded.                              |
| `404`       | One of: resource_not_found.                                                                                                                               |
| `409`       | One of: table_filling, table_fill_failed, lookup_key_required, key_conflict, version_conflict, table_busy, table_capacity_exceeded, idempotency_conflict. |
| `413`       | One of: request_too_large.                                                                                                                                |
| `422`       | One of: batch_rejected.                                                                                                                                   |
| `423`       | One of: organization_reopening.                                                                                                                           |
| `428`       | One of: customer_agreement_required.                                                                                                                      |
| `429`       | One of: rate_limited.                                                                                                                                     |
| `503`       | One of: service_unavailable.                                                                                                                              |

See [errors and recovery](https://neondeerdata.com/docs/api/errors/) and [safe retries](https://neondeerdata.com/docs/api/requests/) before repeating a write.

The [public OpenAPI document](https://neondeerdata.com/docs/api/meta/openapi/) lists generally available API families. Alpha operations may not appear in that document; their request and response fields are listed on this page. Use the [API Playground](https://neondeerdata.com/docs/api/testing/) to inspect a real response with your connection's access.
