Dynamics Community Forum Thread Details

Unable to update a field data in "Sales_Prices" in BC

request Action:PATCH

request url: api.businesscentral.dynamics.com/.../Sales_Prices(Item_No ='100001', Sales_Type ='Customer Price Group' , Sales_Code ='BH' ,Currency_Code ='BHD' ,Variant_Code = ' ', Unit_of_Measure_Code = 'NOS', Minimum_Quantity ='0',Starting_Date= '0001-01-01')

request Body:

{

"Mageno_Sync": true

}

response:

{
"error": {
"code": "BadRequest_NotFound",
"message": "Bad Request - Error in query syntax. CorrelationId: df27ae4d-a122-489e-9d1c-6f4eee092f99."
}
}

I tried with another request body:

request url:

api.businesscentral.dynamics.com/.../Sales_Prices eq '100001' and Sales_Type eq 'Customer Price Group' and Sales_Code eq 'BH' and Currency_Code eq 'BHD' and Variant_Code eq '' and Unit_of_Measure_Code eq '' and Minimum_Quantity eq 0

request body:

{

"Mageno_Sync": true

}

response:

{
"error": {
"code": "BadRequest_MethodNotAllowed",
"message": "'PATCH' requests for 'Sales_Prices' of EdmType 'Collection' are not allowed within Dynamics 365 Business Central OData web services. CorrelationId: def90d9b-6bd7-47fd-bea0-d1bee46477c1."
}
}

Can anyone tell me what is the wrong thing or missing part in the request body and URL?

I tried doing this using postman but was unable to do so. As I have checked there are 8 primary keys that are being sent in the URL.

Categories:

Dynamics 365 Business Central

Quick Links