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

API Connection

(1) Share

Report

Posted on by LF-16052033-0

346

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?

All responses (4)

Answers (0)

Suggested answer

MarceloBorges 116 on at

Like (2)

Report

API Connection

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!
YUN ZHU 81,365 Super User 2025 Season 1 on at

Like (1)

Report

API Connection

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
Valentin Castravet 27,640 Super User 2025 Season 1 on at

Like (1)

Report

API Connection

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/
gdrenteria 17,492 Most Valuable Professional on at

Like (0)

Report

API Connection

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