Insert Bulk Product Extensions

post/loaddata/PX

Inserts multiple product extensions to the Master Data table.

The name (a name of the category) and sku must be provided for each record in the header and data object within the request body. 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).

Use the ISO 8601 date format (YYYY-MM-DD) if a date is included in the table.

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 product extension field names in the header object and field values in the data object.

required
object
data
required
Array of any

The data fields. Appearing in same order as specified in header list.

header
required
Array of any

The header fields.

object
detectJoinFields
boolean
Default: true
joinFields
Array of strings

A list of fields (that also need to appear in header and `data) that make up the business key.

Array of objects

Using the maxJoinFieldsLenghts parameter you can tell loaddata that it is not needed to reserve 255 chars; instead you put there the real lengths of join Fields (based on your knowledge of the data being loaded).

Array
joinField
string

A join field name.

maxLength
integer

The maximum number of characters that a value in joinField can occupy.

Responses
200

OK

Request samples
application/json
{
  • "data": {
    • "data": [
      • [
        • "p0006028005",
        • "Products"
        ],
      • [
        • "p0006047451",
        • "Products"
        ],
      • [
        • "p0006056838",
        • "Products"
        ],
      • [
        • "p0000412926",
        • "Products"
        ],
      • [
        • "p0000014471",
        • "Products"
        ],
      • [
        • "p0000412891",
        • "Products"
        ]
      ],
    • "header": [
      • "sku",
      • "name"
      ],
    • "options": {
      • "detectJoinFields": false,
      • "joinFields": [
        • "sku",
        • "name"
        ],
      • "maxJoinFieldsLengths": [
        • {
          },
        • {
          }
        ]
      }
    }
}