web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to get sales line ...

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

Answered

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

(1) Share

Report

Report

Posted on by Alina Fahim Ibrahim

194

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 Img

All responses (4)

Answers Img

Answers (2)

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (0)

Report

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,005 Super User 2025 Season 2 on at

Like (0)

Report

Expand is not supported on web services.

Use it on APIs.

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 25,369 Most Valuable Professional on at

Like (1)

Report

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 95,741 Super User 2025 Season 2 on at

Like (0)

Report

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

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,066

#2

YUN ZHU 658 Super User 2025 Season 2

#3

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans