Insert Data or Upsert
POST/v1/rdb/rest/:table
Insert single or multiple records, supports upsert operations
Request
Path Parameters
table stringrequired
Table name
Query Parameters
select string
Fields to return, supports * or a list of specified fields
Header Parameters
Prefer string
Preference settings, e.g., return=representation returns the inserted data; upsert (update or insert) data. resolution=merge-duplicates indicates using a merge policy when data conflicts occur, resolution=ignore-duplicates indicates using an ignore policy when data conflicts occur
- application/json
Body
required
- MOD1
- MOD2
- Array [
- ]
oneOf
object
object
Responses
- 201
- 400
Insert successful
Response Headers
Content-Range string
Affected rows
Preference-Applied string
Applied preference settings
- application/json
- Schema
- Example (from schema)
Schema
- MOD1
- MOD2
- Array [
- ]
oneOf
object
object
[
null
]
Request error
- application/json
- Schema
- Example (from schema)
Schema
code string
Error code
message string
Error message
requestId string
Request unique ID
{
"code": "BadApiRequest",
"message": "UPDATE requires a WHERE clause",
"requestId": "req-123456"
}
Loading...