Insert Bulk KV Data

post/kvservice.loaddata/{tableName}

Inserts bulk data to the Key-Value Store.
Existing Primary Key combos are overwritten automatically. This is the only command where you explicitly have to specify the automatic “payload” column. While technically you could put any text into that column, other endpoints and Groovy perform JSON conversions (e.g. return a proper map) when you perform key lookups. So inserting a valid JSON into payload is highly recommended!

Securitybasic or X-PriceFx-jwt
Request
path Parameters
tableName
required
string

A name of the table you want upload data to.

Request Body schema: application/json
object
header
Array of strings
data
Array of any
Responses
200

A general response that contains data property with a content depending on returned objects (e.g., Product master table fields when calling the /fetch/P endpoint). Can be null.

Response Schema: application/json
object
node
string
data
object or null
status
integer
startRow
integer
endRow
integer
Request samples
application/json
{
  • "data": {
    • "header": [
      • "sku",
      • "customer",
      • "record",
      • "payload"
      ],
    • "data": [
      • [
        • "A1",
        • "83-3126689",
        • 1,
        • "{ ... JSON ... }"
        ],
      • [
        • "A1",
        • "45-0245039",
        • 1,
        • "{ ... JSON ... }"
        ],
      • [
        • "A2",
        • "02-0995855",
        • 1,
        • "{ ... JSON ... }"
        ]
      ]
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "string",
    • "data": null,
    • "status": 0,
    • "startRow": 0,
    • "endRow": 0
    }
}