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 update values in a custom multi lookup field Field (table) of MS Project using JavaScript/jQuery?

  Updating values in the custom multi lookup field Field of MS Project using JavaScript/jQuery: First of all we need to know the steps to update/add details in a Project of Project Server  Step 1: CheckOut a Project Step 2: Update detals in same as in Step 1 Project Step 3: Publish a Project Step 4: CheckIn a Project We always in need to follow the above steps to update any Project to MS Project/Project Server. Same we need to follow in code too.    //Step 1: First, we need to define all the required functions, the below Functions are callback functions             window.checkOutPWAProject = function (projectId, callBack) {                 var checkOutURL = _spPageContextInfo.webAbsoluteUrl + "/_api/ProjectServer/Projects('" + projectId + "')/checkOut()";                 $.ajax({                     url: chec...

How to get all site users of SharePoint using REST API?

Get all users of SharePoint site using REST API: These users and its data are required to update people field of a SharePoint list. By using below snippet code we can able to get details of a user of SharePoint site.     var webURL = _spPageContextInfo.webAbsoluteUrl+"/_api/Web/SiteUsers";         $.ajax({           url: customFieldURL,           method: "GET",           headers: {             "Accept": "application/json; odata=verbose"           },           success: function (data) {            console.log(data);             data.d.results.forEach(function(cm){                     console.log(cm.Title+" - "+cm.Email+" - "+cm.Id);             });      ...

How to trigger a MS Flow Using Jquery/JavaScript?

Trigger a  MS Flow Using jQueryuery/JavaScript: To trigger an MS Flow first we need to create an workflow. Next we need to obtain its URL for triggering it. In below example, we are starting a workflow which is taking email address, email subject and email body as parameter and sending mail to email of related user. //This function triggers the microsoft flow  function beginMSFlow() {          var httpPostUrl = "obtain URL from MS flow";          var postData = {              emailadress:'raju@testdev.com', // Object keys must be similar as you used in the MS flow             emailSubject:'Testing Raju',              emailBody:'Hello User\n Welcome, You just trigger a MS Flow'             };           $.ajax({           url: httpPostUrl,    ...