pass google script object to html template

Question

I working on standalone web app in google script using HtmlService. Here's the part of code:

script:

function doGet() {
 getLabelsLists();
  return HtmlService
      .createTemplateFromFile('index')
      .evaluate().setSandboxMode(HtmlServi‌ce.SandboxMode.NATIVE);
}

function getEmails() {
  var query = ...;
  var threads = GmailApp.search (query);
  return threads;
}

index.html:

<? var data = getEmails(); ?>
<table>
  <? for (var i = 0; i < data.length; i++) { 
  var message = data[i].getMessages()[0];
  ?>
    <tr onclick= click(<?= message.getId() ?>)>
        <td><?= message.getSubject() ?></td>
    </tr>
  <? } ?>
</table>

What I want to do is show only button like below on page load and on click call function that render table with a results.

 <input type="button" onclick="google.script.run.getEmails()" />

Any ideas how I can pass the array of gmail threads from getEmails() function to the view and dynamically create table?

Henrique G. Abreu · Accepted Answer · 2014-11-17 19:14:40Z

4

You cannot pass such object (with function and custom prototype), only "simple" ones (composed of strings, numbers, booleans and arrays or objects containing those), like stated in the documentation. Therefore you'll have build an object with the values you need in order to pass it. Taking your usage example of getting the id and subject of only the first message in the threads, here's how it's done:

function getEmails() {
  var query = "...";
  return GmailApp.search(query).map(function(thread) {
    var msg = thread.getMessages()[0];
    return {id:msg.getId(), subject:msg.getSubject()};
  }
}

Then, to "read" the values, you should access id directly, instead of calling getId(), and subject, instead of getSubject().

answered Nov 17, 2014 at 19:14

Henrique G. Abreu

17.8k3 gold badges58 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

pass google script object to html template

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related