Share
ReportHi,
Im trying to use the business central api to get income statement data. Im using this endpoint:
https://{businesscentralPrefix}/api/v2.0/companies({id})/incomeStatements?$orderby=lineNumber&$filter=dateFilter ge 2019-01-01 and dateFilter le 2020-12-31
im getting data back with the correct rows from the configured income statement report but all my numbers are empty. is there a setup step im missing. is this the expected response. if so what is the call to actually get the data.
{
/@odata.etag/: /W////JzE5OzE1MTc3Mzg3NzYzMjAzMTQzNTExOzAwOyc=////,
/id/: /b0809aa4-d7b3-ee11-a56a-002248238fc1/,
/lineNumber/: 310000,
/display/: /OPERATING EXPENSE/,
/netChange/: 0,
/lineType/: /header/,
/indentation/: 0,
/dateFilter/: /2023-12-01/
},
{
/@odata.etag/: /W////JzIwOzE2MTI1ODI1OTU1MjU4NzIxODEzMTswMDsn////,
/id/: /b1809aa4-d7b3-ee11-a56a-002248238fc1/,
/lineNumber/: 320000,
/display/: /ADVERTISING & MARKETING/,
/netChange/: 0,
/lineType/: /detail/,
/indentation/: 1,
/dateFilter/: /2023-12-01/
},
{
/@odata.etag/: /W////JzE5OzYyMDU1ODQ3NTQ4ODM2OTAwNTcxOzAwOyc=////,
/id/: /b2809aa4-d7b3-ee11-a56a-002248238fc1/,
/lineNumber/: 330000,
/display/: /BANK CHARGES/,
/netChange/: 0,
/lineType/: /detail/,
/indentation/: 1,
/dateFilter/: /2023-12-01/
},
{
/@odata.etag/: /W////JzIwOzE1MjA4Nzc0Nzg2MjI2Njc3ODEzMTswMDsn////,
/id/: /b3809aa4-d7b3-ee11-a56a-002248238fc1/,
/lineNumber/: 340000,
/display/: /INTEREST EXPENSE/,
/netChange/: 0,
/lineType/: /detail/,
/indentation/: 1,
/dateFilter/: /2023-12-01/
},
{
/@odata.etag/: /W////JzIwOzEwMjU3MzExOTI2MDg3Nzc1NjgyMTswMDsn////,
/id/: /eef9d545-b6b8-ee11-a568-6045bdef6e36/,
/lineNumber/: 350000,
/display/: /SALARIES/,
/netChange/: 0,
/lineType/: /detail/,
/indentation/: 1,
/dateFilter/: /2023-12-01/
},
im expecting this
All responses (
Answers (
12,183
