XMLHTTPRequest is not defined? Google Spreadsheets?

12,815

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

Share:
12,815
user2577475
Author by

user2577475

Updated on June 28, 2022

Comments

  • user2577475
    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 
      }