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.

Click Try It! to start a request and see the response here!