5个配置相同的Google Sheets仅1个触发401请求失败异常
问题:单个Google Sheets脚本触发401授权错误
我拥有5个配置完全相同的Google Sheets,均使用以下代码,但其中1个触发了错误:
Exception: Request failed for https://docs.google.com returned code 401. Truncated server
使用的代码
//Get active sheets var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); // Base URL this is used to send to the API var url = "https://docs.google.com/spreadsheets/d/SS_ID/export?".replace("SS_ID", ss.getId()); //Format PDF settig up styling var url_ext = 'exportFormat=pdf&format=pdf' // export as pdf / csv / xls / xlsx + '&size=A4' // paper size legal / letter / A4 + '&portrait=true' // orientation, false for landscape + '&fitw=true&source=labnol' // fit to page width, false for actual size + '&sheetnames=false&printtitle=false' // hide optional headers and footers + '&pagenumbers=false&gridlines=false' // hide page numbers and gridlines + '&fzr=false' // do not repeat row headers (frozen rows) on each page + '&gid='; // the sheet's Id //API to fetch PFD of google sheet var token = ScriptApp.getOAuthToken(); var response = UrlFetchApp.fetch(url + url_ext + sheet.getSheetId(), { headers : { 'Authorization' : 'Bearer ' + token } }).getBlob().setName(sheet.getName() + ".pdf"); sheet_as_pdf_blob_document=response; // Define your variables here var beerOrderrecipient="test@test.com"; var beerOrdersubject=SpreadsheetApp.getActiveSpreadsheet().getName(); var beerOrderbody="Hello,\n\nNew items have been added to your Ordered Beer List. Attached is a printable copy of the most up to date list. \n- Have a great day!"; var nameOfSender="Operations"; function sendOrderedSheet() { var message = { to: beerOrderrecipient, subject:beerOrdersubject, body: beerOrderbody, name: nameOfSender, attachments: [sheet_as_pdf_blob_document] } MailApp.sendEmail(message); SpreadsheetApp.getUi().alert("The email has been sent thank you!"); }
我不清楚该表格与其他表格的差异所在,若需要补充其他信息请告知!
更新:我已解决该问题。原因是存在一个很久以前创建的触发器,它调用另一个函数但从未执行成功,每日自动触发并失败,删除该触发器及其关联函数后,所有功能恢复正常!
内容的提问来源于stack exchange,提问作者dachil1pil1
相关产品推荐
相关产品推荐

