Upload a Bulk Data to Data Source

post/datamart.loaddata/{datasourceUniqueName}

Uploads a chunk (batch) of data from a client resource to the storage reserved for a particular Data Source.

The uploaded data is not immediately transfered to the Data Source database table. Instead it is held (‘buffered’) in a staging area, until an explicit flush command is issued (refer to the /datamart.rundataload endpoint, "type": "DS_FLUSH"), or a Datamart dependent on the Data Source data is refreshed.

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

The unique name of the Data Source where you want to upload the data to. You can also use typedId or the source name.

Request Body schema: application/json
required
object
header
required
Array of strings

Specify header field names (table columns) of the record in the target Data Source.

object

Specify options of the bulk data insertion.

detectJoinFields
boolean
maxJoinFieldsLengths
Array of objects
data
required
Array of any

The data as a list of lists, with the inner lists representing rows, its field values appearing in the same order as specified in the header list.

Responses
200

OK

Response Schema: application/json
object
node
string
data
Array of integers or null
status
integer
Request samples
application/json
{
  • "data": {
    • "header": [
      • "sku",
      • "label",
      • "attribute1",
      • "attribute2"
      ],
    • "options": {
      • "detectJoinFields": true,
      • "maxJoinFieldsLengths": [ ]
      },
    • "data": [
      • [
        • "11111",
        • "Label One",
        • "EA",
        • "USD"
        ],
      • [
        • "22222",
        • "Label Two",
        • "EA",
        • "EUR"
        ],
      • [
        • "33333",
        • "Label Three",
        • "EA",
        • "CZK"
        ]
      ]
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "string",
    • "data": null,
    • "status": 0
    }
}