Ajax calls made from Google Spreadsheet Custom Function

javascript ajax google-apps-script google-sheets google-sheets-api
user2577475 picture user2577475 · Aug 2, 2013 · Viewed 9k times · Source

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

Answer

Mogsdad picture Mogsdad · Sep 8, 2013

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 questions

Disable same origin policy in Chrome

Is there any way to disable the Same-origin policy on Google's Chrome browser?

Read More
jQuery AJAX submit form

I have a form with name orderproductForm and an undefined number of inputs. I want to do some kind of jQuery.get or ajax or anything like that that would call a page through Ajax, and send along all the …

Read More
How do I return the response from an asynchronous call?

I have a function foo which makes an asynchronous request. How can I return the response/result from foo? I tried returning the value from the callback, as well as assigning the result to a local variable inside the function …

Read More