How to delete a record in list using the Name in that record

Question

This is my list. How to Delete a record using Student Name not using ID.This is the code which I tried delete function using ID.

$("#btnDeleteStudent").click(function()
{
var IdNo = $("#txtDeleteStudent").val(); 

$.ajax({
url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getByTitle('Student Details')/items("+IdNo+")", 
type: "DELETE",  
        headers: {  
            "Accept": "application/json;odata=verbose" ,
    "contentType": "application/json;odata=verbose" ,
    "X-RequestDigest": $("#__REQUESTDIGEST").val(),
            "IF-MATCH": "*",
             "X-HTTP-Method": "DELETE"
        },  
        success: function(data) {  
            alert("Item Deleted successfully");  
        },  
        eror: function(data) {  
            alert("An error occurred. Please try again.");  
        }  
    }); 
});

I guess, you could click on "edit this list" and see, where that brings you. — Geshode, Oct 01 '18 at 05:30
sorry Forgot to mention. I need Rest API code to do this. I tried by using ID. But I want to delete a record using student name. — maran baskaran, Oct 01 '18 at 05:32
Then just take the ID corresponding to the student name and delete it. — Geshode, Oct 01 '18 at 05:55
Yes it works. But I want to try delete function using name, as I mentioned above. — maran baskaran, Oct 01 '18 at 06:01

score 0 · Answer 1 · answered Oct 01 '18 at 06:31

You can write a CAML query to do the same. Please refer these links for more details: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/467ca160-108d-4540-8dd7-4d5c8e3f6594/delete-list-items-through-caml-query?forum=sharepointdevelopment

CAML Query - Delete 1 Item

http://www.dotnetspider.com/resources/43543-Delete-Lists-items-from-SharePoint-site-using.aspx

Thanks and regards, Purushottam

How to delete a record in list using the Name in that record

1 Answers1