Insert Bulk Customers

post/loaddata/C

Inserts multiple customers to the Master Data table.

The /loaddata operation is a very efficient and quick way to insert bulk data to the Master Data table. The main advantage is its greater speed when loading thousands of records (compared to e.g. /integrate).

Please note If no joinFields are provided in the request, then this operation will insert entire records. It means that in this case (without joinFields) with /loaddata it is not possible to update just some fields (for this use the /integrate endpoint instead). The source data must always contain the entire row’s content.

Securitybasic or X-PriceFx-jwt
Request
Request Body schema: application/json

Specify customer field names in the header object and fields values in the data object.

Information: Field names (columns) sent in your request might be different from our sample request schema. Custom fields (attribute1..attribute30) can be retrieved using the /fetch/CAM endpoint.

required
object
header
required
Array of strings
object
detectJoinFields
boolean
data
required
Array of strings
Responses
200

Returns the number of inserted or updated objects.

Response Schema: application/json
object
node
string non-empty
data
Array of any
status
number
Request samples
application/json
{
  • "data": {
    • "header": [
      • "customerId",
      • "name",
      • "attribute1",
      • "attribute2"
      ],
    • "options": {
      • "detectJoinFields": true
      },
    • "data": [
      • [
        • "00001",
        • "John Doe",
        • "The Street 11, NY",
        • "123456789"
        ],
      • [
        • "00002",
        • "Tom Jones",
        • "High Street 23, London",
        • "123456789"
        ],
      • [
        • "00003",
        • "Kate Smith",
        • "Derry Lane",
        • "123456789"
        ]
      ]
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "<the server>",
    • "data": [
      • 3
      ],
    • "status": 0
    }
}