Keep getting range not found & column errors.Not sure what is wrong here. need help

[Jasdeep Singh Pardeep Singh]

Keep getting range not found & column errors. Please help

function refreshOpsPortalStationStatus() {

  var ss = SpreadsheetApp.openById('1oigekXxW-Yx2PFgJ0Si5VFBuAtx0CTYI2769TPiiEY0');

  var sheet = ss.getSheetByName("Import Station Details OpsPortal");

  var oldRange = sheet.getRange('A2:G'+sheet.getLastRow());

  

  var data = ImportJSON("https://api.prod.setel.my/api/stations/stations?perPage=2000","/id,/name,/address,/latitude,/longitude,/isActive,/status","noInherit,noTruncate,noHeaders");

  var newRange = sheet.getRange('A2:G'+(data.length+1));

  

  if(data){

    oldRange.clear();

    newRange.setValues(data);

    newRange.sort(1)

  }

  

  refreshOpsPortalStationFeatures();

}

function refreshOpsPortalStationFeatures() {

  var ss = SpreadsheetApp.openById('1oigekXxW-Yx2PFgJ0Si5VFBuAtx0CTYI2769TPiiEY0');

  var sheet = ss.getSheetByName("Import Station Features OpsPortal");

  var oldRange = sheet.getRange('A2:D'+sheet.getLastRow());

  

  var data = ImportJSON("https://api.prod.setel.my/api/stations/stations?perPage=2000","/id,/name,/features/typeId,/features/featureItems","noTruncate,noHeaders");

  var newRange = sheet.getRange('A2:D'+(data.length+1));

  

  if(data){

    oldRange.clear();

    newRange.setValues(data);

    newRange.sort(1)

  }

}