SupportCategory: Simple Object DesignerCan I update data using APIs from SOD?
Tanmai Sharma asked 4 months ago
Hi, GET requests on data works nicely, but PATCH requests are failing with a message like 'PATCH' requests for 'gen__Journal_Lines' of EdmType 'Collection' are not allowed within Dynamics 365 Business Central OData web services."

is it possible to update records using APIs?
Question Tags:
2 Answers
Best Answer
hougaard Staff answered 4 months ago
PATCH is fully supported, but you cannot PATCH the "set name", you must patch the singular entity. Check this: https://yzhums.com/38278/
Tanmai Sharma answered 4 months ago
Hi Erik .. this is very helpful ... I am able to make the $filter work as a parameter (using Python request) but getting an incorrect syntax error for the following url (when I try and make the filter part of the url

https://api.businesscentral.dynamics.com/v2.0/8f5f3e84-01ed-4ae0-b5b6-fc59d5b249b3/Production/api/hougaard/SOD/v2.0/companies(e80660e1-d8a1-ee11-be36-002248310a11)/g_L_Entrys(entryno_=6256)
hougaard Staff replied 4 months ago

I believe you need to use the guid from the G/L entry record instead of “entryno_=6256”.