# Lookup table activity

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

Read recorded changes to a lookup table and filter by time or actor.

## Request

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

```

Lists what was done to one lookup table this key can read, newest first: the table, its fields, rows, lookups and imports. Each entry is when it happened, the action's name, who acted (a person, an API key with its id, or the system) and, for a key, whether it came through the API or an AI app. What was changed is not returned. occurred_at_from and occurred_at_before narrow it to a time range, actor_type to people, API keys or the system, and api_key_id to one key. Send next_cursor as cursor for the next page.

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

MCP action: `list_lookup_table_activity`. 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                              |       |
| `occurred_at_from`   | query   | No       | string (date-time)                  |       |
| `occurred_at_before` | query   | No       | string (date-time)                  |       |
| `actor_type`         | query   | No       | `"person"`, `"api_key"`, `"system"` |       |
| `api_key_id`         | query   | No       | string (uuid)                       |       |
| `limit`              | query   | No       | integer                             |       |
| `cursor`             | query   | No       | string                              |       |

## Response

| HTTP status | Result                                                                |
| ----------- | --------------------------------------------------------------------- |
| `200`       | The requested result. Asynchronous work returns an operation to poll. |

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`                    | array of object                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | Yes                |       |
| `data[].object`           | `"lookup_table_activity"`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Yes                |       |
| `data[].id`               | string                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Yes                |       |
| `data[].occurred_at`      | string                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Yes                |       |
| `data[].action`           | `"lookup.table.created"`, `"lookup.table.renamed"`, `"lookup.table.archived"`, `"lookup.table.deleted"`, `"lookup.table.fill_retried"`, `"lookup.table.fill_dismissed"`, `"lookup.table_exported"`, `"lookup.table_row_limit.set"`, `"lookup.field.created"`, `"lookup.field.updated"`, `"lookup.field.archived"`, `"lookup.row.created"`, `"lookup.row.updated"`, `"lookup.row.deleted"`, `"lookup.definition.enabled"`, `"lookup.definition.retired"`, `"lookup.definition.default_changed"`, `"lookup.import.created"`, `"lookup.import.upload_requested"`, `"lookup.import.uploaded"`, `"lookup.import.preview_requested"`, `"lookup.import.apply_requested"`, `"lookup.import.started"`, `"lookup.import.chunk_applied"`, `"lookup.import.cancel_requested"`, `"lookup.import.applied"`, `"lookup.import.canceled"`, `"lookup.import.failed"`, `"lookup.import.expired"`, `"lookup.app_table.enabled"`, `"lookup.app_table.disabled"`, `"lookup.app_table.rows_written"`, `"lookup.statuses.synced"` | Yes                |       |
| `data[].actor`            | object                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Yes                |       |
| `data[].actor.type`       | `"person"`, `"api_key"`, `"system"`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | Yes                |       |
| `data[].actor.api_key_id` | string or null                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Yes                |       |
| `data[].via`              | `"api"`, `"mcp"` or null                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | Yes                |       |
| `data[].operation_id`     | string or null                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | No                 |       |
| `pagination`              | object                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Yes                |       |
| `pagination.next_cursor`  | string or null                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Yes                |       |

## Errors

| HTTP status | Meaning                                                                                                                                           |
| ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------- |
| `400`       | One of: credential_in_url, invalid_parameter, unknown_parameter, invalid_request, invalid_cursor.                                                 |
| `401`       | One of: missing_credential, invalid_credential, credential_expired, credential_revoked.                                                           |
| `402`       | One of: payment_overdue.                                                                                                                          |
| `403`       | The current permissions, plan or policy do not allow this request.                                                                                |
| `404`       | One of: not_found.                                                                                                                                |
| `409`       | The request conflicts with current resource state, authorization or an earlier request. Read the error code and current resource before retrying. |
| `410`       | The requested resource or retained recovery data has expired.                                                                                     |
| `413`       | One of: request_too_large.                                                                                                                        |
| `422`       | A field, filter or selection cannot be used for this request.                                                                                     |
| `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.
