{"id":4566,"date":"2015-07-28T11:57:05","date_gmt":"2015-07-28T11:57:05","guid":{"rendered":"http:\/\/ngenioussolutions.com\/blog\/?p=108"},"modified":"2026-02-11T07:28:42","modified_gmt":"2026-02-11T07:28:42","slug":"bulk-delete-sharepoint-list-items-using-csom","status":"publish","type":"post","link":"https:\/\/ngenioussolutions.com\/blog\/bulk-delete-sharepoint-list-items-using-csom\/","title":{"rendered":"Bulk delete SharePoint List items using CSOM"},"content":{"rendered":"

SharePoint CSOM enables us to delete bulk list items using browser console.<\/em><\/p>\n

Scenario-1<\/strong>: \u00a0We have a list of records to be deleted from a SharePoint list and we do not want to delete record one by one.<\/p>\n

Scenario-2<\/strong>: \u00a0We want to delete the list and list already had cross the threshold limit and not allowing to delete list until records reaches under the threshold limit.<\/p>\n

Following script demonstrates the steps to achieve the same<\/p>\n

Step-1<\/strong>: \u00a0Navigate to SharePoint site where list is present.<\/p>\n

Step-2<\/strong>: Open Inspect Element by clicking F12 in any browser. Open console tab.<\/p>\n

Step-3<\/strong>: Copy and Paste following code in console, Insert the list name (wherever ‘ListName’ is mentioned) and run the command.<\/p>\n

\/\/\u00a0—————————————<\/p>\n

var clientContext;<\/em>
\n var website;<\/em>
\n var oList;<\/em>
\n var cnt = 0;<\/em>
\n \/\/ Make sure the SharePoint script file ‘sp.js’ is loaded before your code runs.<\/em>
\n SP.SOD.executeFunc(‘sp.js’, ‘SP.ClientContext’, sharePointReady);<\/em><\/p>\n

\/\/ Create an instance of the current context.<\/em>
\n function sharePointReady() {<\/em>
\n clientContext = SP.ClientContext.get_current();<\/em>
\n website = clientContext.get_web();<\/em>
\n oList = website.get_lists().getByTitle(‘ListName’);<\/em><\/p>\n

var camlQuery = new SP.CamlQuery();<\/em>
\n camlQuery.set_viewXml(‘1000’);<\/em>
\n this.collListItem = oList.getItems(camlQuery);<\/em><\/p>\n

clientContext.load(website);<\/em>
\n clientContext.load(collListItem, ‘Include(Id)’);<\/em>
\n clientContext.executeQueryAsync(Function.createDelegate(this, this.onQuerySucceeded), Function.createDelegate(this, this.onQueryFailed));<\/em>
\n }<\/em><\/p>\n

function onQuerySucceeded(sender, args) {<\/em><\/p>\n

var listItemInfo = ”;<\/em>
\n var listItemEnumerator = collListItem.getEnumerator();<\/em><\/p>\n

while (listItemEnumerator.moveNext()) {<\/em>
\n var oListItem = listItemEnumerator.get_current();<\/em>
\n var ID = oListItem.get_id();<\/em>
\n var oListItemDel = oList.getItemById(ID);<\/em>
\n oListItemDel.deleteObject();<\/em>
\n clientContext.executeQueryAsync(Function.createDelegate(this, this.onDeleteSucceeded), Function.createDelegate(this, this.onDeleteFailed));<\/em>
\n console.log(ID + ” : Deleted”);<\/em>
\n }<\/em>
\n }<\/em><\/p>\n

function onQueryFailed(sender, args) {<\/em>
\n console.log(‘Request failed. ‘ + args.get_message() + ‘\\n’ + args.get_stackTrace());<\/em>
\n }<\/em><\/p>\n

function onDeleteFailed(sender, args) {<\/em>
\n console.log(‘Delete failed. ‘ + args.get_message() + ‘\\n’ + args.get_stackTrace());<\/em>
\n }<\/em><\/p>\n

function onDeleteSucceeded(sender, args) {<\/em>
\n cnt = cnt + 1;<\/em>
\n console.log(‘Delete success : ‘ + cnt);<\/em>
\n }<\/em><\/p>\n

\/\/\u00a0—————————————<\/p>\n

Note<\/strong>: Above script delete 1000 records at a time.<\/p>\n

\n

Related Article:<\/span><\/p>\n