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

  • RE: Business Central API Issues

    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!

  • Suggested answer
    Olister Rumao Profile Picture
    Olister Rumao 3,957 on at
    RE: Business Central API Issues

    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!

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Business Central API Issues

    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").

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans