Hello, I try to update data with Odata api, I use patch method send data to following url:
the data I send is use json:
{
"WorkDescription": "testtes:1550480116"
}
But I get error:
{
"odata.error": {
"code": "",
"message": {
"lang": "en-US",
"value": "Bad Request - Error in query syntax."
}
}
}
May I know how to solve?
*This post is locked for comments
Hi Robert,
Could you post the solution to your problem here? It would be helpful
Thank you, I finally find out how to update, thank you very much
the key should be correct unless you had published wrong page , which page you are publishing for the web service ?
is it page 42 ?
Hello, I also try this way, but still not work
api.businesscentral.dynamics.com/.../Company('Foxit%20Software%20Incorporated')/Sales_Orders(Document_Type='Order',Document_No='SO1900231')
get response:
{
"error": {
"code": "BadRequest_NotFound",
"message": "The number of keys specified in the URI does not match number of key properties for the resource 'NAV.Sales_Orders'."
}
}
Hello, I use your way to update, but get error response like follow:
{
"error": {
"code": "RequestDataInvalid",
"message": {
"lang": "en-US",
"value": "Request data is invalid."
}
}
}
If using OData , you should specify all the primary key , in this case for sales order should be : Sales_Order('Order','S-ORD101003').
For updating data , you need to get the etag first , call the GET command first :
GET api.businesscentral.dynamics.com/.../Company('CRONUS%20US')/Sales_Order('Order','S-ORD101003')
the response will return etag information . then you need to add this etag value under request header when update.
Request Header
Key : IF-Match
Value : etag
(Sample : W/"JzY4O0pBQUFBQUNMQVFBQUFBSjcvMU1BU1FBdEFERUFPUUF0QURBQU13QXRBREFBTUFBd0FEQUFNQUF3QURJQUFBQUFBQT09Njs5OTAzNjgwOyc=")
PUT api.businesscentral.dynamics.com/.../Company('CRONUS%20US')/Sales_Order('Order','S-ORD101003')
#1
André Arnaud de Cal...
291,602
Super User 2024 Season 2
#2
Martin Dráb
230,340
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
