importing external javascript to google apps scrip

2019-01-13 14:29发布

问题:

I am trying to use Trello from a Google Spreadsheet (Google Docs) and am not sure how to import/reference/link the javascript files required to use their library. My only other option is using their REST API directly (fine, but I'd rather use their js helper classes).

This is what Trello needs us to use:

 <script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
 <script src="https://api.trello.com/1/client.js?key=substitutewithyourapplicationkey"</script>

How would I import/include these in a Google Apps Script?

THANKS!!!

回答1:

Based on the answer here by Cameron Roberts, you can use the eval() function on the appscript UrlFetchApp function.

eval(UrlFetchApp.fetch('http://path.to/external/javascript.js').getContentText());


回答2:

you actually can . In the script project create another new file and simply just paste the JavaScript library copying from the source and save it then start referencing it from other file. It is that simple.

Or you can create another project with the .js lib and publish it and reference that script from the caller project, I wont do that unless that needs to be shared in multiple projects.



回答3:

You cannot use external javascript libraries this way in Google Apps Script. (You can do so in html files used with the HtmlService. Since so much of Trello is client-side anyway, this may be just what you need.)

In server-side apps script, you should be able to access the library code using the technique from this answer. It doesn't say, but I'd imagine that you would put that eval outside of all functions in your script, to make the objects in the library available to the rest of your code.



回答4:

Download them and put them in the script. The rest api is easy to use. Ive used trello rest from appscript.



回答5:

Yes you can use JavasSript libraries in Google script. Copy all content of the libraries JavaScript and post it in new GS file.



回答6:

You can try this 2 options:

  • Use it as a normal script tag <script src="https://unpkg.com/babel-standalone@6/babel.min.js"></script>
  • Download the js files and reference them as google says in the docs https://developers.google.com/apps-script/guides/html/best-practices <?!= include('JavaScript'); ?>

Hope this helps