Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Fetching Child records along with Parent Records in Web API (Business Central)

(0) ShareShare
ReportReport
Posted on by 2,051

Hi All, 

Is there anyways to display Child records along with Parent Records using Web API in Business Central? 

For example if my API returns data of Purchase Header we want its associated purchase lines to be displayed. Can anyone please suggest a way out?

Thanks in Advance   

  • Lars Lohndorf-Larsen Profile Picture
    on at
    RE: Fetching Child records along with Parent Records in Web API (Business Central)

    Hello,

    I think that this article will help you:

    docs.microsoft.com/.../devenv-develop-custom-api

    Look for Example 4 and the example with the $expand parameter:

    GET api.businesscentral.dynamics.com/.../companies(<company id>))/carBrands(<car brand id>)?$expand=carModels

    It also depends on how the api page is designed but I think that the standard Purchase Order api will allow you to use $expand to get both header and lines in one call.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 428 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 302

#3
Sagar Dangar, MCP Profile Picture

Sagar Dangar, MCP 276

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans