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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

Financial Report API with Row Definition & Column Definition

(1) ShareShare
ReportReport
Posted on by 4

Hello Team , 

Is there any standard Api solution where i can download financial report data as per Row & Column definition column structure at run time date filter in postman to integrate with my third party tool.

 

Currently I'm using Financial report web service KPI Setup feature but it's return only Row definition data. Any better solution really help me out for automation,

 

 

I have the same question (0)
  • Suggested answer
    11manish Profile Picture
    1,213 Super User 2026 Season 2 on at

    Unfortunately, there is no standard Microsoft API that returns a Financial Report (Management Reporter/Financial Reporting) with its complete row definition, column definition, reporting tree, and runtime filters in the same format that users see in Dynamics 365 Finance.

    The Financial Report Web Service (KPI Setup) that you're currently using is the only supported interface for Financial Reporting data, but as you've already found, it primarily exposes row definition/KPI data and does not reproduce the full report layout with dynamic columns.

  • André Arnaud de Calavon Profile Picture
    306,620 Super User 2026 Season 2 on at

    Hi Vishal,


    Can you tell us what Dynamics 365 application this question is related to? There are several different solutions in the Dynamics 365 family, like: Sales, Finance, Supply Chain Management, Project Operations, and Business Central. If you can clarify the product, we can answer the question or move it to the correct forum.

  • Vishal Laxkar Profile Picture
    4 on at

    Hi Andre ,

    The question is related to Dynamic 365 Business central BC Version 28.2.

    Thanks

     

  • André Arnaud de Calavon Profile Picture
    306,620 Super User 2026 Season 2 on at
    Moved the question from the Dynamics 365 General to the Dynamics 365 Business Central forum.
  • Suggested answer
    YUN ZHU Profile Picture
    102,763 Super User 2026 Season 2 on at

    As far as I know, there isn't one; you can use the following method to quickly check all the APIs in BC.

    Dynamics 365 Business Central: A simple way to view the list of all APIs

    https://yzhums.com/22845/

    You can create a custom API or use a Web Service.
    However, Web Services are no longer recommended.

    https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features-platform?wt.mc_id=DX-MVP-5004336

    Thanks

    ZHU

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 562 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 503 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 332 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans