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.