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

API Connection

(1) Share

Report

Posted on by LF-16052033-0

526

Hello experts,

Is there an API from business central that takes single Sales Order number parameter and returns a singular data object (billing and shipping detail) specific to that Sales Order number?

I have the same question (0)

All responses (4)

Answers (0)

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

Like (0)

Report

Hi

This is the standard API that allows you to obtain sales order data, if you want something additional or with more data, you must create your own API.

Get salesOrders - Business Central | Microsoft Learn

Developing a custom API - Business Central | Microsoft Learn

BR

GR

Was this reply helpful? Yes No
Valentin Castravet 31,485 Super User 2025 Season 2 on at

Like (1)

Report

Adding more info - Work with the API in Dynamics 365 Business Central - Training | Microsoft Learn

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
YUN ZHU 95,739 Super User 2025 Season 2 on at

Like (1)

Report

Hi, As far as I know, this is not possible in the standard SalesOrder API. There is no billing and shipping detail in the Navigation of the standard SalesOrder API.

PS: Dynamics 365 Business Central: How to use filter expressions in API related resource ($expand)

https://yzhums.com/51400/

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

MarceloBorges 122 on at

Like (2)

Report

Have you tried using OData Web Services? You could create an OData Web Service for the Sales Order Page, pass a filter on the URL, and get specific Sales Order fields:

Here's how you can create an OData Web Service in BC -- It doesn't require Development, it's a Setup page in BC:

Publish a Web Service - Business Central | Microsoft Learn

Here's how to pass filters on an OData URI:

Using Filter Expressions in OData URIs - Business Central | Microsoft Learn

Here's how you can determine which fields you would like to get back on your call:

OData/API web service client performance - Business Central | Microsoft Learn

I hope this helps!

Was this reply helpful? Yes No