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

Delete successful (with response body)

Response Headers

• Content-Range string

  Number of affected rows

• Preference-Applied string

  Applied preference settings

application/json

Schema

Schema

• Array [

object

• ]

Example (from schema)

[
  {}
]

204

Delete successful (without response body)

Response Headers

• Content-Range string

  Number of affected rows

• Preference-Applied string

  Applied preference settings

400

Request error, such as missing WHERE conditions

application/json

Schema

Schema

code string

Error code

message string

Error message

requestId string

Unique request ID

Example (from schema)

{
  "code": "BadApiRequest",
  "message": "UPDATE requires a WHERE clause",
  "requestId": "req-123456"
}

Loading...