SharePoint List item can be updated using REST API by referring to the item by its ID filed which is always unique. Let us look at an example, which can be validated using Postman.
You would eventually use the code snippet with Spfx (modern) or Content Editor (classic). For authentication, bearer token will be used.
If you are connecting to the List from outside of SharePoint like Java, .Net or Python code, you need to use a Bearer token (Client ID and Client Secret) to access the REST url.
Steps to generate Client ID and Secret - Register SharePoint App
This example assumes you have a list named "List1". Please make necessary modifications to the List name, column internal name wherever applicable.
✔️ Update SharePoint List Item using HTML, jQuery, Ajax
We will use POST method to update the SharePoint record. Assumptions,List Name = List1
List Item ID = 10
Column to update = Title
You can update more columns, just pass the internal name and value to be updated. Separate with a comma ",".
var webURL = _spPageContextInfo.webAbsoluteUrl;
$.ajax({
url: webURL + "/_api/web/lists/GetByTitle('List1')/items(10)",
type: "POST",
headers: {
"accept": "application/json;odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val(),
"content-Type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
},
data: "{__metadata:{'type':'SP.Data.List1ListItem'},Title:'Title updated via REST API'}",
//Add more columns in above line to update
success: function(data) {
//Perform further activity upon success, like displaying a notification
},
error: function(error) {
//Log error and perform further activity upon error/exception
}
});
✔️ Update SharePoint List Item using Postman - PATCH
For testing SharePoint REST API with Postman, you need to use the Client ID, Client Secret, Tenant ID, to generate a Bearer token.Steps to generate SharePoint Bearer token - How to test SharePoint REST API from Postman
Once you have generated the access token, follow below steps
- Initiate a PATCH method request.
- Apply Header configuration parameters as below.
- In the Body section, select 'raw' and add below code.
- Enter request url in below format
- Click Send.
- You should get a 204 No Content response. This means that the update request is successfully completed there is no content to return in response.
- Validate the changes form SharePoint.
Key | Value |
Accept | application/json;odata=verbose |
Content-Type | application/json |
Authorization | Bearer <token> |
If-Match | * |
{
"Title": "Title updated via REST API"
}
https://c2c.sharepoint.com/sites/SPDev/_api/web/lists/GetByTitle('List1')/items(10)
⚠️ Error - The request ETag value does not match the object's ETag value
If you get a 412 Precondition Failed error with message "The request ETag value does not match the object's ETag value", it means the server does not meet one of the preconditions that the requester put on the request.
Solution - Add Header parameter key "If-Match" and set its value as *. The ETag Header is used to ensure you update the latest version of SharePoint list item.
{
"error": {
"code": "-1, Microsoft.SharePoint.Client.ClientServiceException",
"message": {
"lang": "en-US",
"value": "The request ETag value '' does not match the object's ETag value '\"GUID,2\"'."
}
}
}
- Move Copy Migrate SharePoint OneDrive files folders to different site collection location
- How to generate client id and secret to register SharePoint App with OAuth
- How to share SharePoint site or document with all users in organization
- Get-ADUser PowerShell - Get AD user details using email address
- error CAML Query containing special characters
- Access URL for SharePoint Tenant Admin Center (Online Office 365)
- Fix SharePoint Error - The Managed Metadata Service or Connection is currently not available. The Application Pool or Managed Metadata Web Service may not have been started
- SharePoint - The URL is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.
- How to delete SharePoint List Item programmatically using C#.Net
- How to Share Microsoft SharePoint Site with Users or Groups
- JSON column formatting to preview SharePoint Online file on mouse hover
- SharePoint List redirect user after submitting form NewForm.aspx
- See actual SharePoint error exception modify web.config
- SharePoint Server 2016 IT Preview Deprecated Removed features
- How to create SharePoint Document Library
- How to Get or Set SharePoint Document ID _dlc_DocId using PowerShell
- How to disable SharePoint subsite creation option for owners
- PowerShell - How to use Try Catch Finally blocks for error exception handling (Windows/SharePoint)
- SharePoint error - Your organization doesn't allow sharing with users from this domain. Please contact your IT department for help. (OSE403)
- [Solved] SharePoint Search Internal server error exception
- How to wrap column text in SharePoint Online Modern List Grid View using JSON formatting
- How to extend retiring SharePoint 2010 Workflows and continue with Office 365
- Changed AD user display name showing old name in SharePoint
- How to hide or remove quick launch left navigation from SharePoint Online Modern site page
- How to enable anonymous public access for SharePoint Online site collection, file, folder without login ?
- Java 8 Format Date and Time Examples - Java
- Fix Microsoft Windows Update Error 80072EFE - Microsoft
- How to hide or cancel Toast message in Android Programming - Android
- 11 Weeks of Android Online Sessions-15-Jun-to-28-Aug-2020 - Android
- How to get Spotify macOS App installed on Mac device - MacOS
- Microsoft Office Excel - Couldnt Open the Workbook - The workbook cannot be opened. - Microsoft
- Fix bash: script.sh: Permission denied Error - Bash
- How to recover SharePoint FARM if the SQL Server IP changes - SharePoint