---
title: "Insert Bulk Products"
method: POST
path: "/loaddata/P"
tags: ["Products"]
---

# Insert Bulk Products

`POST /loaddata/P`

Inserts multiple products to the Master Data table.<p>
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**).<p>
Use the [ISO 8601](https://www.iso.org/iso-8601-date-and-time-format.html) date format (YYYY-MM-DD) if a date is included in the table.
<!-- theme: warning -->
>**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.

## Request body

- object
  - `data` object, required
    - `header` string[], required — Specify header field names (table columns) of the record in the target table.
    - `options` object — Specify options of the bulk data insertion.
      - `detectJoinFields` boolean — Set to `true` to use join fields definitions from the server. Set to `false` to specify join fields with the `joinFields` parameter in the request.
    - `data` array[], required — Specify the field values in the same order as specified in the header object.
      - unknown[]
        - unknown

## Response `200`

Returns the number of inserted or updated objects.

- object
  - `response` object
    - `node` string
    - `data` unknown[]
      - unknown
    - `status` number

## Other responses

- `400` — Bad Request - Invalid command parameters

---

[API](https://skmtc.net/pricefx/apis/the-pricefx-backend-api.md) · [All operations](https://skmtc.net/pricefx/apis/the-pricefx-backend-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/pricefx/the-pricefx-backend-api/versions/0850b5d6be73/schema)