JDBC:应用程序脚本和Google MySQL:异常:您没有调用JDBC.getCloudSqlConnection的

Question

下面列出的代码当我试图在电子表格中使用此函数时，我会收到以下错误：Google脚本错误-异常：您没有权限调用Jdbc.getCloudSqlConnection

关于如何解决这个问题有什么想法吗？连接成功了，但在创建表时卡住了

var connectionName = 'cosmic-tenure-310821:us-central1:propertydata';
var rootPwd = "password";
var user = "root";
var userPwd = 'password';
var db = 'propertydata';
var root = 'root';
var instanceUrl = "jdbc:google:mysql://" + connectionName;
var dbUrl = instanceUrl + "/" + db;
function createTable() {
var conn = Jdbc.getCloudSqlConnection(dbUrl, user, userPwd);
conn.createStatement().execute('CREATE TABLE myProperties(APN INT, APNObject MEDIUMBLOB)');
}

Answer 1

尝试添加"oauthScopes"；

"oauthScopes": ["https://www.googleapis.com/auth/gmail.addons.execute","https://www.googleapis.com/auth/cloud-platform", "https://www.googleapis.com/auth/sqlservice", "https://www.googleapis.com/auth/sqlservice.admin", "https://www.googleapis.com/auth/gmail.readonly", "https://www.googleapis.com/auth/script.external_request", "https://www.googleapis.com/auth/userinfo.email", "https://www.googleapis.com/auth/gmail.addons.current.action.compose"]