Category Archives: appscript

AppScript get file content protected by htaccess

At the moment I'm trying to download a csv from my AppSctipt program which is protected by htaccess. I looked at the UrlFetchApp class and tried to download it with:

var response = UrlFetchApp.fetch("https://name:[email protected]");
Logger.log(response.getContentText());

But this does not work. The response from the program is:

credentials in URL not supported (translated from German - maybe differ from original)

Do you have any ideas how I can do it in another way? Maybe I can set some headers or somethnig like that? If I open the url like I send it from the app all works great.

AppScript get file content protected by htaccess

At the moment I'm trying to download a csv from my AppSctipt program which is protected by htaccess. I looked at the UrlFetchApp class and tried to download it with:

var response = UrlFetchApp.fetch("https://name:[email protected]");
Logger.log(response.getContentText());

But this does not work. The response from the program is:

credentials in URL not supported (translated from German - maybe differ from original)

Do you have any ideas how I can do it in another way? Maybe I can set some headers or somethnig like that? If I open the url like I send it from the app all works great.