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 supported SQL Syntax from 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 big data backend

This request is the only available endpoint that can also returns rows from the big data backend.

🚧

Returns at most 10.000 rows

Even if you specify LIMIT > 10,000, this request will return a maximum of 10,000 rows.

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