List pages api only fetching 100 pages

1

I am trying to fetch all the pages of CODA to google sheet using google app script but only 100 pages are fetched from third party software like coupler.io or using google app script. The code is below:

function fetchPageList() {
 var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getSheetByName('Main');

  var DocID = sheet.getRange('B2').getValue();
 var APIToken = sheet.getRange('C2').getValue();
  CodaAPI.authenticate(APIToken);
var pages = CodaAPI.listPages(DocID).items;

 
  var rows = [],
  data;
  for (i = 0; i < pages.length; i++) {
    data = pages[i];
    rows.push([data.id, data.type, data.name,data.parent?data.parent.id:'',data.browserLink]); //your JSON entities here
  }
  row =5;
  col= 2;
  sheet.getRange( row, col, rows.length, 5).setValues(rows);


}
2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.