Skip to main content

How to get data of more than one SharePoint list using REST API?

 Get data of more than one SharePoint list using REST API:

By using below snippet code we can able to get data of two SharePoint list at time.


 var getDataModule = (function () {

      var baseRequest = {

          url: "",

          type: ""

      };


      var getApp = {

      };

      var getApp = {

          receivedRequest: receivedRequest,

      };


      function receivedRequest(endpoint, _async) {

          //var dfd = $.Deferred();

          var request = baseRequest;

          request.type = "GET";

          request.async = false;

          request.url = endpoint;

          request.headers = {

              'ACCEPT': "application/json;odata=verbose",

          };

          return $.ajax(request);

      };


      return getApp;

  })();

    var defer1 = $.Deferred();

    var defer2 = $.Deferred();


    var dfdList1Files;

    var dfdList2Files;


    var list1URL = _spPageContextInfo.webAbsoluteUrl + "/_api/web/Lists/GetByTitle('Employees')/Items?$select=*,VVR_x0020_Email_x0020_People/Title&$expand=VVR_x0020_Email_x0020_People&$top=5000";

    var list2URL = _spPageContextInfo.webAbsoluteUrl + "/_api/Web/lists/getbytitle('Salary Structure')/items?$top=5000";




    dfdList1Files = getDataModule.receivedRequest(list1URL, true);

    dfdList2Files = getDataModule.receivedRequest(list2URL, true);


    dfdList1Files.success(function (data) {

        defer1.resolve(data);

    });

    dfdList2Files.success(function (ldata) {

        defer2.resolve(ldata);

    });

    $.when(defer1, defer2).then(function (list1Data, list2Data) {

        console.log('success');

        console.log(list1Data);

        console.log(list2Data)

    });



Output:




Comments

Popular posts from this blog

How to get list item entity type full name of a SharePoint list using REST API ?

REST API to get list item entity type full name: Bullet method (small and accurate): siteurl( AbsoluteUrl ) + /_api/Web/Lists/getbytitle('ListName')/ListItemEntityTypeFullName or   _spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/getbytitle('SPList')/items?select=EntityTypeFullName **Use this above API just replacing absolute site URL and list name **Then put this prepared URL into browser and press enter button and obtain list entity type full name of related list. **You will get ListEntityTypeFullName like " SP.Data.EmployeeListItem " **Employee(may be a list name) How it is? Is it working or not you can tell us using comment section ?

How to send email using SharePoint REST API in jQuery/JavaScript?

  Send email using SharePoint REST API in jQuery/JavaScript: We can able to send email to the SharePoint user using below REST API on SharePoint Online. We need to load SP.js file in code. we must need to give valid SharePoint user to send email. We can able to send email to valid SharePoint user of same organization.      var   restAPI  =  _spPageContextInfo . webAbsoluteUrl  +  "/_api/SP.Utilities.Utility.SendEmail" ;      $ . ajax ({          contentType:   'application/json' ,          url:   restAPI ,          type:   "POST" ,          data:   JSON . stringify ({              'properties' :  {             ...