Add, Update and Delete list items using ECMAScript

Add, Update and Delete list items using ECMAScript
15 votes, 3.79 avg. rating (76% score)

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

Skill Level – Medium

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 = "MyList";
	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 = "MyList";
	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 = "MyList";
	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

Conclusion

These are the main basic methods required by any devlopers who are working on ECMAScript.

December 15, 2012 В· Adi В· No Comments
Tags: ,  В· Posted in: JavaScript Object Model, Sharepoint 2010

Leave a Reply

What is 12 + 15 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)