Unexpected Error Google Apps Script Fetch

Question

I get an "Unexpected Error" from the following function:

function getBomgarFeedbackXML(){
  var url = "https://help.tradingtechnologies.com/api/reporting.ns?" + 
            "username=xxxxxx&password=xxxxxx&generate_report=SupportCustExitSurvey&" + 
            "start_date=2000-01-01&duration=0&report_type=rep&id=all";
  var response = UrlFetchApp.fetch(url).getContentText();
  Logger.log(response);
  return(Xml.parse(response, true));
}

The line that causes the error is:

var response = UrlFetchApp.fetch(url).getContentText();

I am able to fetch the URL programatically using other scripting languages, such as python
I have tried fetching the URL in my browser which I was able to do successfully
I can fetch "http://www.google.com" from Google apps script successfully
I get the following warning when navigating to the URL in chrome, could this be related to the issue ?

warning message

Any help is appreciated Thanks

Arun Nagarajan · Accepted Answer · 2012-11-22 15:34:35Z

2

The last bit with the untrusted certs is the big clue here. Seems like the SSL cert associated with 'help.tradingtechnologies.com'is not valid or signed by a trusted CA per the Google Data Centers (from where the UrlFetch calls originate).

To work around this try this line of code instead of your UrlFetch call. Note the additional option for validateHttpsCertificates documented here.

var response = UrlFetchApp.fetch(url, {'validateHttpsCertificates':false}).getContentText();

answered Nov 22, 2012 at 15:34

Arun Nagarajan

5,6651 gold badge24 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unexpected Error Google Apps Script Fetch

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related