Dynamics Community Forum Thread Details

I encountered with the Cash Flow Statement API. I expected the API to return values for each date within the specified range of 2024-01-01 to 2024-12-31. However, the response only provides values for the end date, 2024-12-31. For reference, I have been using the following API call:GET https://api.businesscentral.dynamics.com/v2.0/{settings.DYNAMICS_TENANT_ID}/{settings.DYNAMICS_ENVIORNMENT}/api/v2.0/companies({organization_id})/cashFlowStatements?$orderby=lineNumber&$filter=dateFilter ge 2024-01-01T00:00:00Z and dateFilter le 2024-12-31T23:59:59Z
{
    "1": {
        "@odata.etag": "W/\"JzIwOzEwMTI5MDMxMjU2NTA4Mjk2OTM1MTswMDsn\"",
        "id": "7a87816e-9123-ef11-840f-6045bdc8db8f",
        "lineNumber": 20000,
        "display": "Net Income",
        "netChange": 30182.36,
        "lineType": "detail",
        "indentation": 0,
        "dateFilter": "2024-12-31"
    },
    "2": {
        "@odata.etag": "W/\"JzIwOzE2MDg4MjQ0NTQ4MzY4MTc1NzIzMTswMDsn\"",
        "id": "7b87816e-9123-ef11-840f-6045bdc8db8f",
        "lineNumber": 30000,
        "display": "Adjustments to reconcile Net Income to net cash provided by operations:",
        "netChange": 0,
        "lineType": "detail",
        "indentation": 0,
        "dateFilter": "2024-12-31"
    }
}   ... Could you please guide me on how to retrieve the cash flow statement values for each date within the specified range using the api?

Thank you for your assistance.

Quick Links

Leaderboard