CODEWITHSUNDEEP
javascriptajaxgoogle-apps-scriptgoogle-sheetsgoogle-sheets-api
user2577475
user2577475

Reputation: 171

Ajax calls made from Google Spreadsheet Custom Function

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();

Upvotes: 10

Views: 13507

Answers (1)

Mogsdad
Mogsdad

Reputation: 45750

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.

Upvotes: 16

Related Questions