Small and medium business | Business Central, N...

Where to find API support

(0) Share

Report

Posted on by Robbe Verscheure

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!

All responses (5)

Answers (0)

Suggested answer

Steven Renders 5,051 Super User 2024 Season 1 on at

Like (0)

Report

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 5 on at

Like (0)

Report

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 5,051 Super User 2024 Season 1 on at

Like (0)

Report

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 74,115 Super User 2024 Season 2 on at

Like (0)

Report

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

Hope this helps.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 32,748 Super User 2024 Season 1 on at

Like (0)

Report

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.