Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

XMLHTTPRequest is not defined? Google Spreadsheets?

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 
  }
like image 608
user2577475 Avatar asked Oct 22 '22 05:10

user2577475


1 Answers

Google Apps Script does not support that function, see this answer for guidance.

like image 158
Mogsdad Avatar answered Oct 27 '22 09:10

Mogsdad