PATCH requests for '' of EdmType 'Collection' are not allowed within Dynamics 365 Business Central OData web services

(2) Share

Report

Posted on by Nilesh Gajjar India

Hello Experts,

I am trying modify the existing record of item journal page using ODATA V4 Service in business central.

We can successfully able to run Get and Post Method But PATCH method not work correct.

Getting Following Error:

"error": {

"code": "BadRequest_MethodNotAllowed",

"message": "'PATCH' requests for 'Item_Journals' of EdmType 'Collection' are not allowed within Dynamics 365 Business Central OData web services. CorrelationId: d43828e7-0c97-44e3-a12c-2d1d03f00b4a."

Request URL:

https://api.businesscentral.dynamics.com/v2.0/81e72c25-9a37-4736-a522-63fabc8d6398/Production/ODataV4/Company('Cronus%20-%20Test')/Item_Journals

Body:

{
"Journal_Template_Name": "ITEM",
"Journal_Batch_Name": "D19BF2BD-0",
"Line_No": 10030,
"Entry_Type": "Positive Adjmt.",
"Document_No": "T000001",
"External_Document_No": "",
"Item_No": "1952",
"Location_Code": "",
"Bin_Code": "",
"Quantity": 12
}

Please advice me how to solve this issue?

Thank you in advance

I have the same question (0)

All responses (26)

Answers (2)

Suggested answer

gert@lynge.org on at

Like (0)

Report

For patch i believe you need to identify a single record with parameters in the URL (just after the webservice name) - not as fields in the body. Like this ...Item_Journals(Journal_Template_Name='ITEM',Journal_Batch_Name='D19BF2BD-0',Line_No=10030)

If you "understand" powershell i have working examples of the different OData posibilities here: https://scblog.lynge.org/?p=1105

(the blog is unfortunately in Danish, but the powershell code is in English).

You'll probably also have to implement the ETag and header If-Match functionality (which secure that you don't modify a record beeing modified by someone else at the same time). You can see how it is done in the powershell

Was this reply helpful? Yes No
Nilesh Gajjar India 2 on at

Like (0)

Report

Hi Gert Lynge,

I have try the same but got error

API URL:

api.businesscentral.dynamics.com/.../Item_Journals(Journal_Template_Name='ITEM',Journal_Batch_Name='D19BF2BD-0',Line_No=10030)

Header

If-Match W/\"JzQ0O1RZWUpDK3dJVEpGcjhiekNYTlNpZlZ5NDVNNkdwU2IrdDBJT2VLcnhkcDA9MTswMDsn\"

Body

{

"Journal_Template_Name": "ITEM",
"Journal_Batch_Name": "D19BF2BD-0",
"Line_No": 10030,
"Entry_Type": "Positive Adjmt.",
"Document_No": "T000001",
"External_Document_No": "",
"Item_No": "1952",
"Location_Code": "",
"Bin_Code": "",
"Quantity": 12
}

Got this error

<error xmlns="">docs.oasis-open.org/.../metadata">

<code>RequestDataInvalid</code>

<message>Request data is invalid.</message>

</error>

Any suggestion?

Was this reply helpful? Yes No
Suggested answer

gert@lynge.org on at

Like (0)

Report

I don't think you should include the Journal_Template_Name, Journal_Batch_Name and Line_No in the body.

Only include the fields you want to change the value of.

Also: Your ETag does not look correct. Note that the backshashes in powershell is probably for escaping the " characters.

I think it should look like this: W/"'JzQ0O1RZWUpDK3dJVEpGcjhiekNYTlNpZlZ5NDVNNkdwU2IrdDBJT2VLcnhkcDA9MTswMDsn'"

Was this reply helpful? Yes No
Nilesh Gajjar India 2 on at

Like (0)

Report

This time i only include the quantity in body part still it give same error as bad request

Was this reply helpful? Yes No
Suggested answer

gert@lynge.org on at

Like (0)

Report

Can you try without the If-Match header just to see if it is formatted correctly? (you should get another error then).

Was this reply helpful? Yes No
Nilesh Gajjar India 2 on at

Like (0)

Report

Without If-Match header

Get below error

Was this reply helpful? Yes No
Suggested answer

gert@lynge.org on at

Like (0)

Report

Ok. Then it complains the If-Match is missing - but that tells us the rest of the request apparently is ok.

Try to re-add it, but remove the backslashes from it...

Was this reply helpful? Yes No
Nilesh Gajjar India 2 on at

Like (0)

Report

I have add If-Match tag again remove all back and forward slash but got same error

Was this reply helpful? Yes No
Nilesh Gajjar India 2 on at

Like (0)

Report

Does anyone confirm that PATCH method work for ODATA Service in Business Central?

Was this reply helpful? Yes No
Suggested answer

gert@lynge.org on at

Like (0)

Report

I don't think you should remove the forward slashes - only the backslashes which is for escaping the " in powershell

Actually i think the format is like this: W/"'JzQ0O1RZWUpDK3dJVEpGcjhiekNYTlNpZlZ5NDVNNkdwU2IrdDBJT2VLcnhkcDA9MTswMDsn'"

Please try that

Was this reply helpful? Yes No