---
title: "Get record"
method: GET
path: "/table/{tableId}/record/{recordId}"
tags: ["record"]
---

# Get record

`GET /table/{tableId}/record/{recordId}`

Retrieve a single record by its ID with options to specify field projections and output format.

## Path parameters

- `tableId` string, required
- `recordId` string, required

## Query parameters

- `projection` string[] — If you want to get only some fields, pass in this parameter, otherwise all visible fields will be obtained, The parameter value depends on the specified fieldKeyType to determine whether it is name or id
- `cellFormat` 'json' | 'text' — Define the return value formate, you can set it to text if you only need simple string value
- `fieldKeyType` 'id' | 'name' | 'dbFieldName' — Define the key type of record.fields[key], You can click "systemInfo" in the field edit box to get fieldId or enter the table design screen with all the field details

## Response `200`

Success

- object
  - `id` string, required — The record id.
  - `name` string — primary field value
  - `fields` object, required — Objects with a fields key mapping fieldId or field name to value for that field.
  - `autoNumber` number — Auto number, a unique identifier for each record
  - `createdTime` string — Created time, date ISO string (new Date().toISOString).
  - `lastModifiedTime` string — Last modified time, date ISO string (new Date().toISOString).
  - `createdBy` string — Created by, user name
  - `lastModifiedBy` string — Last modified by, user name
  - `permissions` object — Permissions for the record
  - `undeletable` boolean — Whether the record is undeletable

---

[API](https://skmtc.dev/teable/apis/teable-app.md) · [All operations](https://skmtc.dev/teable/apis/teable-app/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/teable/teable-app/revisions/7515f3b33d79/schema)