Insert or Upsert Records

POST 
/v1/rdb/rest/:table

Insert single or multiple records, supports upsert operation

Request

Path Parameters

table stringrequired

Table name

Query Parameters

select string

Return fields, supports * or specified field list

Header Parameters

Prefer string

Preference setting, such as return=representation returns inserted data; upsert(update or delete data)resolution=merge-duplicates indicates merge strategy when data conflicts, resolution=ignore-duplicates indicates ignore strategy when data conflicts

application/json

Body

required

oneOf
MOD1
object
MOD2
Array [
object
]

Responses

201

Insert successful

Response Headers

• Content-Range string

  Number of affected rows

• Preference-Applied string

  Applied preference settings

application/json

Schema

Schema

oneOf

MOD1

Array [

object

]

MOD2

object

Example (from schema)

[
  null
]

400

Request error

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...