web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... API's - Use Buffer tab...

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

Suggested answer

API's - Use Buffer table as the source Table

(1) Share

Report

Report

Posted on by Hein Kruger

607

Hi,
I looked at the Base Sales Order API (https://github.com/microsoft/ALAppExtensions/blob/main/Apps/W1/APIV2/app/src/pages/APIV2SalesOrders.Page.al)

The Source Table is a Buffer table: "Sales Order Entity Buffer";

Is this best practise to use a buffer table prevent deadlocks or why would you not directly use the Sales Header and Sales Line tables?

Thank you in Advance

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Khushbu Rajvi. 19,052 Super User 2025 Season 2 on at

Like (2)

Report

API's - Use Buffer table as the source Table

Using buffer tables in Business Central is primarily for enhancing performance, managing concurrency, and ensuring data integrity during transactions. Buffer tables facilitate optimized data handling, reduce the risk of deadlocks by allowing multiple processes to interact without directly locking primary tables, and help in validating changes before they affect the main data structure. This practice simplifies the API interactions and improves overall efficiency in data processing.

Hope this helps https://yzhums.com/4223/

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sumit Singh 2,710

#2

Sohail Ahmed 2,675 Super User 2025 Season 2

#3

Jeffrey Bulanadi 2,203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans