As far as I know, Acumatica only allows you to PUT one entity at a time. Is there any way to do a bulk upload of entites (eg. Stock Items, Journal Transactions etc)?
If it’s not possible to do it within Acumatica, can it be done with a custom API or a wrapper and what would that look like?
Best answer by jinin
Hi @petar2903k ,
yes, you are right
Approach 1: Import Scenario
For bulk uploads, data from the external system is converted into a CSV or XML file.
This file is placed in a shared or cloud location using File Sync.
An Import Scenario is configured in Acumatica to read the file and create/update records.
An Automation Schedule can be used to run the import automatically.
This approach is reliable and works well for processing large volumes of data.
Approach 2: Custom API / Custom Screen
A custom API or screen can be created in Acumatica.
Bulk data can be sent as a JSON array or as a string to avoid size limits.
Custom logic will read the data and create records programmatically in Acumatica.
This approach works but requires additional development and ongoing maintenance.
The Acumatica REST API does not support batching multiple records in a single request. For bulk data uploads, Import Scenarios should be used, as they are designed to efficiently handle large volumes of records. Please refer to the link below for more details.
The Acumatica REST API does not support batching multiple records in a single request. For bulk data uploads, Import Scenarios should be used, as they are designed to efficiently handle large volumes of records. Please refer to the link below for more details.
If the requirement is to support bulk uploads via API from an external system, would the simplest approach be to expose an API that converts incoming JSON into an Acumatica import scenario file stored in the cloud, and then rely on Acumatica File Synchronization plus an Automation Schedule to automatically pick up and execute the import scenario?