javascript - Unexpected error on UrlFetchApp.fetch in Google Apps script - Stack Overflow

admin管理员组

文章数量:1415420

I'm trying to access the Pingdom API in Google Apps script following that example:

query = 'credits';
var username = 'foo';
var password = 'bar';
var credentials = username+':'+password;
var url = 'https://'+credentials+'@api.pingdom/api/2.0/'+encodeURIComponent(query);
var headers = {
  "App-Key": "abcd",
};
var options = {
    "method": "get",
    "headers": headers,
    'validateHttpsCertificates':false
};
Logger.log(url);
var response = UrlFetchApp.fetch(url);

The code execution breaks with the below error:

Unexpected error: https://foo:[email protected]/api/2.0/credits (line 17, file "Code") Dismiss

If I copy/paste the above URL into a browser it works (i.e. I'm getting a "Missing application key" from the pingdom API which confirms username and password where properly provided, otherwise you get an Invalid Credentials error). I tried with and without encodeURIComponent on credentials and I get the same error. 'muteHttpExceptions':true doesn't help either.

Any idea what could cause the error?

I'm trying to access the Pingdom API in Google Apps script following that example: https://developers.google./apps-script/external_apis

query = 'credits';
var username = 'foo';
var password = 'bar';
var credentials = username+':'+password;
var url = 'https://'+credentials+'@api.pingdom./api/2.0/'+encodeURIComponent(query);
var headers = {
  "App-Key": "abcd",
};
var options = {
    "method": "get",
    "headers": headers,
    'validateHttpsCertificates':false
};
Logger.log(url);
var response = UrlFetchApp.fetch(url);

The code execution breaks with the below error:

Unexpected error: https://foo:[email protected]/api/2.0/credits (line 17, file "Code") Dismiss

If I copy/paste the above URL into a browser it works (i.e. I'm getting a "Missing application key" from the pingdom API which confirms username and password where properly provided, otherwise you get an Invalid Credentials error). I tried with and without encodeURIComponent on credentials and I get the same error. 'muteHttpExceptions':true doesn't help either.

Any idea what could cause the error?

• javascript
• google-apps-script
• pingdom

Share Improve this question Follow edited Jun 4, 2013 at 22:26 Eric Koleda 12.7k11 gold badge3535 silver badges5252 bronze badges asked May 27, 2013 at 12:54 MaxMax 13.3k3232 gold badges9393 silver badges146146 bronze badges

Add a ment  | 

3 Answers 3

Sorted by: Reset to default 5

It appears that including login information in the URL is causing an error in UrlFetchApp. Please file a bug in our Issue Tracker. In the mean time, put the login information in the Authorization header and it should work correctly.

var response = UrlFetchApp.fetch(url, {
  headers: {
    'Authorization': 'Basic ' + Utilities.base64Encode(username + ':' + password)
  }
});

I encountered similar problems trying to access the Gitlab API in Google Apps Script. As mentioned in the accepted answer, including login information in the URL causes an error. The Basic Authorization method in the accepted answer did not work for me in Google Apps Script either. Modifying the authorization header to the 'Bearer' type did the trick.

var url = "https://gitlab./api/v4/projects/" + projectId;
var options = {
  'headers' : {Authorization: 'Bearer ' + token}
};
var response = UrlFetchApp.fetch(url, options);

Actually in my case was very simple:

  var response = UrlFetchApp.fetch(exportUrl, options);
  var blob = response.getBlob();

this was the error line:

Exception: Request failed for https://docs.google. returned code 500. Truncated server response: <meta name="viewport" c... (use muteHttpExceptions option to examine full response) cpOnePdfAndRep @ CP 1 PDF AND REP.gs:37

and it was simply because the sheets that the PDF file was exported from were hidden, just in case.

本文标签： javascriptUnexpected error on UrlFetchAppfetch in Google Apps scriptStack Overflow