How to retrieve files from Sharepoint Document library Folders

Question

I have two folders in my document library, that two folders are created automatically based on the year when the file was uploaded. Now what I need to do is Retrieve the file from multiple files.How can I achieve this using javascript...

My Function for Uploading file and create a folder based on year

onclick="fileUpload('Improvement-Projects','improvementprojects')

function fileUpload(divId , fileId) {

var clientContext;
var oWebsite;
var oList;
var itemCreateInfo;
var resultpanel = "MySite";

clientContext = new SP.ClientContext.get_current();
oWebsite = clientContext.get_web();
oList = oWebsite.get_lists().getByTitle("QualityCI");

itemCreateInfo = new SP.ListItemCreationInformation();

itemCreateInfo.set_underlyingObjectType(SP.FileSystemObjectType.folder);
var d = new Date();
var n = d.getFullYear();

var dynfloder = itemCreateInfo.set_leafName(divId + '-' + n.toString());

alert(dynfloder);



this.oListItem = oList.addItem(itemCreateInfo);

this.oListItem.update();

clientContext.load(this.oListItem);
clientContext.executeQueryAsync(
  Function.createDelegate(this, successHandler),
  Function.createDelegate(this, errorHandler)
);

And function to retrieve the files

var d = new Date();
var n = d.getFullYear();
fileGetAction("/sites/Sitename/QualityCI" + '/' + divId + '-' + n.toString());

function fileGetAction(folderUrl) {

if ($.fn.DataTable.isDataTable('#table_id')) {
  $('#table_id').DataTable().destroy();
}
$('#table_id tbody').empty();
var requestURL = _spPageContextInfo.webAbsoluteUrl
  + "/_api/web/GetFolderByServerRelativeUrl('" + folderUrl + "')/Files";
$.ajax({
  url: requestURL,
  type: "GET",
  headers: {
    "Accept": "application/json;odata=verbose",
    "X-RequestDigest": $("#__REQUESTDIGEST").val()
  },
  complete: function (data) {

    console.log("folder: " + folderUrl + " - files: ", data);

    var dynamicTable = "";
    for (j = 0; j < data.responseJSON.d.results.length; j++) {
      var tableData = data.responseJSON.d.results[j];
      dynamicTable += "<tr>";
      dynamicTable += "<td>" + tableData.Name.split('.').slice(0, -1).join('.') + "</td>";
      dynamicTable += "<td>" + '<a href= "' + tableData.ServerRelativeUrl + '"> "' + tableData.Name + '"</a>' + "</td>";
      dynamicTable += "<td class='text-center'>" + '<a class="btn btn-primary delete" onclick="javascript: fileDeleteAction(\'' + tableData.ServerRelativeUrl + '\',\'' + folderUrl + '\');">Delete</a>' + "</td>";
      dynamicTable += "</tr>";
    }

    document.getElementById("datatable").innerHTML = dynamicTable;

    table = $('#table_id').DataTable();
  },
  error: function (err) {

    console.error("Error: ", err);
  }
});

}

This is working fine.But my requirement is if the folder name is Improvement-Projects-2020 then that folder data only I can retrieve I want to retrieve Improvement-Projects-2019 files also Please help me

Answer 1

Use promise, you could request multiple requests and get return data from these requests and then bind the data.

Sample script:

<script>
    var d = new Date();
var n = d.getFullYear();
fileGetAction("/sites/dev/QualityCI" + '/Improvement-Projects-' + n.toString(),"/sites/dev/QualityCI" + '/Improvement-Projects-' + (n-1).toString());

function fileGetAction(...args) {
if(arguments.length==0){
    console.log("There is no corresponding folder in the library")
    return;
}    
    var reqs=new Array()
$('#table_id tbody').empty();
    var dynamicTable = "";
for(var i=0;i<args.length;i++){
    var folderUrl=args[i]
    var requestURL = _spPageContextInfo.webAbsoluteUrl+ "/_api/web/GetFolderByServerRelativeUrl('" + folderUrl + "')/Files";

reqs[i] = _ajax(requestURL)
}
    Promise.all(reqs).then((result) => {

       var dynamicTable = "";
  for (j = 0; j < result.length; j++) {

      for(var x=0;x<result[j].d.results.length;x++){
          var tableData = result[j].d.results[x]
          dynamicTable += "<tr>";
      dynamicTable += "<td>" + tableData.Name.split('.').slice(0, -1).join('.') + "</td>";
      dynamicTable += "<td>" + '<a href= "' + tableData.ServerRelativeUrl + '"> "' + tableData.Name + '"</a>' + "</td>";
      dynamicTable += "<td class='text-center'>" + '<a class="btn btn-primary delete" onclick="javascript: fileDeleteAction(\'' + tableData.ServerRelativeUrl + '\',\'' +args[j] + '\');">Delete</a>' + "</td>";
      dynamicTable += "</tr>";
      }

    }
        document.getElementById("datatable").innerHTML = dynamicTable;
    table = $('#table_id').DataTable();
}).catch((error) => {
  console.log(error)
})
}

    function _ajax(requestURL){
        return new Promise((resolve, reject) => {
         $.ajax({
  url: requestURL,
  type: "GET",
  headers: {
    "Accept": "application/json;odata=verbose"

  },
             success: function(data) {
        resolve(data)
      },
      error: function(error) {
        reject(error)
      }
})
     })
    }
    </script>