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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Business Central API Issues

(0) ShareShare
ReportReport
Posted on by

I've done a bit of searching and haven't really seen much on this. I'm trying to integrate the Business Central API with another 3rd party software and am noticing a few differences between the data shown in BC and the responses I'm seeing.

I'm only working with the test company Cronus. 

I've noticed that the api.businesscentral.dynamics.com endpoints I'm hitting are missing data. I'm requesting the general ledger entries and noticed even when filtered specifically for a date (April 8th 2019) that it isn't returning all of the records that are available in the General Ledger Entries view (images below). I looked through the documentation but haven't seen anything that says it API requests like this would filter or be missing data. In this case the BC view has 9 entries visible while the API request only has 2 for the same date search, is there a reason why the 7 other entries are left out? Am I missing something in the request I'm making?

2020_2D00_01_2D00_07_5F00_10_2D00_56_2D00_51.png
2020_2D00_01_2D00_07_5F00_10_2D00_57_2D00_50.png

I've also noticed a few differences between the endpoints(api.businesscentral.dynamics.com) and the graph api finances endpoint. Running the same /generalLedgerEntries request on the graph side of things it doesn't have the dimensions field, is this something that is going to be depreciated? I also noticed that the graph endpoint is pulling more data back, in total the api.businesscentral.dynamics.com endpoint is returning 3505 total items while the graph endpoint is returning 3512 items (images below). Is there a reason why the graph endpoint returns more information than the other?
2020_2D00_01_2D00_07_5F00_15_2D00_10_2D00_04.png

2020_2D00_01_2D00_07_5F00_15_2D00_11_2D00_02.png

 

Thanks ahead of time for your responses. Let me know if I need to provide more information to help. 

Cheers, 

Al

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

    Point 1 is absolutely crazy... your call is correct and data should be returned exacly like in the G/L Entry table (so 9 records). The view you show above comes from the same environment as the API call? The API call is connected to the Sandbox environment (called "Sandbox").

  • Suggested answer
    Olister Rumao Profile Picture
    3,967 on at

    Hi,

    You can add the page as WebServices and then call the pages with the ODATA URL Link.

    I think this will be a faster process rather than creating your own API Page.

    Let me know if you need any help!

  • Community Member Profile Picture
    on at

    Oops! I think I might have been looking a little too closely to the problem to see the big picture. You're right I was requesting the sandbox data but looking at the production data set in dynamics. Removing the sandbox section of the API call I got the same data back. Thanks!

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans