web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Web Services, SOAP or ...
Small and medium business | Business Central, N...
Suggested Answer

Web Services, SOAP or ODATA

(0) ShareShare
ReportReport
Posted on by MindfulGaze 10

If multiple eCommerce sites with a considerate amount of traffic were to be connected to business central how could the API handle simultaneous requests  posting sales to the API from different websites?

SOAP is blocking them due to locked tables because it treats each request as a transaction on the database.

Is there any way of changing this behavior?

Would it be better if ODATA Web services were used to handle these kind of scenarios? Knowing there will be  some occasions with prolonged hours of continuous messaging to the API due to the high amount of Sales.

Thank You!

I have the same question (0)
  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Each request is always a transaction on the db. SOAP and ODATA has the same limits on number of requests admitted (10 requests for second), you need to handle that.

  • MindfulGaze Profile Picture
    MindfulGaze 10 on at

    SOAP treats each request as a transaction, request lock all tables therefore if an Order takes 3seconds to create I can't send 10request each second because Business Central can't handle that because of the limitations of the transaction locking all tables.

    Are you sure ODATA treats each request as a transaction that locks all tables? That would mean business central ins't a software that can handle big amout of data from multiple eccomerce websites right?

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    All tables no. I mean that the action you're performing is threaded as a transaction by the SQL level. So for example, posting an order involves locking on some tables and this is standard behaviour to guarantee consistency.

  • rahulthakur Profile Picture
    rahulthakur 5 on at

    I am using the AWS Consulting Services from the last 6 month and store our data online in a cloud, it is the most powerful and secure data storage services with complete trust in today's time. Whizlabs provide this service if you also want to store the data then visit on google!

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    if the number of Post is high, I think it is better to have a table as a buffer. creat a web service SOAP for inserting data from 3rd party app into the buffer table. then create a Job Queue to process the records in the buffer table to create and post the documents.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,024 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,145 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 705 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans