Some Important SharePoint REST API related to SharePoint list.


Some Important SharePoint REST API related to SharePoint list.


 Get all lists of Current SP Site = https://{siteurl}/_api/web/lists      //CRUD list.
// siteurl may be like https://mycompany.sharepoint.com/sites/teamsite
REST API to get field by  field name = https://{siteurl}/_api/web/lists/getbytitle('Projects')/fields/getbytitle('Status')

 GET SP list meta Data             = https://{siteurl}/_api/web/lists/getbytitle('SP List Name')

 GET Fields/column of SP list  = https://{siteurl}/_api/web/lists/getbytitle('" + listName + "')/fields

 GET SP list fields with filter    = https://{siteurl} /_api/web/lists/getbytitle('SP List Name')/fields?$filter=Title%20eq%20%'Email'

 Get GUID of List                     = https://{siteurl}/_api/web/lists/getbytitle('SP List Name')/Id

 Get GUID of List EntityTypefullName  = https://{siteurl}/_api/web/lists/getbytitle('SP List Name')/ListItemEntityTypeFullName

 GET SP list items(to perform CRUD list items) = https://{siteurl}/_api/web/lists/getbytitle('SP List Name')/items  //100 items at a time. 

 GET SP list items(to perform CRUD list items) = https://{siteurl}/_api/web/lists/getbytitle('SP List Name')/items?$top=5000 //5000 items at a time.  It is maximum allowed content at time. Also you can use it for pagination

 REST API to get value from lookup field = https://{siteurl}/_api/web/lists/getbytitle('SP List Name')/items?$select=*,Test_x0020_Volume/Title&$expand=Test_x0020_Volume

 REST API to update/delete the list Items = https://{siteurl}/_api/web/lists/getbytitle('SP List Name')/items(85);

 REST API to filter the list Items with two fields = https://{siteurl}/_api/lists/getbytitle('" + listName + "')/items?$filter=(AssignedTo eq '" + userId + "') and (Status ne 'Completed')

We can use any of above using REST api using below jquery ajax

 $.ajax({
        url: _spPageContextInfo.webAbsoluteUrl+"/_api/web/lists",
        headers: {
          Accept: "application/json;odata=verbose"
        },
        async: false,
        success: function (response,status,xhr) {
            console.log('Success- It will run if REST API is correct');
            console.log(response); // JSON Data
            console.log(status); // Status text success
            console.log(xhr); // an object with all jquery ajax methods and other thing
        },error: function (error,status) {
            console.log('Error -It will run if REST API is wrong');
            console.log(error);// 
            console.log(status);//an object with all jquery ajax methods,error message and other thing
           
        },complete: function (result,status) {
            console.log('Complete-It will run in every case eaither success or failure');
            console.log(result);//an object with all jquery ajax methods,error/success message and other thing.
            console.log(status);//Status text error
            
        }

});

// It will give you the current Page URL_spPageContextInfo.webAbsoluteUrl

Comments

Post a Comment

Popular posts from this blog

Get list item entity type full name of a SharePoint list using REST API

Image
Get list item entity type full name of a SharePoint list using REST API : Follow the below steps to get ListItemEntityTypeFullName which must required for adding/updating items/records to the server or the SharePoint list. 1) First user/developer need logged in to the SharePoint site and then copy any of below URL/API. 2) Replace the _spPageContextInfo.webAbsoluteURL or siteurl (absolute URL) with the URL of you site for example. siteurl = https://testcompany.sharepoint.com/sites/testsite1 3) and replace SharePoint ListName = Payments or you original list name 4) Finally hit or place the complete URL/API API = https://testcompany.sharepoint.com/sites/testsite1/_api/Web/Lists/getbytitle('Students')/ListItemEntityTypeFullName into the browser search bar/box and click on enter button from keyboard then you will able to see output as shown in Output below   _spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/getbytitle('ListName')/items?select=EntityTypeFullName OR s...
Read more

Get SharePoint list name by GUID

Image
 Get SharePoint list name by GUID in jQuery: Use the below snippet code to get the name of list by using listGuid . To do so replace the below list guid with your SP list GUID. var listGuid = "aa4774cf-oa71-83e4-6a67-01b53d5a7y6i2";//use your own SP site list guid getlistNameByGUID(listGuid); function getlistNameByGUID(guid) { $.ajax({         url: _spPageContextInfo.siteAbsoluteUrl + "/_api/Web/Lists(guid'"+listGuid+"')",         method: "GET",         headers: { "Accept": "application/json; odata=verbose" },         success: function (data) {              console.log(data.d.Title);         },         error: function (e) {             console.log(e)         }   }); } Output: Company//list name of my sp site  Was this helpful? Comment you suggestions and share it with yo...
Read more

Get Current Web Logged In User of SharePoint Site in jQuery

Get Current web logged in User of a SharePoint site in jQuery: Use the below snippet and just replace the jQuery library URL and run on you SharePoint page. <script src="../Assets/Jquery/jquery-1.9.1.min.js"></script> <script > function getCurrentLogInUser(){ $.ajax({     url: _spPageContextInfo.webServerRelativeUrl + "/_api/web/currentuser",     type: "GET",     async:false,     headers: { "Accept": "application/json;odata=verbose" } }).success(function( data ){     console.log( data );     console.log( data.d.Title ); }).error(function(e){     console.log( e ); }); } getCurrentLogInUser(); </script> Output:
Read more