---
title: "Insert Bulk Data From a File"
method: POST
path: "/loaddata.file/{TypeCode}"
tags: ["General"]
---

# Insert Bulk Data From a File

`POST /loaddata.file/{TypeCode}`

Inserts multiple records to the Master Data table from the CSV file.<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>
>If used in a Groovy logic, it is recommended to use the [api.addOrUpdate()](https://qa.pricefx.eu/pricefx-api/groovy/develop/net/pricefx/formulaengine/scripting/PublicGroovyAPI.html#addOrUpdate(java.lang.String,java.util.List)) method instead of this loaddata endpoint within the boundCall().<br>
>For more details see the [Avoid api.boundCall](https://pricefx.atlassian.net/wiki/spaces/KB/pages/2511699985/Avoid+api.boundCall) article.
<p>

<!-- 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.file** 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.

## Query parameters

- `name` string

## Response `200`

OK

- object
  - `response` object
    - `node` string
    - `data` object[]
      - `uploadStatusId` integer
      - `loadedRecords` integer
      - `invalidRecords` integer
      - `totalRecords` integer
    - `status` integer

---

[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)