Ajax calls made from Google Spreadsheet Custom Function
10,916
Google Apps Script does not support XMLHttpRequest()
natively, but as you suspected there are services that can accomplish the same thing.
Look at UrlFetch Services, Class Xml (deprecated) and Xml Services.
One of the apps script tutorials (Accessing Picasa Web Albums through Apps Script) covers the use of these services, and would be a good place for you to start.
Related videos on Youtube
Author by
user2577475
Updated on June 04, 2022Comments
-
user2577475 almost 2 years
Has anyone ever tried to write a script inside a Google Spreadsheet to make an ajax call to a website?
I want to make it so that the spreadsheet updates itself from the website. But after just putting this short block of code, I get thrown an error:
"ReferenceError: "XMLHttpRequest" is not defined."
Any idea? Do I have to call a certain library?
xmlhttp=new XMLHttpRequest(); xmlhttp.open("GET", eventObject[1], true); xmlhttp.send();