Query Records
GET/v1/rdb/rest/:table
Query data in table, supports complex queries, join queries, pagination, sorting, etc.
Request
Path Parameters
table stringrequired
Table name
Query Parameters
select string
Select fields, supports * or specified field list, supports join queries like class_id(grade,class_number)
limit integer
Limit return count
offset integer
Offset, used for pagination
order string
Sort field, format is field.asc or field.desc
Header Parameters
Prefer string
Preference setting, such as count=exact
Responses
- 200
- 400
- 401
- 404
Query successful
Response Headers
Content-Range string
Data range
- application/json
- Schema
- Example (from schema)
Schema
- Array [
- ]
object
[
{}
]
Request error
- application/json
- Schema
- Example (from schema)
Schema
code string
Error code
message string
Error message
requestId string
Unique request ID
{
"code": "BadApiRequest",
"message": "UPDATE requires a WHERE clause",
"requestId": "req-123456"
}
Authentication failed
- application/json
- Schema
- Example (from schema)
Schema
code string
Error code
message string
Error message
requestId string
Unique request ID
{
"code": "BadApiRequest",
"message": "UPDATE requires a WHERE clause",
"requestId": "req-123456"
}
Table does not exist
- application/json
- Schema
- Example (from schema)
Schema
code string
Error code
message string
Error message
requestId string
Unique request ID
{
"code": "BadApiRequest",
"message": "UPDATE requires a WHERE clause",
"requestId": "req-123456"
}
Loading...