Add, Update and Delete list items using ECMAScript

Introduction

In this post we will see how to Add, Update and Delete SharePoint list items with ECMAScript (aka javascript client object model)

•     Add item to SharePoint list
•     Update item of SharePoint list
•     Delete item from SharePoint list

Add item to SharePoint list

     To add an item to the list, use the ListItemCreationInformation object,set the properties using set_item, call the update and ExecuteQueryAsync methods.

function AddListItem(){
    var ListName = "Test List";
    var context = new SP.ClientContext.get_current(); // the current context is taken by default here        //you can also create a particular site context as follows
    //var context = new SP.ClientContext('/Sites/site1');
    var lstObject = context.get_web().get_lists().getByTitle(ListName);
    var listItemCreationInfo = new SP.ListItemCreationInformation();
    var newItem = lstObject.addItem(listItemCreationInfo);
    newItem.set_item('Title', 'This is new item');
    // set values to other columns of the list here
    newItem.update();
    context.executeQueryAsync(Function.createDelegate(this, this.onSuccess),
        Function.createDelegate(this, this.onFailure));
     function onSuccess() {
        alert('Item created: ' + newItem.get_id());
    }
    function onFailure(sender, args) {
        alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
    }
}

Update Item of SharePoint list   

function UpdateListItem()
{
var ListName = "Test List";
var context = new SP.ClientContext.get_current();
// the current context is taken by default here
//you can also create a particular site context as follows
//var context = new SP.ClientContext('/Sites/site1');
var lstObject = context.get_web().get_lists().getByTitle(ListName);
this.lstObjectItem = lstObject.getItemById(1);
lstObjectItem.set_item('Title', 'This is updated item');
lstObjectItem.update();
lstObject.set_description("Updated description using ECMAScript");
lstObject.update();
context.executeQueryAsync(Function.createDelegate(this, this.onSuccess),
Function.createDelegate(this, this.onFailure));
}
function onSuccess() {
alert('Item udated');
}
function onFailure(sender, args) {
alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}


Delete Item from SharePoint list

function DeleteListItem()
{
var ListName = "Test List";
var context = new SP.ClientContext.get_current();
// the current context is taken by default here
//you can also create a particular site context as follows
//var context = new SP.ClientContext('/Sites/site1');
var lstObject = context.get_web().get_lists().getByTitle(ListName);
this.lstObjectItem = lstObject.getItemById(1);
lstObjectItem.deleteObject();
context.executeQueryAsync(Function.createDelegate(this, this.onSuccess),
Function.createDelegate(this, this.onFailure));
}
function onSuccess() {
alert('Item Deleted');
}
function onFailure(sender, args) {
alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());
}

Remarks

Reference to ‘sp.js’ file should be there in the page where you are using ECMAScript.

How to add values in multi select lookup field in sharepoint using CSOM

Create a List of FieldLookupValue's
List<FieldLookupValue> oLookupValues = new List<FieldLookupValue>();

Add a new FieldLookupValue for each file id
oLookupValues.Add(new FieldLookupValue() { LookupId = Convert.ToInt32(lookupID) });

When finished set the listitem to the List
listItem["FieldName"] = oLookupValues ;
listItem.Update();