Execute SQL query

Execute SQL query on a base

POST /base/{baseId}/sql-query

cURL

cURL

curl --request POST \
  --url https://sheets.vn/api/base/%7BbaseId%7D/sql-query \
  --header 'Authorization: Bearer REPLACE_BEARER_TOKEN' \
  --header 'content-type: application/json' \
  --data '{"sql":"SELECT * FROM table_name LIMIT 10"}'

200

{
  "rows": [
    {}
  ]
}

Ủy quyền

Authorization · string · header · bắt buộc

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Tham số đường dẫn

baseId · string · bắt buộc

The base ID to execute query on

Nội dung

application/json

sql · string · bắt buộc

The SQL query to execute

Minimum string length: 1

Ví dụ:

"SELECT * FROM table_name LIMIT 10"

Phản hồi

200 - application/json

Query executed successfully

rows · object[] · bắt buộc

The query result rows

Show child attributes