CODEWITHSUNDEEP
google-apps-scriptweb-applications
elena
elena

Reputation: 4198

Google Apps Script returns Sorry, unable to open the file at this time. Please check the address and try again

I am trying to POST a request to a simple app script. Here's the code:

var BACKEND_URL = "https://script.google.com/macros/s/AKfycbyYAWMv6O8Xld1EvqPuBk9EgxgfpVNly3dyX3JkSc3h/dev";
data = {"obj1": "data1", "obj2": "data2"};
function doGet() {
  var resp = UrlFetchApp.fetch(BACKEND_URL, {
    'method': 'post',
    'contentType': 'application/json',
    'payload': JSON.stringify(data),
    'muteHttpExceptions': true
  });
  Logger.log(resp);
}

And here's the code for the server which should accept POST requests:

function doGet() {
}

function doPost(e) {
  Logger.log("posted");
  return;
}

NOTE: there's no user part in the URL, so this question isn't the same as a similar one posted in SO.

As a response a get an html page where it's said that sorry, Sorry, unable to open the file at this time. Please check the address and try again.

I've re-checked the page and it does exist.

Upvotes: 1

Views: 8461

Answers (1)

Tanaike
Tanaike

Reputation: 201613

In your case, the project with doGet() including UrlFetchApp.fetch() is the different from the project with doPost(e). And you want to call doPost() by running doGet() including UrlFetchApp.fetch(). If my understanding your situation is correct, can you confirm the following points.

  • BACKEND_URL you are using includes dev. This is used for using the latest code. But there is a limitation as follows. So please try to use Current web app URL like https://script.google.com/macros/s/#####/exec.

    The second is the link labeled latest code and ends in /dev. This URL can only be accessed by users who have edit access to the script. This instance of the app always runs the most recently saved code — not necessarily a formal version — and is intended for quick testing during development.

  • At Web Apps, when there are no return messages, the error message of The script completed but did not return anything. is returned. If you want to get the return message, please set it using Content Service.

  • When the script at Web Apps side was modified, please redeploy the Web Apps as a new version. By this, the latest script is reflected to Web Apps.

References :

Edit :

When you deploy Web Apps, please try the following settings.

  • "Me" for "Execute the app as:"
  • "Anyone, even anonymous" for "Who has access to the app:"

Upvotes: 4

Related Questions