我有电子表格,我创建了script.google.com代码作为网络API,以将电子表格数据导出为json,但是当写入代码读取json时出现问题“已被CORS政策阻止
var dataJSON;
function viewVillages(){
var xmlhttp = new XMLHttpRequest();
var url = "script.google.com";
xmlhttp.onreadystatechange = function() {
if (this.readyState == 1 ) {
console.log("1");
}
if (this.readyState == 2 ) {
console.log("2");
}
if (this.readyState == 3 ) {
console.log("3");
}
if (this.readyState == 4 && this.status == 200) {
console.log("4");
var myArr = JSON.parse(this.responseText);
myFunction(myArr);
}
};
xmlhttp.open("GET",url,true);
xmlhttp.send();
function myFunction(arr) {
dataJSON=arr;
}
}
用于发布Web应用API的代码 我将其发布为网络应用API,任何人都可以访问该应用, 此结果链接
function doGet(e){
var ss = Spreadsheetapp.openByUrl("url");
var sheetgoogle = ss.getSheetByName("labs");
return getUsers(sheetgoogle);
}
function getUsers(sheetgoogle){
var ps = {};
var dataArrayGoogle = [];
var rowsGoogle = sheet.getRange(2,1,sheetgoogle.getLastRow()-1,sheetgoogle.getLastColumn()).getvalues();
for(var i = 0,l= rowsGoogle.length; i<l ; i++){
var dataRowGoogle = rowsGoogle[i];
var recordSheet={} ;
recordSheet[0] = dataRowGoogle[0];
recordSheet[1] = dataRowGoogle[1];
dataArrayGoole.push(recordSheet);
}
ps.user = dataArrayGoogle;
var result = JSON.stringify(ps);
return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON)
}