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

ve

(2) Share

Report

Posted on by Miscrosoft Dynamcis GP

Hello,

I have used ODATA service to get details of 'NoSeriesLines' of VEND , it is working fine.

I want to update the Last_No_Used in NoSeriesLines (as shown in highlighted image) using below code

string updateUrl = "https://api.businesscentral.dynamics.com/v2.0/acb64e3567a44d24e/Sandbox/ODataV4/Company('CRONUS%20USA%2C%20Inc.')/NoSeriesLines?$filter=Series_Code eq 'VEND'";

// Construct the HTTP request
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(updateUrl);
request.ContentType = "application/json";
request.Method = "PATCH"; // Use PATCH for updating records

// Add authorization header
request.Headers.Add("Authorization", "Bearer " + authToken);

// JSON payload for updating Last_No_Used
string jsonPayload = @"
{
""Last_No_Used"": Last_No_Used
}";

but, it is giving error of 'The remote server returned an error: (405) Method Not Allowed.', as per error looks like ODATA web service I am using for update record is not correct.

Please help me to find the correct ODATA webservice page to update the records in NoSeries in BC.

All responses (4)

Answers (0)

Suggested answer

gdrenteria 12,290 Most Valuable Professional on at

Like (1)

Report

ve

Hi

I would tell you to rely on customized APIs.

How To Create Custom APIs In Business Central - Business Central Geek

BEst

API (v2.0) for Dynamics 365 Business Central - Business Central | Microsoft Learn

GR
Suggested answer

Ramiz 344 on at

Like (1)

Report

ve

Hi,

Hope this helps.

https://yzhums.com/38278/
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report

ve

Hi, It looks like you published this page directly to the Web Service

Unfortunately, this field is a variable and Editable is false, so it cannot be edited.

You can choose to create a new list page and publish it to the Web Service, or create an API page.

Hope this helps.

Thanks.

ZHU
Suggested answer

VaHiX 3,119 on at

Like (1)

Report

ve

Ensure that the OData service endpoint supports the HTTP method you’re using. In Business Central, certain endpoints might only support GET and POST methods, not PATCH or PUT.

** Please don't forget to close up the thread here by Like and verify it as an answer if it is helpful **