Skip to main content
Fetch a single row by id. Works for both regular and archive tables. To list or filter rows, use clay tables rows list. 
clay tables rows get <tableId> <rowId>

​
Arguments

ArgumentDescription
tableIdThe id of the table (regular or archive) the row belongs to. Required.
rowIdThe id of the row to fetch. Required.

​
Output

{
  "id": "rec_456",
  "updatedAt": "2026-01-01T00:00:00.000Z",
  "cells": {
    "col_email": { "status": "success", "value": "jane@acme.com", "fields": null }
  }
}
FieldTypeDescription
idstringRow id.
updatedAtstringLast-updated timestamp.
cellsobjectMap of column id to a cell object (see below).

​
Cell shape

Each cell is discriminated on status:
StatusFieldsMeaning
successvalue (computed value), fields (object | null), isStale (optional true)The cell has a computed value; structured content is in fields.
errorerror (string, optional)The cell errored; error carries the message.
running, queued, retry, rate_limited, awaiting_callback—The cell is still being computed.
empty—The cell has no value yet.

​
Errors

CodeExitNotes
not_found6No table or no row with that id in the workspace.
auth_forbidden3The API key lacks the cli:all scope, or you cannot read this table.

​
Examples

clay tables rows get tbl_123 rec_456
clay tables rows get tbl_123 rec_456 | jq '.cells'
clay tables rows get tbl_archive rec_789 | jq -r '.cells | keys[]'