XMLHTTPRequest is not defined? Google Spreadsheets?
12,815
Google Apps Script does not support that function, see this answer for guidance.
Author by
user2577475
Updated on June 28, 2022Comments
-
user2577475 almost 2 years
I'm fairly new to Ajax and was working on some scripts in Google Spreadsheets and was given the error: "ReferenceError: "XMLHttpRequest" is not defined. (line 21, file "getBookmarks")". Is there a problem with my code or is it that certain functions are limited when making a XMLHtppRequest in Google Spreadsheets to an external source?... I checked and all the other functions I used were fine?
function getBookmarks() { //Opening Active Spreadsheet var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; // Get the range of cells that stores event data. var eventDataRange = ss.getRangeByName("Url"); // Stores URL into eventObject var eventObject = getRowsData(sheet, eventDataRange); for (var i=0; i < countProperties(eventObject); i++) { //Making the Ajax Call var xmlhttp; xmlhttp=new XMLHttpRequest(); xmlhttp.open("GET",eventObject[i],true); } //search for string ""global-bookmark-count" class="count-text">" //get bookmark number bookmark //return bookmark //returning bookmark count }