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
}
Google Apps Script does not support that function, see this answer for guidance.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With