How to do bulk array upload via API?

Hi ​@petar2903k 

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.

Bulk Upload Stock Items in 2020 R1 | Community

Thank you. 

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?

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.