function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var menuEntries = [ {name: "NodeChecker", functionName: "myFunction"}];
  ss.addMenu("Script", menuEntries);


  var range= SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(1, 1);
  var titles = ["Address", "Time", "IP Test", "Time test", "Calendar test", "Credit test"];
  for(var i=0; i<6; i++) {
     range.offset(0, i).setValue(titles[i]);
  }
}

function U2Gtime(unixtime) {
  var newDate = new Date( );
  newDate.setTime( unixtime );
  dateString = newDate.toUTCString( );
  return dateString
}

function myFunction() {


  var range= SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(1, 1);
  var row= SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getLastRow();


  for(var n=0; n<(row-1); n++) {

    var address = range.offset(n+1, 0).getValue();

    range.offset(n+1, 1, n+1, 5).clearContent();


    var response = UrlFetchApp.fetch("https://a.chainpoint.org/nodes/"+ address +"",{ muteHttpExceptions:true });
    if(response.getResponseCode() != 200) {
      range.offset(n+1, 1).setValue("404 not found");
      continue;
    }

    var testResult = JSON.parse(response.getContentText());


    //for(var i=0; i<testResult.recent_audits.length; i++) {
    for(var i=0; i<1; i++) {
      var event = testResult.recent_audits[i];


      range.offset(n+1, 1).setValue(U2Gtime(event.time));


      range.offset(n+1, 2).setValue(event.public_ip_test);


      range.offset(n+1, 3).setValue(event.time_test);


      range.offset(n+1, 4).setValue(event.calendar_state_test);


      range.offset(n+1, 5).setValue(event.minimum_credits_test);
    }
    Utilities.sleep(3000);
  }
}