Passing a 2D array to HTML using googlescript

Question

I am trying to pass a 2D array created in a Javascript file here:

Code.gs

function getPermits()
{
  Logger.log('Starting permits');
  var permits =  SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getDataRange().getValues();
  Logger.log('Got permits: ' + permits [0][0]);

  return permits;
}

And I call that function with a handler in this html file:

<script type="text/javascript">
   function onSuccess(numUnread) {
    alert('You have ' + numUnread[0][0]
       + ' unread messages in your Gmail inbox.');
      document.getElementById("id2").innerHTML = numUnread[0][0];


}

   function onFail(numUnread){
   alert('Script failed!');
   }

 google.script.run.withSuccessHandler(onSuccess).getPermits();
 google.script.run.withFailureHandler(onFail).getPermits();
</script>

The Logger.log('Got permits: ' + permits[0][0]); call works perfect no matter what. However, while I can pass a 1D array in this manner and it works fine, passing a 2D array is causing this to fail. Why does this happen? Am I using improper syntax for this?

Thanks in advance

Kriggs · Accepted Answer · 2015-03-27 17:24:17Z

2

Stringify it as a JSON object, then you can pass just a String, which works fine:

return JSON.stringify(permits);

And on HTML:

function onSuccess(numUnread) {
  numUnread = JSON.parse(numUnread);

answered Mar 27, 2015 at 17:24

Kriggs

3,7761 gold badge19 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Jordando Over a year ago

is this technically necessary? As in, is there no alternative? If so, why does using a 1d array work just fine but this doesn't?

Kriggs Over a year ago

What's the data in the permits? Number, string, dates...?

Jordando Over a year ago

The data is coming from a google spreadsheet that contains numbers, dates, and strings

Kriggs Over a year ago

AFAIK, Dates are not a permitted type to pass trough Apps Script Servers and the Javascript Client. developers.google.com/apps-script/guides/html/reference/run, you can try to encode the date or stringfiy it.

Jordando Over a year ago

Ahh thanks very much! I have confirmed that without the dates I can return the 2d array successfully. Is JSON the goto method then for handling dates?

|

Collectives™ on Stack Overflow

Passing a 2D array to HTML using googlescript

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related