web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Verified answer
    nmaenpaa Profile Picture
    101,160 Moderator on at
    RE: Importing thousands of GL-transactions via batch API (recurring integrations)

    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

  • Suggested answer
    Sukrut Parab Profile Picture
    71,699 Moderator on at
    RE: Importing thousands of GL-transactions via batch API (recurring integrations)

    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.

  • migi111 Profile Picture
    485 on at
    RE: Importing thousands of GL-transactions via batch API (recurring integrations)

    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.

  • Sukrut Parab Profile Picture
    71,699 Moderator on at
    RE: Importing thousands of GL-transactions via batch API (recurring integrations)

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,206

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 847 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 596 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans