How to get Zipabox to detect its own zombification and self-reboot

How to remotely de-zombify a Zipabox guide... awesome.

Well Dave, you just showed again how greatly you know the system and how to get around it...

Forget to format the code. Sorry!

David, this date-time meter is a virtual meter and current date-time acts as counter?

Or, are you able to store date time in virtual meter?

thanx, Martin

This is my post on the date-time meter:

https://community.zipato.com/topic/a-method-for-creating-manipulable-time-and-date-values

It works very well and I use it all over the place.

Yesterday I was puzzled in by a claim in this post:

https://community.zipato.com/topic/creating-a-rule-using-sunsetsunrise-for-outdoor-lights

that you can store time values in variables. In my experience, that doesn't work. I'll check it out in case Zipato have fixed something.

For anyone thinking of implementing my scheme, it ran into a bit of a snag: the TP-Link token expires fairly frequently. I'd already set up a Google App Script that monitors the updates to a Google Sheet where the Zipabox logs important data every ten minutes. If it sees that there hasn't been an update for a while, it sends me a message. I decided to extend that to make the script reboot the Zipabox directly. From a script, getting a new token is not a problem. I force the renewal of the token each week, and if I get the expired token error, I also renew it and try again. I store the token in another Google Sheet which I use to note down when my calls to weather services have failed recently.

To complete this solution, I invoke the reboot part of the Google App Script from the RebootSelf rule in the Zipabox. And it apparently works!

I will just post the reboot part here for now. If you also want the part that monitors the log, let me know.

var sTPLinkLoginAccessToken = "";

// Allows reboot to be executed from Zipabox
function doPost(e) 
{
  Logger.log("doPost");
  return RebootZipabox();
};

function RebootZipabox()
{
    var nErrorCodeToken = 0;
    var bRenewAccessToken = false;
    
    // Should we force the renewal of the access token? Only on Saturdays between 12:00 and 12:10
    var dateNow = new Date();
    var nHour = dateNow.getHours();
    var nMinute = dateNow.getMinutes();
    
    if (dateNow.getDay() == 6 && nHour == 12 && nMinute >= 0 && nMinute <= 10)
    {
      bRenewAccessToken = true;
    }        
    
    // Open API call failure spreadsheet to get/renew token
    var docCallFailures = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/<SPREADSHEETID>/edit');
    var sheetCallFailures = docCallFailures.getSheets()[0];  
    
    // Check sheet for login auth
    // getRange(row, column, NumRows (number of rows in the range)). Numbers are 1-based
    sTPLinkLoginAccessToken = sheetCallFailures.getRange(9,5,1).getCell(1,1).getValue();
    
    // Need to get access token if we don't have it
    if (sTPLinkLoginAccessToken == '')
    {
      bRenewAccessToken = true;
    }        
    
    // Get new token
    if (bRenewAccessToken)
    {
      nErrorCodeToken = GetNewTPLinkToken(sheetCallFailures);
    }
    
    if (nErrorCodeToken == 0)
    {
      // Try rebooting TPLink
      var nErrorCodeReboot = TryToRebootTPLink();
      
      // Did reboot fail due to an old access token?
      if (nErrorCodeReboot = -20651)
      {
        // Get new access token
        nErrorCodeToken = GetNewTPLinkToken(sheetCallFailures);
        
        if (nErrorCodeToken == 0)
        {
          // Try again
          nErrorCodeReboot = TryToRebootTPLink();
          
          if (nErrorCodeReboot != 0)
          {
            return ContentService
            .createTextOutput(JSON.stringify({"result":"error", "error": nErrorCodeReboot}))
            .setMimeType(ContentService.MimeType.JSON);              
          }
        }
      }
    }
    
    // Prepare standard HTTP POST stuff for Newtifry
    var options =
        {
          "contentType" : "text/plain",
          "method" : "post"
        };
    
    // Send Newtifry message
    UrlFetchApp.fetch("http://api.pushingbox.com/pushingbox?devid=<YOURPUSHINGBOXSCENARIOID>", options);        
    
    // Notify myself via email
    MailApp.sendEmail({to:'<YOUREMAIL>',‌subject: "Zipabox is zombified",body: "Rebooting Zipabox from Google App Script"});    
        
    // return json success results
    return ContentService
          .createTextOutput(JSON.stringify({"result":"success"}))
          .setMimeType(ContentService.MimeType.JSON);        
}

function TryToRebootTPLink()
{
    // Prepare params for body
    var bodyParams = 
        {
          "deviceId":"<YOURTPLINKDEVICEID>",
          "requestData":"{\"system\":{\"reboot\":{\"delay\":2}}}"
        };
    
    // Prepare body of POST (payload)
    var postBody = 
        {
          "method":"passthrough",
          "params": bodyParams
        };
    
    var payload = JSON.stringify(postBody);
    
    var optionsTPLink = 
        {
          "method" : "POST",
          "contentType" : "application/json",
          "muteHttpExceptions": true,
          "payload" : payload
        };
        
    var sURL = "https://eu-wap.tplinkcloud.com/?token=" + sTPLinkLoginAccessToken;
    
    var requestTest = UrlFetchApp.getRequest(sURL, optionsTPLink);
    
    // Send the command to the TP-Link
    var requestTPLink = UrlFetchApp.fetch(sURL, optionsTPLink);
    
    if (requestTPLink.getResponseCode() == 200)
    {
      var resultTPLink = JSON.parse(requestTPLink.getContentText());
      
      if (resultTPLink != null)
      {
        return resultTPLink.error_code;
      }
    }
    
    return 0;
}

function GetNewTPLinkToken(sheetCallFailures)
{
    // Prepare params for body
    var bodyParams = 
        {
           "appType": "Kasa_Android",
           "cloudUserName": "<YOURKASAUSERNAME>",
           "cloudPassword": "<YOURKASAPASSWORD>",
           "terminalUUID": "MY_UUID_v4"
        };
    
    // Prepare body of POST (payload)
    var postBody = 
        {
          "method":"login",
          "params": bodyParams
        };
    
    var payload = JSON.stringify(postBody);
     
    var optionsTPLink = 
        {
          "method" : "POST",
          "contentType" : "application/json",
          "payload" : payload
        };
  
    // Send the command to the TP-Link
    var requestTPLink = UrlFetchApp.fetch("https://wap.tplinkcloud.com", optionsTPLink);
    
    if (requestTPLink.getResponseCode() == 200)
    {
      var resultTPLink = JSON.parse(requestTPLink.getContentText());
      
      if (resultTPLink != null)
      {
        if (resultTPLink.error_code == 0)
        {
          sTPLinkLoginAccessToken = resultTPLink.result.token;

          // Store new token in sheet
          // getRange(row, column, NumRows (number of rows in the range)). Numbers are 1-based
          sheetCallFailures.getRange(9,5,1).getCell(1,1).setValue(sTPLinkLoginAccessToken);
        }
        
        return resultTPLink.error_code;
      }
    }
    
    return 0;
}

This is the rule that calls the app script. The GaS must be made accessible to anyone, even anonymous (I think). Otherwise you can't invoke it from outside.