Tuesday, March 28, 2017

SPServices:Update item in SharePoint List or Document Library using SPServices jQuery library in SharePoint

In my previous article, How to create folder inside SharePoint List or Document Library using SPServices jQuery library in SharePoint, I already explained about $().SPServices.UpdateListItems operation to access the listing of folder.

For example, in SharePoint online site, we need to update item in SharePoint List or Document library on the basis of key field when user click on button.

To implement above requirement, we can not use the SharePoint Server Side code, so we need to utilize the Client Side Scripting – JSOM/Call to SharePoint REST API using JQuery/Use of SPServices JQuery Library.

Now, I am going to explain how to update item in SharePoint List or Document Library using SPServices jQuery library in SharePoint. SPServices JavaScript Library ($().SPServices) provides function called UpdateListItems to update content in the SharePoint list.
  • Update item the SharePoint Document Library or List using $().SPServices.UpdateListItems operation with valuepairs option:
       [pre class="brush:jscript" ] $().SPServices({ operation: "UpdateListItems", async: false, batchCmd: "Update", listName: "AmitKumar_TestList", ID: 1, valuepairs: [["Title","Amit Kumar"]], completefunc: function (xData, Status) { console.log('List items has been updated'); } }); [/pre]
     In the above code block, we are not using updates attributes of "UpdateListItems" operation,
    instead using valuepairs attribute to define the columns which needs to be updated on the basis of ID of element/row.
   We can define more than one columns in valuepairs attribute, it will serve as an array of columns:
valuepairs: [["Title", "Amit Kumar"], ["Technologies", ".NET, SharePoint, AngularJS"]]
  • Update item in SharePoint Document Library or List using $().SPServices.UpdateListItems operation with CAML query:
[pre class="brush:jscript" ] var camlQuery = '' + '' + 'Amit Kumar' + '.NET, SharePoint, AngularJS' + '1' + '' + ''; $().SPServices({ operation: "UpdateListItems", async: false, listName: "AmitKumar_TestList", updates: camlQuery , completefunc: function(xData, Status) { console.log('List items has been updated'); } }); [/pre]

In the above code block, we are not using batchCmd/ID attributes of "UpdateListItems" operation, instead using updates attribute to define the columns which needs to be updated based on ID of element/row. The default for the batchCmd option is 'Update'


More articles on SPServices:
What is SPServices
How to access List Data using SPServices jQuery library in SharePoint
How to access list of folder name from SharePoint List or Document Library using SPServices jQuery library in SharePoint
How to create/add folder in SharePoint List or Document Library using SPServices jQuery library in SharePoint
Update item in SharePoint List or Document Library using SPServices jQuery library in SharePoint

Share:

0 comments:

About Me

My photo
Based in Bangalore, INDIA, Amit is a MCC. He has an MCA from the U.P.T.U., INDIA and holds Microsoft certifications including SharePoint 2007/2010/2013. He is an contributor to MSDN and http://amitkumarmca04.blogspot.com/. Amit have experience in SharePoint,ASP.Net with C#, Classic ASP, VB,Macros,HTML,JavaScript,JSON,BootStrap and AngularJS.

Followers

Labels