OData - Cannot update data on page :-(

(0) Share

Report

Posted on by Community Member

Can anyone help me how to solve this problem, i am trying to update data on a page via ODataV4 in NAV 2017?

It works perfect when i get or create a new record via OData, but when i try to update data, then i get the following error:

"code":"","message":"'MERGE' requests for 'Collection' are not supported by Microsoft Dynamics NAV OData web services."

When i read the documentation it should be possible by using: PUT OR MERGE

But i am getting the same error from using both commands.

I use the ETAG value that is provided from GET, by creating a JSON response;

{

""data"":""data to update"",

""ETag"" : ""32;SZQ1dwCRpzWnZSUFeUqPzD4tPQ7CnAAA6;8063650;""

}

Thanks on advance :-)

/Graves Kilsgaard

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (1)

Suggested answer

keoma 32,729 on at

Like (0)

Report

if you use a list page as published odata webservice try to use the according card page instead.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Jonathan

Thanks for your answer, I am using the Card page.

I have come a solution a bit further, i needed to filter the data to one row.

But the token (think it is the etag) is still giving me a hard time, i cannot get NAV to validate it :-(

/Graves

Was this reply helpful? Yes No
Suggested answer

dkatson 2,263 on at

Like (0)

Report

Hi Graves, try to update your data in NAV through OData by using Excel for. example. or open OData test resources (like services.odata.org/validation). Just for to understand if it works. If it works there, than something wrong in your external code. If it doesn't work there check user permissions , by whom you connect to NAV.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi

It is working perfect when i GET and POST, but it is the PATCH (UPDATE) statement i am having problems with :-(

I get the following error in Google (postman) and powershell when i try to address the ODATA feed:

Invoke-RestMethod : {"odata.error":{"code":"","message":{"lang":"en-US","value":"Could not validate the client concurrency token required by the service. Please provide a valid token in the client request."}}}

I have worked with the assumption that it is the etag that i have wrong, but it looks right:
I am sending a header that looks like this:

Key          Value
---          -----
accept       application/json
etag         "'36%3BJAAAAACLAQAAAAJ7BDEAMAAwADcAAAAAAA%3D%3D7%3B10073950%3B'"
Content-Type application/json

And as body i send a json file with the changes i would like to change in my NAV Service:

Invoke-RestMethod -Uri $NAVServiceURL -Method PATCH -Credential $NAVServiceUserCreds -ContentType "application/json" -Body $Dataupdate -Headers $headers

think it is very weird :-/

/Graves



Was this reply helpful? Yes No
Suggested answer

dkatson 2,263 on at

Like (0)

Report

Did you created User Web access key?

See my blog about MS Flow, it also use OData

community.dynamics.com/.../how-ms-flow-can-make-a-friendship-with-nav2017

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi

At the moment I use: UserPassword, but connection is fine, i can Create and Get data from the service.

The problem i have is that i cannot get the request right to build an OData request that updates data with a PATCH.

What I cannot figure out what it is i am missing when the service tells me:

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

/Graves

Was this reply helpful? Yes No
dkatson 2,263 on at

Like (0)

Report

Hi, try to replace UserPassword with Service Access Key for this user.... Just try, may be this could help, if not ... will think furher

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Hi

I hav now found the solution..

The problem was that i had to include the ETag in the headder, with the If-Match parameter.

# ----- Build new headder for update ----- $headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]" $headers.Add("accept","application/json") $headers.Add("If-Match",'W/"' + "'" + [uri]::EscapeDataString($JToken.ETag.ToString()) + "'" + '"') #Etag Value $headers.add("Content-Type","application/json; charset=utf-8")

/Graves

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Graves,

Currently i have the same problem.

Can you post us your whole Request?

Thanks

Martin

Was this reply helpful? Yes No
Suggested answer

gert@lynge.org on at

Like (1)

Report

Hi

Graves is one of my friends, and he is currently on holiday, so I'm not sure he will se your message.

Anyway, we worked together on this blog-post after he solved the issue.

Unfortunately it is in Danish, but it is mainly powershell anyway.

You can probably see the request and inner workings from the powershell example code (powershell making misc. webservice calls to NAV).

blog.systemconnect.dk

Was this reply helpful? Yes No