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
maxJoinFieldsLengths
Array of objects
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,
      • "maxJoinFieldsLengths": [ ]
      },
    • "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
    }
}