Small and medium business | Business Central, N...

Answered

How to get sales line and sales header data in one API?

(1) Share

Report

Posted on by Alina Fahim Ibrahim

204

How to get data of sales line and sales header in single API in business central?

I am using this https://api.businesscentral.dynamics.com/v2.0/38c7f420-d46c-4e75-ab40-5fd542423bda/KAISPEDEV/ODataV4/Company('Kaispe_test')/SalesOrder?$expand=SalesLines

but it gives an error.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Ramesh Kumar 7,561 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Sales line and Sales order are 2 different table. You have expose the both tables.

https://github.com/microsoft/ALAppExtensions/tree/main/Apps/W1/APIV2/app/src/pages

Support this idea: Copilot for Planning Worksheet Check it out here: https://experience.dynamics.com/ideas/idea/?ideaid=a91ddcc7-f3ad-ef11-95f5-0022485288a6 and consider giving it an upvote!

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,218 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Expand is not supported on web services.

Use it on APIs.

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 27,054 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Become a Business Central API Superhero part 2 - Fredborg

Expanding Data with $expand in Business Central APIs: A Comprehensive Guide

Steve Endow - The Blog: Using $metadata and $expand with Business Central Web APIs

Best Regards
Gerardo

Was this reply helpful? Yes No
Verified answer

YUN ZHU 101,846 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please use the APIs.

More details:

https://yzhums.com/6117/#toc13

For example: https://api.businesscentral.dynamics.com/v2.0/7e47da45-7f7d-448a-bd3d-1f4aa2ec8f62/Sandbox251/api/v2.0/companies(fd0d0d51-099b-ef11-8a6d-002248e7a2bb)/salesorders?$expand=salesOrderLines

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to get sales line and sales header data in one API?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the April Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

How to get sales line and sales header data in one API?

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the April Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates