访问CORS政策已阻止访问位于https://script.google.com/macros/的XMLHttpRequest

我有电子表格,我创建了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,任何人都可以访问该应用, 此结果链接

https://script.googleusercontent.com/macros/echo?user_content_key=idpffu-SYlDxC7EuWBf-NqgCGhMPNeiXeBQUt-Tk-dDFoqb6JYzKvNyw405zrlyQEDgaTlGUksHOTbbV5Aj9STHlRS9FtMxjm5_BxDlH2jW0nuo2oDemN9CCS2h10ox_1xSncGQajx_ryfhECjZEnNhRObYMMbRvDsIN0NCwYbNGFGtS5GcRpQ0e15R5Rfx0Jy77eUQpR9E0M2qu45i7T6drUwBK3ZY_&lib=MMMohOFXoOCvrcVJ1jiPfgJKNXc8Lw_h0

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)

} 
mmaiyy02 回答:访问CORS政策已阻止访问位于https://script.google.com/macros/的XMLHttpRequest

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3130152.html

大家都在问