Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Where to find API support
Small and medium business | Business Central, N...
Suggested answer

Where to find API support

(0) ShareShare
ReportReport
Posted on by Robbe Verscheure 5

When trying to fetch generalLedgerEntries from the v1 api, we receive the following error:

The operation has been canceled because it took longer to generate rows than the specified threshold (00:08:00). 

However, the error does not occur everytime. When trying the same request, it will sometimes succeed. Since 2 days ago, the error keeps popping up more. We have tried any form of decreasing the request load, but no fix yet. 

Therefore, I would like to be able to communicate with any kind of support for the API. Does that exist? When looking at the website, I only see supports for the platform itself, but none for the API...

Thanks in advance!

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,051 Super User 2024 Season 1 on at
    RE: Where to find API support

    In that case, raise a support ticket and Microsoft will investigate.

    Or implement telemetry and you can have a look yourself.

    5000 records is not much and should load quickly. Are you sure that's the API that is causing issues? Are there locks in the table(s) that cause the API to wait, and then timeout?

  • Robbe Verscheure Profile Picture
    Robbe Verscheure 5 on at
    RE: Where to find API support

    Thanks for the replies! We're aware of what the error means and what it causes.

    I'm just not quite following how requesting one page of 5000 generalLedgers takes over 8 minutes to process to cause this error...

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,051 Super User 2024 Season 1 on at
    RE: Where to find API support

    This error usually means your load takes longer then the timeout.

    Ledger Entries contain a lot of rows, and very rarely you need all rows in Power BI.

    Best is to develop a Query API, in which you group the data, at the level of granularity required in Power BI. This reduces the dataset, so it will take less time to load. And make sure you implement DataAccessIntenrReadOnly.

    On top of that, in Power BI you could also configure incremental load (using dataflows).

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    RE: Where to find API support

    Hi, It looks like it exceeds the limits below.

    Current API Limits (v1.0)
    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v1.0/dynamics-current-limits

    And, It's recommended that integrations move to v2.0 of the standard APIs.

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features-platform#standard-apis-beta-version

    pastedimage1683853305461v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Where to find API support

    If you need support around the API you should contact your partner. If they are not able to assist you then you should ask them to open a supportcase with Microsoft on your behalf.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans