Tables

List table rows

Returns a page of a table's rows, in the table's order unless you name a sort, and by id for a table that names no order. A row without the sorted column comes last, and ties go by id.

GET
/items/{id}/tables/{table}/rows

Authorization

bearerAuth
headerAuthorizationBearer <token>

Authenticate with an API key (marfa_k1_…) or an OAuth access token (marfa_at_…).

Path parameters

id*string

The ID of the item.

table*string

The name of the table.

Query parameters

limit?integer

The maximum number of results to return.

Range1 <= value <= 1000
Default100
cursor?string

The next_cursor from the previous page. Leave it out to get the first page.

filter?string

Only return rows that match this expression, in the item filter grammar, where values.<column> names a column and id and updated_at are the row's own.

sort?string

What to sort by: id, updated_at or values.<column>. Defaults to the table's order column, or id when it names none. Sorting by the order column reads only the rows a page answers; another column reads every row.

Match^(id|updated_at|values\.[a-z][a-z0-9_]*)$
direction?string

The order of the sort: asc or desc.

Default"asc"
Value in"asc""desc"

Header parameters

X-Marfa-Reach?string

The reach from a copy stream, for a working copy. Marfa reads the current data and checks the reach in one snapshot, and returns 409 reach_changed if it has changed. Leave it out for an ordinary read.

Match^[0-9a-f]{64}$
Length64 <= length <= 64

Response body

About errors

Returns the rows on this page.

application/json
  1. response

A page of a table's rows.

data*array<>

The rows on this page.

next_cursor*|

Pass this as cursor to get the next page, or null when there are no more.

  • invalid_id: the ID is not a valid item ID.
  • validation_error: a query parameter is unknown or out of range, filter or sort names a column the table doesn't declare, or cursor came from another listing.
application/json
  1. response

An error response.

error*

What went wrong.

unauthorized: the request has no credential, or its credential is not valid. For a key that has expired, details.expired_at says when it expired.

application/json
  1. response

An error response.

error*

What went wrong.

  • type_not_permitted: your credential reaches no type.
application/json
  1. response

An error response.

error*

What went wrong.

  • item_not_found: no item has this ID, the item is in the trash (details.trashed is true if you can read its type), or its type is one you can't read.
  • table_not_found: the item's type declares no table of this name.
application/json
  1. response

An error response.

error*

What went wrong.

reach_changed: the reach in X-Marfa-Reach has changed. Rebuild the working copy.

application/json
  1. response

An error response.

error*

What went wrong.

contract_mismatch: X-Marfa-Contract names another contract version than this instance speaks, or is not a whole number. Nothing was done.

application/json
  1. response

An error response.

error*

What went wrong.

rate_limited: you sent too many requests. Wait for the number of seconds in Retry-After, then try again.

application/json
  1. response

An error response.

error*

What went wrong.

internal_error: Marfa failed in a way it didn't expect, and the request may not have completed. Read what you changed before you repeat a write.

application/json
  1. response

An error response.

error*

What went wrong.

write_contention: the database was busy, and Marfa couldn't complete the request in time. Nothing changed. Try the request again. While a restore runs, details.reason is restore_running.

application/json
  1. response

An error response.

error*

What went wrong.

insufficient_storage: the disk that holds the instance's data has no room for the request, or the request would leave less free than the instance keeps in reserve. Nothing changed, unless details.write_outcome is unknown, which means the write may have landed: read what you changed before you repeat it. Free space on the disk, then try the request again.

application/json
  1. response

An error response.

error*

What went wrong.

curl -X GET 'http://localhost:8600/items/string/tables/string/rows'
About errors
{  "data": [    {      "id": "019a5b1e-7c41-7d2e-9f3a-5b8c2d4e6f70",      "values": {        "amount": 12.5,        "memo": "Coffee"      },      "updated_at": "2026-10-03T09:30:00.000Z"    }  ],  "next_cursor": null}