Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Read Trail Balance Rep...
Small and medium business | Business Central, N...
Suggested answer

Read Trail Balance Report With API

(0) ShareShare
ReportReport
Posted on by DS-15051354-0 106
I would like to be able to read reports via a API/ODATA. What would be the best way to do that?
Is there a best way to read a report like a Trial Balance with an API and then display in a table?
Thanks,
Keith
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,312 Super User 2025 Season 1 on at
    Read Trail Balance Report With API
    Hi,
     
    in the Financial Report Extension Microsoft have released API Queries. 
     
    All Queries can be consumed using Power BI or any other tool that can consume Rest API. 
     
    Regards,
    Saurav Dhyani
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,904 Super User 2025 Season 1 on at
    Read Trail Balance Report With API
    Please mark the answer as verified if it helped.
  • DS-15051354-0 Profile Picture
    DS-15051354-0 106 on at
    Read Trail Balance Report With API
    thanks that's just what I am looking for.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,904 Super User 2025 Season 1 on at
    Read Trail Balance Report With API
     
    In the Web Services page there is also a trial balance service out of the box that you can use
     
     
     
     
  • DS-15051354-0 Profile Picture
    DS-15051354-0 106 on at
    Read Trail Balance Report With API
    I would like to read the report in a PHP application and then display it.
     
    Is that possible using API/ODATA?
     
    Is there an API/ODATA I can use.
     
    Thanks Keith
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,904 Super User 2025 Season 1 on at
    Read Trail Balance Report With API
    You can use excel to view odata feeds with data from Business Central. You can also use Power BI to view an API from Business Central. Both would work to view a trial balance.
     

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

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... 293,311 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,183 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans