create a Custom API to update Sales Order Status

(1) Share

Report

Posted on by SG-05091051-0

163

Hi All,

We are using On-Prem Business central.

I want to create a custom API to update status of my sales order header.
I will send below JSON as request body.

{

"OrderNo" : "10001",

"Status" : "Open"

}

This API should update the Sales header status of 10001 No.
If anyone have any idea, please share or if you have any code snip you can share.

Thanks for your help.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Suggested answer

Mohamed Amine Mahmoudi 26,811 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Please refer to this :

https://yzhums.com/6117/

https://stackoverflow.com/questions/64817825/ms-dynamics-365-business-central-api-post-patch-delete-does-not-work

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Verified answer

Sami Ullah 315 Moderator on at

Like (4)

Report
Copy link

Link copied!
Hi,

You can use the following link for API authentication:

https://yzhums.com/20690/

Additionally, learn how to create a new dataset here:
https://onlinehelpcrm.azurewebsites.net/HelpFiles/MEM_D365BC_Help/Content/Topics/NAV_/API/API-Overview.htm

To make an API call in Postman, follow this guide:
https://yzhums.com/6117/

However, when updating the status, note that this field is read-only in Business Central. You will need to use a codeunit to update the status.

Watch this video to understand how to call a codeunit:
https://www.youtube.com/watch?v=onZav5n0zqk

Example Codeunit:
codeunit 50100 "SalesOrderProcessing" { Permissions = tabledata "Sales Header" = rimd; procedure UpdateSalesOrderStatus(orderno: Text[50]; status: Text[50]): Text var SalesOrder: Record "Sales Header"; begin SalesOrder.Reset(); SalesOrder.SetRange("Document Type", "Sales Document Type"::Order); SalesOrder.SetRange("No.", orderno); if SalesOrder.FindFirst() then begin case status of 'Open': SalesOrder.Status := SalesOrder.Status::Open; 'Released': SalesOrder.Status := SalesOrder.Status::Released; end; SalesOrder.Modify(true); end else exit('Sales Order not found.'); end; }

Example HTTP API Call
POST /v2.0/{your tenantID}/Production/ODataV4/SalesOrderProcessing_UpdateSalesOrderStatus Host: api.businesscentral.dynamics.com Content-Type: application/json If-Match: * company: 2006d1d5-1a4e-ef11-bfe7-6045bde9c989 // your company ID Authorization: Bearer {Provide Token} { "orderno": "S-ORD101001", "status": "Released" }

Was this reply helpful? Yes No

Join the conversation

Community site session details

create a Custom API to update Sales Order Status

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

create a Custom API to update Sales Order Status

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates