Modify a record through ODATAV4

(0) Share

Report

Posted on by Olister Rumao

4,009

Hi All,

I have a record created in Business Central and is pulled to CDS Correctly. After modifyingthe record in CDS, I want to update my record in Business Central.

The issue is that the table consists 3 key fields Time Sheet No., Time Sheet Line No. and Date.

When I call the url through GET method, I'm precisely getting that single record.

When I try to modify the record using PATCH, I'm getting the following error

'Could not validate the client concurrency token required by the service. Please provide a valid token in the client request'

I have followed this url

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/use-odata-to-modify-data

I have also passed the Etag as a part of If-Match but that just gives the same result.

Kindly advise!

I have the same question (0)

All responses (6)

Answers (4)

Verified answer

gert-jan.terschure 206 on at

Like (0)

Report
Copy link

Link copied!

You need to provide the If-Match header in the PUT request. When you get the result you get the "@odata.etag" property, this is the concurrency token.

Was this reply helpful? Yes No
Suggested answer

Olister Rumao 4,009 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yes I have also tried that but it gives the same result.

Was this reply helpful? Yes No
Verified answer

gert-jan.terschure 206 on at

Like (0)

Report
Copy link

Link copied!

From the screenshots the If-Match seems to be placed in the url. It needs to be placed in the header. Please note that the @odata.etag that's provided by Business Central/NAV is "escaped json", so you'll need to remove the "\" that are placed in front of the double quotes.

Was this reply helpful? Yes No
Suggested answer

Olister Rumao 4,009 on at

Like (0)

Report
Copy link

Link copied!

Hi Gert,

Thank you I appreciate your help, but I'm getting the same error.

I do not understand why If-Match becomes a part of the URL

Also, I'm showing the body of the call

I hope this makes it clear.
Let me know if you need any more details or we can have a call to understand it further.

Was this reply helpful? Yes No
Verified answer

gert-jan.terschure 206 on at

Like (0)

Report
Copy link

Link copied!

From the screenshots I can see you're adding the If-Match and Content-Type to the tab "Params", these will be added to the url. This is intended behavior as the params could contain items such as "$filter" and "$select".

Please place them in tab "Headers" (3rd tab from the left), that is where the headers that are being sent as part of the request are added.

Was this reply helpful? Yes No
Verified answer

Olister Rumao 4,009 on at

Like (0)

Report
Copy link

Link copied!

Aaahh....

You are right.. I made a silly mistake...

Yes I have confirmed that things are working as desired.

FYI If-Match = * also works perfectly

Thanks a lot man.. I guess I needed a second pair of eyes :)

Was this reply helpful? Yes No