API Reference

List Rows

Lists rows in a table (or in a view if provided). If no view is selected, all columns (even hidden one) are returned. If a view is selected, only visible columns of that view are returned.

📘

Returns no data from the big data backend

This request does not return rows stored in the big data backend. To query the big data backend, use the request List Rows (with SQL) instead.

🚧

Returns at most 1 000 rows

The request returns a maximum of 1 000 rows regardless of the specified limit.

❗️

CURL does not follow redirects by default (relevant especially for SeaTable Cloud)

SeaTable Cloud (version 5.0 and newer) redirects this endpoint to the new API gateway endpoint using a 302 header redirect.
If you curl command does not return any result, you need to add the -L parameter to follow these redirects. Most other clients handle redirects automatically.

Path Params
string
required

The unique identifier of a base. Sometimes also called dtable_uuid.

Query Params
string
required

The name of the table.

string

The name of the view.

integer

Starting position (number) of the returned rows. 0 by default.

integer
1 to 1000

Number of rows that should be returned. 1000 by default.

Response

Language
Credentials
URL
Click Try It! to start a request and see the response here! Or choose an example:
application/json