Script No longer Writting to Sheets

57 views
Skip to first unread message

G

unread,
Mar 21, 2022, 5:03:23 AM3/21/22
to Google Apps Script Community
I'm very new to Scripts and am having problems and was hoping for some suggestions to resolve. I was using the following script to upload data every 30 min and populate a spreadsheet. The first column is the current date/time followed by various data in the next 5 columns. It starts a new row with a new data group. It ran for about a day with no issues and then stopped writing data. The hardware is still sending data and the script execution log indicates it is executing.  I tried redeploying and also deploying with new ID with no results. Any idea why it would stop writing data or how troubleshoot the problem? Thanks.

Function doGet(e) { 
  Logger.logJSON.stringify(e) );
  var result = 'Ok';
  if (e.parameter == 'undefined') {
    result = 'No Parameters';
  }
  else {
    var sheet_id = '1adwHUpM2s5MUCR6U_u5GW34dr59Su-RhQxxxxxx';  // Spreadsheet ID
    var sheet = SpreadsheetApp.openById(sheet_id).getActiveSheet();
    var newRow = sheet.getLastRow() + 1;            
    var rowData = [ ];
    rowData[0] = new Date();  
    for (var param in e.parameter) {
      Logger.log('In for loop, param=' + param);
      var value = stripQuotes(e.parameter[param]);
      Logger.log(param + ':' + e.parameter[param]);
      switch (param) {
        case 'value1'//Water Pressure (PSI)
          rowData[1] = value//Value in column B
          result = 'Written on column B';
          break;
        case 'value2'//Water Temp (F)
          rowData[2] = value//Value in column C
          result += ' Written on column C';
          break;
        case 'value3' : //Air Pressure (PSI)
          rowData[3] =value//Value in column D
          result  += 'Written on Column D';
          break;
        case 'value4' : //Air Temp (F)
          rowData[4] = value;  //Value in column E
          result  +=  'Written on Column E';
          break;
        case 'value5' : //Battery vcc (volts)
          rowData[5] = value//Value in column F
          result  += 'Written on Column F';
          break;
        default:
          result = "unsupported parameter";
      }
    }
    Logger.log(JSON.stringify(rowData));
    var newRange = sheet.getRange(newRow11,rowData.length);
    newRange.setValues([rowData]);
  }
  return ContentService.createTextOutput(result);
}
function stripQuotesvalue ) {
  return value.replace(/^["']|['"]$/g"");
}

Reply all
Reply to author
Forward
0 new messages