Lists rows in a table based on an SQL-query provided in the request. Also returns the metadata of the table.
Typical SQL-statements are supported. Below some basic examples:
SELECT name, age, birthday, gender FROM Participants
SELECT name, surname FROM Participants ORDER BY name
SELECT * FROM Participants LIMIT 25
For more details, check the SQL-syntax supported by SeaTable.
Returns also data from the big data backend
This request is the only available endpoint that returns rows stored in the big data backend.
Returns at most 10 000 rows
The request returns a maximum of 10 000 rows regardless of the limit specified in the SQL-statement.
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 youcurlcommand does not return any result, you need to add the-Lparameter to follow these redirects. Most other clients handle redirects automatically.