List Rows (with SQL)

Gets a list or rows contained in a table, according to the select SQL-query provided in the request. Also the metadata of the table is returned.

Typical SQL-statements are supported. For more details, check the SQL-syntax supported by SeaTable.

Here are some basic examples how to use this request for a fictitious table Participants with the columns name, age, birthday and gender:
SELECT name, age, birthday, gender FROM Participants

SELECT name, surname FROM Participants ORDER BY name

SELECT * FROM Participants LIMIT 25

📘

Returns also data from the big data backend

This request is the only available endpoint that can return 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.

Language
Authorization
Bearer
URL
Click Try It! to start a request and see the response here!