Update document library column value for given row ID

Question

I'm trying to update the status column in a document library where the name is "sharepoint_test.csv" and I'm following this tutorial to do it.

URL:

POST:URL

https://mycompany.sharepoint.com/teams/global/commerce/_api/web/lists/GetByTitle('Data%20Sources')/items(4)

Body:

{"__metadata" {"type":"SP.Data.Data_x0020_SourcesItem"},"status":"even newer"}

I've also tried types SP.FieldText and SP.Field.

Here's my library:

Name                | Modified | Modified By | status
-----------------------------------------------------
sharepoint_test.csv | Apr 2    |  Dan        | new

Should become:

Name                | Modified | Modified By | status
-----------------------------------------------------
sharepoint_test.csv | Apr 2    |  Dan        | even newer

When I make the POST request in Postman, however, there is no error, the status comes back as 204 No Content, but when I look back at the status column, it still remains as "new".

According to this and this, I am doing it correctly.

Answer 1

The column names are case sensitive. Is the column "status" or "Status".

Are you sure the ID of the item is "4"?

Here's what I use that works (for AJAX), which except for the "Authorization" looks to be the same as your example:

/sites/testSite/_api/web/lists/GetByTitle('Announcements')/Items(1)

{ "accept": "application/json;odata=verbose",
  "content-type": "application/json;odata=verbose",
  "X-HTTP-Method": "MERGE",
  "If-Match": "*",
  "X-RequestDigest": "__yourRequestDigest__" }

{ "__metadata": { "type": "SP.ListItem" }, "Title": "New title" }

I have a REST tester that I use to fine tune these requests: http://techtrainingnotes.blogspot.com/2017/04/a-sharepoint-rest-api-tester-with-ajax.html

Answer 2

Apparently the status of Update Document metadata using REST API is :

nocontent: {"readyState":4,"responseText":"","status":204,"statusText":"No Content"}

So this word shouldn't worry you just check and see if the field changed?

Also you can use at least these two type of REST Endpoint for url for updation document metadata, which both of them return the above result as success!

url:response.d.ListItemAllFields.__metadata.uri,
url=_spPageContextInfo.webAbsoluteUrl+
"/_api/Web/lists/GetByTitle('Documents')/items("+itemId+")";