Small and medium business | Business Central, N...

Reduce API Response Time.

(5) Share

Report

Posted on by CU08050848-0

268

Hi All,

I have created a Codeunit to modify data in Business Central from a third-party application via API integration. The Codeunit follows these steps:

Validate if the Sales Order No. is blank.
Check the Sales Order status; if the status is open, the Sales Order is allowed to be edited in the third-party application.
Delete staging data in the Instrument Sales Header and Instrument Sales Line tables based on the Sales Order No.
After deleting existing data, re-enter the data based on the JSON object.
Once the staging tables are updated, modify data in the Sales Header and Sales Line tables based on the Sales Order No.
After updating the Sales Header and Sales Line tables, automatically send the Sales Order for approval.

The Codeunit is working, but the API response time is currently too high—it takes about 5.25 seconds. After some optimizations, the response time has been reduced to 4.34 seconds.

I want the response to be in milliseconds, ideally less than 1 second. Please check the attached file of AL code and advise.

EditSalesOrder AL...

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Steven Renders 5,698 Moderator on at

Like (4)

Report
Copy link

Link copied!

Performance overview - Business Central | Microsoft Learn

Performance article for developers - Business Central | Microsoft Learn

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/performance/performance-developer#writing-efficient-web-services

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,177 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Maybe following blog will give you a hint

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-connect-apps-tips

https://community.dynamics.com/forums/thread/details/?threadid=0aa79aff-4054-4c6e-aac8-f17dcc8f524e

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,566 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

use an async API pattern for “sub-second” For true <1s: accept the payload, enqueue work, return 202 Accepted, and process in a background session. That’s the standard web API guidance—and BC supports background sessions

https://businesscentralgeek.com/how-to-run-background-processes-in-business-central-startsession?utm

Thanks, Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,792 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Adding more details:https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/dynamics-rate-limits

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,799 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi,

To optimize your Codeunit for API integration in Business Central and reduce response time, here are few strategies and official Microsoft resources:
Official Microsoft Learn Links

Performance for Developers [2]

Web Service Performance [1]

OData/API Client Performance [3]

API Limits and Throttling [4]

Optimization Tips

Avoid temp tables for large datasets; they slow down performance.

Use API pages or queries instead of UI pages for web service endpoints.

Batch operations using $batch to reduce multiple calls.

Limit data using $filter, $top, and $select to reduce payload.

Avoid parallel inserts for child records under the same parent.

Use unbound actions for Codeunit procedures exposed via OData.

Split long-running requests and implement retry logic for throttling.

Mark the Boolean true “Does this answer your Question” if this was Helpful.

Was this reply helpful? Yes No