I have a service that creates a jSon response in Google Apps Script
function doGet(e) {
return ContentService
.createTextOutput(mcpher.getRestLibrary().serialize())
.setMimeType(ContentService.MimeType.JSON);
}
This can be found at mcpher.com
When i run it at the browser, or the firefox RESTclient it gives a correct response. However when I use httpGET from within VBA, or as in the example below in Google Apps Script
function restTest() {
var x = UrlFetchApp.fetch("http://script.google.com/a/macros/mcpher.com/s/AKfycbzLqpnQ2ey8CKAMmzchb2n2FU-aiae0iTKPzAOfAgEpxGwaJgk/exec");
mcpher.DebugPrint(x);
}
I get this response .. like a request to login
{"0":"\n<html dir=\"ltr\" >\n<head>\n <meta name=\"robots\" content=\"noindex,nofollow\" />\n <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\n <title>mcpher.com</title>\n <script type=\"text/javascript\">\n <!--\n // Keep login page from being trapped in iframes.\n ... etc...
The script is set to anybody can access. Do I somehow have to authenticate - even though I'm running it from the same browser session ?
It needs to be set to anyone can access, including anonymous. Are you sure that's the setting?