Dynamics Community Forum Thread Details

API Pages - multi level response

We would like to do an API call that for each customer returns the related Posted Sales Invoice and for each invoice returns the related invoice lines i.e. 3 levels nested. The API should return a response in the following format. How can we do this?

We've already managed to get to the second level by creating an API page (customers) with a part linked to another API Page (slaes Invoice Header) but how do we get the third level (Sales Invoice Lines)?

{
    "@odata.context": "https://api.businesscentral.dynamics.com/v2.0/......",
    "value": [
        {
            "@odata.etag": ".........",
            "customerNo": "189",
            "name": "TestAcc1",
            "balance": 110.7,
            "balanceDue": 110.7,
            "salesInvoices": [
                {
                    "@odata.etag": ".....",                    
                    "documentNo": "SI000008",
                    "invoiceid": "8893b289-0af5-f011-8405-7c1e525fbab0",
                    "documentdate": "2026-01-19",
                    "amount": 49.2,
                    "remainingAmount": 49.2,
                    "open": true,
                    "salesInvoiceLines": [
                        {
                            "@odata.etag": ".....",                    
                            "documentNo": "SI000008",
                            "lineno": "100000",
                            "itemno": "ABC123",
                            "quantity": 1
                        },
                        {
                            "@odata.etag": ".....",                    
                            "documentNo": "SI000008",
                            "lineno": "200000",
                            "itemno": "ABC456",
                            "quantity": 1
                        }
                    ]
                },
                {
                    "@odata.etag": ".....",                    
                    "documentNo": "SI000008",
                    "invoiceid": "8893b289-0af5-f011-8405-7c1e525fbab0",
                    "documentdate": "2026-01-19",
                    "amount": 49.2,
                    "remainingAmount": 49.2,
                    "open": true,
                    "salesInvoiceLines": [
                        {
                            "@odata.etag": ".....",                    
                            "documentNo": "SI000003",
                            "lineno": "100000",
                            "itemno": "XYZ123",
                            "quantity": 1
                        }
                    ]
                }
            ]
        }
    ]
}

Categories:

Dynamics 365 Business Central

Quick Links

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