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.
bearerAuthAuthorizationBearer <token>Authenticate with an API key (marfa_k1_…) or an OAuth access token (marfa_at_…).
id*stringThe ID of the item.
table*stringThe name of the table.
limit?integerThe maximum number of results to return.
1 <= value <= 1000100cursor?stringThe next_cursor from the previous page. Leave it out to get the first page.
filter?stringOnly 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?stringWhat 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.
^(id|updated_at|values\.[a-z][a-z0-9_]*)$direction?stringThe order of the sort: asc or desc.
"asc""asc""desc"X-Marfa-Reach?stringThe 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.
^[0-9a-f]{64}$64 <= length <= 64Returns the rows on this page.
application/json- 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,filterorsortnames a column the table doesn't declare, orcursorcame from another listing.
application/json- 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- response
An error response.
error*What went wrong.
type_not_permitted: your credential reaches no type.
application/json- response
An error response.
error*What went wrong.
item_not_found: no item has this ID, the item is in the trash (details.trashedistrueif 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- response
An error response.
error*What went wrong.
reach_changed: the reach in X-Marfa-Reach has changed. Rebuild the working copy.
application/json- 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- 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- 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- 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- 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- response
An error response.
error*What went wrong.
curl -X GET 'http://localhost:8600/items/string/tables/string/rows'{ "data": [ { "id": "019a5b1e-7c41-7d2e-9f3a-5b8c2d4e6f70", "values": { "amount": 12.5, "memo": "Coffee" }, "updated_at": "2026-10-03T09:30:00.000Z" } ], "next_cursor": null}