LinkedIn
Twitter
Hi everybody,
I write a lot of Apps Scripts and many of them pull and push data to BigQuery as well as perform many other custom functions. I recently wrote a small function to refresh all Connected Sheets -- i.e: tables that are connected to BigQuery.
I was going to make this function a webapp so that I can trigger it through an orchestration tool (Airflow). I've deployed webapps and webhooks before and I've never had a problem until now.
But today, I'm getting this error message:
I looked into it and my BigQuery project is under 'No Organization' whereas my current Apps Script might be in my actual organization.
But why is it only NOW that I'm hitting a limitation?
It seems inconsistent. I have other Apps Scripts that pull and push data from my Google Cloud project, but for some reason THIS script won't allow me to do that.
It seems like I would have to migrate my google cloud project from 'No Organization' into my organization, but I'm hesistant because I'm not sure if there will be unintended consequences.
This is my small function to refresh sheets:
function RefreshConnectedSheets() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('C1').activate();
SpreadsheetApp.enableAllDataSourcesExecution();
spreadsheet.refreshAllDataSources();
};
Can anyone explain why apps scripts works in almost every other instance except for trying to deploy this particular script? Like.... why was I able to deploy other apps scripts as web apps but not this one?
Any official insight or references would be greatly appreciated — I'm trying to determine if this is an intentional design decision or something I can work around. Do I really need to migrate into the organization just for this to function? Is there a workaround?
Thanks!
