CRUD Operations on SharePoint List using JavaScript Object Model(JSOM)


JavaScript Object Model
Create Item
Add one record into ProductsCategory list using below code.

//Get the Site var context = new SP.ClientContex("Your Site URL"); // Get the Web var web = context.get_web(); // Get the list based on the Title var list = web.get_lists().getByTitle("ProductCategory"); //Object for creating Item in the List var listCreationInformation = new SP.ListItemCreationInformation(); var listItem = list.addItem(listCreationInformation); listItem.set_item("Title", $("#CategoryId").val()); listItem.set_item("CategoryName", $("#CategoryName").val()); listItem.update(); //Update the List Item ctx.load(listItem); //Execute the batch Asynchronously ctx.executeQueryAsync( Function.createDelegate(this, success), Function.createDelegate(this, fail) );

The above code perform the following operations.
  •  To add a new item in the list, the SP.ListCreationInformation() object is used
  •  This object is then passed to the addItem() method of the List. This method returns the ListItem object
  •  Using the set_item() method of the ListItem the values for each field in the List is set and finally the list is updated.
Update Item 
Edit the record from StudentsInfo list whose ID=1 using below code. 

/Get the site var contex = new SP.ClientContext("Your Site URL"); //Get the web var web = contex.get_web(); //Get the List based upon the Title var list = web.get_lists().getByTitle("StudentsInfo"); ctx.load(list); listItem = list.getItemById(1); ctx.load(listItem); listItem.set_item("StudentName", "Gopi Avala"); listItem.update(); ctx.executeQueryAsync(Function.createDelegate(this, success), Function.createDelegate(this, fail));


Delete Item 

Delete the record from StudentsInfo list whose ID=1 using below code.

//Get the site var contex = new SP.ClientContext("Your Site URL"); //Get the web var web = contex.get_web(); //Get the List based upon the Title var list = web.get_lists().getByTitle("StudentsInfo"); ctx.load(list); listItem = list.getItemById(1); ctx.load(listItem); listItem.deleteObject(); ctx.executeQueryAsync(Function.createDelegate(this, success), Function.createDelegate(this, fail));


Get all Item 
Get all the item from StudentsInfo list using below code  

//Get the site var contex = new SP.ClientContext("Your Site URL"); //Get the web var web = contex.get_web(); //Get the List based upon the Title var list = web.get_lists().getByTitle("StudentsInfo"); //The Query object. This is used to query for data in the List var query = new SP.CamlQuery(); ctx.load(list); query.set_viewXml('<View></View>'); var items = list.getItems(query); //Retrieves the properties of a client object from the server. ctx.load(list); ctx.load(items); ctx.executeQueryAsync( Function.createDelegate(this, function () { var enumerator = items.getEnumerator(); while (enumerator.moveNext()) { var currentListItem = enumerator.get_current(); alert(currentListItem.get_item("ID")); alert(currentListItem.get_item("Title")); alert(currentListItem.get_item("StudentName)); } }), Function.createDelegate(this, fail) );


Get Specific Item
//Get the site var contex = new SP.ClientContext("Your Site URL"); //Get the web var web = contex.get_web(); //Get the List based upon the Title var list = web.get_lists().getByTitle("StudentsInfo"); //The Query object. This is used to query for data in the List var query = new SP.CamlQuery(); ctx.load(list); //Create the CAML that will return only items with the titles that begin with 'G' query.set_viewXml('<View><Query><Where><BeginsWith><FieldRef Name="StudentName" /><Value Type="Text">G</Value></BeginsWith></Where></Query></View>'); var items = list.getItems(query); //Retrieves the properties of a client object from the server. ctx.load(list); ctx.load(items); ctx.executeQueryAsync( Function.createDelegate(this, function () { //Get an enumerator for the items in the list var enumerator = items.getEnumerator(); while (enumerator.moveNext()) { var currentListItem = enumerator.get_current(); alert(currentListItem.get_item("ID")); alert(currentListItem.get_item("Title")); alert(currentListItem.get_item("StudentName")); } }), Function.createDelegate(this, fail) );

Happy Coding....Sharing is caring .... Keep Smiling...

Comments

Post a Comment

Popular posts from this blog

SharePoint 2013 Keyword Query (KQL) Content Class Property Restrictions

Using property restrictions in your KQL queries, you can restrict your search to only pull back certain things like calendar events for instance. This is a very powerful way to limit search results  and get exactly what you are looking for. You can use these in your query like this: " lunch contentclass:STS_ListItem_Events " This will return only calendar events with the word "lunch" in them.  Pretty powerful and pretty simple. Here is a list of available content class items: STS_Site –  Site Collection STS_Web  –  Site (Web) STS_List_850  –  Page Library STS_ListItem_850  –  Page STS_List_DocumentLibrary  –  Document Library STS_ListItem_DocumentLibrary  –  Document Library Items STS_List  –  Custom List STS_ListItem  –  Custom List Item STS_List_Links  –  Links List STS_ListItem_Links  –  Links List Item STS_List_Tasks  –  Tasks List ...
Read more

SharePoint SPFx Intro & Configuration to Create New SPFx Solution

Image
SharePoint SPFx Introduction What is SPFx? 1. SPFx is SharePoint Framework Extension which was newly introduced in SharePoint 2016 Online. 2. SPFx is introduced on replacement of  SharePoint Visual Web Parts (SP Visual Web Parts can't be deployed to SharePoint Online). 3. In SPFx we can 3 types of solutions like  Web Part, Extensions and Library . Why SPFx? 1.  The world is moving more and more towards client-side development. No matter how good the back-end architecture is, what the user gets to see is user interface. If the user doesn't feel a smooth and lag free experience, user would certainly complain. 2. With these advancements in technologies, SharePoint has decided to focus more towards improving the user experience with the product. So, this opens a world of endless possibilities for developers working with SharePoint. This means Microsoft SharePoint now has full support for open source tool chain. Configuring Development Environ...
Read more

Filtering the Sharepoint List Taxonomy Column using Rest API

I ran into a strange issue today when using the SharePoint 2013 REST API for Lists with Managed Metadata columns    but I just had a ‘clever workaround’ moment with SharePoint’s oData/REST implementation when it comes to filtering list items based on taxonomy (managed metadata) columns. Now I do not consider myself a developer, so this article is probably a little verbose for some readers, but should be helpful to power users or IT pros. 1. To filter the Taxonomy columns in SharePoint list using Rest API call we need to use the Post method. 2. The Rest API call will give errors some times when the Rest API Query string crosses limit 260 characters that time we will use the Query in the body. Those things are clearly explained in the below example clearly. 3. WE can use the CAMEL Query in the Rest API call this example come under that. < script src = "https://cdnjs.cloudflare.com/ajax/libs/jquery/3.4.1/jquery.min.js" ></ script > < scri...
Read more