# Get a row

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

Read one row by ID.

## Request

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

```

Gets one row by its ID. Send its version as expected_version when you change or delete the row.

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

MCP action: `get_lookup_row`. 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                 |                                                                 |
| `row_id`   | path    | Yes      | string                 |                                                                 |
| `fields`   | query   | No       | array of string        | Repeat this query parameter or separate its values with commas. |

## Response

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

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`                    | LookupRow          | Yes                |       |
| `data.id`                 | string (uuid)      | Yes                |       |
| `data.object`             | `"lookup_row"`     | Yes                |       |
| `data.values`             | object             | Yes                |       |
| `data.version`            | integer            | Yes                |       |
| `data.roster_verified_at` | string (date-time) | No                 |       |

## 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.