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 :
Finance | Project Operations, Human Resources, ...
Answered

Importing thousands of GL-transactions via batch API (recurring integrations)

(0) ShareShare
ReportReport
Posted on by 485

My concern is about importing large XML-files which makes up approx. to 50k records per day. We have a middleware which can do the transformation and splitting etc, but...How much can batch API handle? Is it even possible to input such a large amount of xml-data and pass it by through the POST call? Or would there be any wiser solution?

I have the same question (0)
  • Sukrut Parab Profile Picture
    71,735 Moderator on at

    Where you want to import that data ?  I have seen import of journal lines more than 50 k records without any issue using XML format using batch  API.

  • migi111 Profile Picture
    485 on at

    Hi, the plan is to import journal lines. Does it need to be splitted in many sessions? I'm trying to understand how I should guide the developers behind the middleware system.

  • Suggested answer
    Sukrut Parab Profile Picture
    71,735 Moderator on at

    Ledger journal entity does set based operations so it's very fast and  you don't need to spilt anything. Just export the xml format  so that other system can generate exact format and pass it to the endpoint.

  • Verified answer
    nmaenpaa Profile Picture
    101,166 Moderator on at

    If the target journal entity supports set based operations, you shouldn't have any issues. However don't try to post 50 000 lines in one journal, instead split it to smaller journals (for example 500-1000 lines per journal).

    If your entity doesn't support set based operations, you might want to think about some optimization in the integration.

    I've written a blog post about the topic some years ago: community.dynamics.com/.../dynamics-365-for-operations-integration-performance-tuning-tips

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 617

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans