Delete Records
DELETE/v1/rdb/rest/:table
Delete data according to conditions, WHERE conditions must be provided
Request
Path Parameters
table stringrequired
Table name
Query Parameters
select string
Return fields, supports * or specified field list
limit integer
Limit delete count
order string
Sort field
Header Parameters
Prefer string
Preference setting, such as return=representation returns deleted data
Responses
- 200
- 204
- 400
Delete successful (with response body)
Response Headers
Content-Range string
Number of affected rows
Preference-Applied string
Applied preference settings
- application/json
- Schema
- Example (from schema)
Schema
- Array [
- ]
object
[
{}
]
Delete successful (without response body)
Response Headers
Content-Range string
Number of affected rows
Preference-Applied string
Applied preference settings
Request error, such as missing WHERE conditions
- application/json
- Schema
- Example (from schema)
Schema
code string
Error code
details stringnullable
Error details
hint stringnullable
Error hint
message string
Error message
{
"code": "PGRST106",
"details": null,
"hint": "Only the following schemas are exposed: public",
"message": "Invalid schema: undefined"
}
Loading...