Update Records
PATCH/v1/rdb/rest/:table
Update 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 update count
order string
Sort field
Header Parameters
Prefer string
Preference setting, such as return=representation returns updated data
- application/json
Body
required
object
Responses
- 200
- 204
- 400
Update 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
[
{}
]
Update 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
message string
Error message
requestId string
Unique request ID
{
"code": "BadApiRequest",
"message": "UPDATE requires a WHERE clause",
"requestId": "req-123456"
}
Loading...