Rollback in bulk Insert using API calls

navuser1
navuser1 Member Posts: 1,334
in NAV Three Tier
Hi,

Inserting multiple records into the Business Central database using API calls is possible. We can also combine several operations at a single request.

However, if any part of the request fails, I may need to roll back the entire operation. How can I achieve this? Additionally, how can I test it in Postman?

I attempted using the Snapshot isolation level, but it didn't work.

Please guide me to tackle this matter.

Thank you,
navuser1
Now or Never

Answers

  • maxklein
    maxklein Member Posts: 8
    Create a custom API page (or action) in AL that accepts multiple entities in a single payload. Inside the AL codeunit, you can use STARTSESSION, COMMIT, or even ERROR() logic to control transactions server-side.
    This gives you full control to rollback if anything fails.

    Example approach:

    Create a custom codeunit with a function like ProcessCustomerAndOrder()

    Call that function from a custom API endpoint.

    Inside AL, you insert records and trigger a ERROR() if any fail, so nothing gets committed.

    Developer by passion

Categories