v1

latestOpenAPI 3.0.02026-08-064842333.5 MB
General

Insert Bulk Data

Inserts multiple records 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 date format (YYYY-MM-DD) if a date is included in the table.<p> See the list of bulk-loadable objects.

If used in a Groovy logic, it is recommended to use the api.addOrUpdate() method instead of this loaddata endpoint within the boundCall().<br> For more details see the Avoid api.boundCall article.

<p>

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.

post/loaddata/{TypeCode}

Request body

Response

Returns the number of inserted or updated objects.