我尝试的第一个循环在代码的/ * * /中。第二个代码是do while循环。在这两种情况下，循环只会继续，并且不会重复嵌套循环。我不太确定自己在做什么错。 while条件可能不正确，但我担心的是未重置内部循环。索引似乎未重置为0。

我正在使用Google Apps脚本

function getWorkingSessions() {
  var api_token = "************************";
  var range_start = "2019-09-01";
  var range_end = "2019-09-02";
  var company = "*****";
  var range = Spreadsheetapp.getactiveSpreadsheet().getSheetByName("Daten Papershift")
  var row = range.getLastRow()+1;
  var pageget = 1

  var options = {
    'method' : 'get','contentType': 'application/json',};

  /* var result = UrlFetchApp.fetch("https://app.papershift.com/public_api/v1/working_sessions?api_token=" + api_token + "&range_start=" + range_start + "&range_end=" + range_end + "&page=" + pageget + "&company_id=" + company);
  if (result.getResponseCode() == 200) {
    var session = JSON.parse(result.getcontentText());
    var params = session.working_sessions;

   /* for (; page < 3; page++) {
      var resultb = UrlFetchApp.fetch("https://app.papershift.com/public_api/v1/working_sessions?api_token=" + api_token + "&range_start=" + range_start + "&range_end=" + range_end + "&page=" + page + "&company_id=" + company);
      var sessions = JSON.parse(resultb.getcontentText());
      var workingsessions = sessions.working_sessions;
      var index = 0;

      for (; index < workingsessions.length -1; index++,row++) {
        range.getRange(row,1,1).setvalue(workingsessions[index].id);
        var datum = Utilities.formatDate(new Date(workingsessions[index].starts_at),"GMT","dd.MM.yyyy");
        range.getRange(row,2,1).setvalue(datum)
        var start = Utilities.formatDate(new Date(workingsessions[index].starts_at),"HH:mm");
        range.getRange(row,3,1).setvalue(start);
        var end = Utilities.formatDate(new Date(workingsessions[index].ends_at),4,1).setvalue(end);
        range.getRange(row,5,1).setvalue(workingsessions[index].location_id);
        range.getRange(row,6,1).setvalue(workingsessions[index].employee_id);
      };
    }; */
    var page = 1;

    do {
      var resultb = UrlFetchApp.fetch("https://app.papershift.com/public_api/v1/working_sessions?api_token=" + api_token + "&range_start=" + range_start + "&range_end=" + range_end + "&page=" + page + "&company_id=" + company);
      var sessions = JSON.parse(resultb.getcontentText());
      var workingsessions = sessions.working_sessions;
      var index = 0;
      for (; index < workingsessions.length-1; index++,"GMT+2",1).setvalue(workingsessions[index].employee_id);
      };
      page++;
    } while ( sessions.next_page != "null" );

 /* } else {}; */
};