Reputation: 341
Hi I found a google web app that shows the exchange rates of different currencies, I would like to access the original code to see how it was made. Is there a way to do this or am I blocked? I hope I am not missing something obvious.
Here is the app in question https://script.google.com/a/macros/essilor.com.sg/s/AKfycbxImXs3GS_G1Cdiqefg1pu_BQTwMWNQ5iwbAuy1eEer5ePkG9kt/exec
Upvotes: 1
Views: 49
Reputation: 3355
You cannot access web based application unless the owner deploy it as "Who has access to the app: Anyone / Anyone, even anonymous"
In order to fetch exchange rates you can use the below.
var sheetDatabase = SpreadsheetApp.openById("<<Spreadsheet ID>>").getSheetByName("<<sheet Name>>");
sheetDatabase.getRange(2, 1).setFormula('=GOOGLEFINANCE("CURRENCY:EURUSD")');
Upvotes: 1