cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Business Central Connection

Hi,

I am trying to query using postman for the Account Schedule Line Table. Looking specifically for the totaling and Dimension 2 Totaling columns.


If I try this:

https://api.businesscentral.dynamics.com/v2.0/{tenantID}/Production/ODataV4/{CompanyID}/powerbifinan...

I am able to get something like this

 

 

"value": [
        {
            "@odata.etag": "W/\"JzQ0O2RaeGZDSmZ6aVNkZmFqcFNRMjNXNUU2dnFpMURwZWpMek13UHlidWloMmM9MTswMDsn\"",
            "No": 1,
            "Date": "2019-01-01",
            "Closed_Period": true,
            "Account_Schedule_Name": "_INC_ALL",
            "KPI_Code": "code",
            "KPI_Name": "NET INCOME (LOSS)",
            "Net_Change_Actual": 0,
            "Balance_at_Date_Actual": 0,
            "Net_Change_Budget": 0,
            "Balance_at_Date_Budget": 0,
            "Net_Change_Actual_Last_Year": 0,
            "Balance_at_Date_Actual_Last_Year": 0,
            "Net_Change_Budget_Last_Year": 0,
            "Balance_at_Date_Budget_Last_Year": 0,
            "Net_Change_Forecast": 0,
            "Balance_at_Date_Forecast": 0
        },

 

 

 

 

But When I export the Config File and get the Acc. Schedule Line table it has more columns then the powerbifinance query.

 

I have also tried using the webservice endpoint to look for endpoints that could get me this table(I have tried Account_Schedules and Acc_Schedule_Overview) which both have relvant information but not the columns im looking for.

 

 

How should I approach this? Or is it even possible to get that information?

Thanks!

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,852)