romainvialard/errorhandler

This is a library for Google Apps Script projects. It provides methods to perform an Exponential backoff logic whenever it is needed and rewrite error objects before sending them to Stackdriver Logging.

errorhandler's Issues

Allow for silent failure when expBackoff() failed to execute successfully

Add a parameter to allow silent failure (eg: don't throw an exception when execution fails multiple times)

Cannot read property "0" from undefined.

Do you have suggestions to investigate / fix this issue?
matcher.variables can be undefined.

ErrorHandler/src/ErrorHandler.gs.js

Line 382 in 1fdd98b

for (var j = 0, variable; variable = matcher.variables[j]; j++) {

Also as it is not a "sub-loop", should we stick to j as iterator or switch to i?

Use normalized error in expBackoff()

For the specific error:

• Invalid requests
• Access denied
• Mail service not enabled

How to contribute/ask about error messages?

I found a conversation where Romain and Jean-Remi mentioned this repo while I was researching about an add-on error message, more explicitely about "You do not have permission to call showSidebar at functionName (fileName: lineNumber)". This error occurs on add-ons triggers created by user A from mydomain.com that are activated by actions made by user B from domain otherdomain.com when functionName tries to open a sidebar.

1. Are this kind of errors something of interest for you?
2. I didn't tried yet this library but if this error message isn't catched could I ask about it here?

---

Something like the following should help to reproduce the error message.

function onInstall(event) {
  onOpen(event);
}

function onOpen(event){
  SpreadsheetApp
  .getUi()
  .createAddonMenu()
  .addItem('Add trigger', 'addTrigger')
  .addItem('Remove all triggers', 'removeTriggers')
  .addToUi();
}

function addTrigger(){
  ScriptApp.newTrigger('respondeToSpreadsheetEdit')
  .forSpreadsheet(SpreadsheetApp.getActive())
  .onEdit()
  .create();
  SpreadsheetApp.getUi().alert('Trigger added.');
}

function respondeToSpreadsheetEdit(event){
  var html = '<p>Hello world!</p>';
  var title = 'Sidebar title';
  var userInterface = HtmlService.createHtmlOutput(html)
  .setTitle(title);
  SpreadsheetApp.getUi().showSidebar(userInterface);
}

function removeTriggers(){
  var triggers = ScriptApp.getProjectTriggers();
  triggers.forEach(function(trigger){
    ScriptApp.deleteTrigger(trigger);
  });
  SpreadsheetApp.getUi().alert('All triggers were removed.');

}

Steps to reproduce the error message

1. Publish the above code as a Google Sheets add-on
2. User A install the add-on, click on Add-ons > Add-on name > Add trigger
3. User A shares the spreadsheet with user B
4. User B edit cell A1
5. Open the Stackdriver log for the add-on. There you will find something like the following:

You do not have permission to call showSidebar at respondToSpreadsheetEdit(Code:n)

where n is the code line number for SpreadsheetApp.getUi().showSidebar(userInterface);

P.S. Spanish version of the error message

No cuenta con el permiso para llamar a showSidebar at respondeToSpreadsheetEdit(Código:27)

---

Related issue on the Apps Script Issue Tracker

• Critical: Google Docs Add ons show error "You do not have permission to call showSidebar"

Migrate Error.fileName & Error.lineNumber

As according to the GAS migration guide to V8:
https://developers.google.com/apps-script/guides/v8-runtime/migration#avoid_using_errorfilename_and_errorlinenumber