List Rows (with SQL)

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.

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