Google Apps Script and External API Authorization Failing in Header

Question

Trying to get this to work. I keep getting a Missing ) after argument list. (line 6, file "Code")Dismiss. I've double checked my parenthesis, but no avail. Am I missing something?

I hope this is a reasonable question. Thank you.

function myFunction() {
  var url = "https://company.harvestapp.com/people";
  var headers = {
    "Accept": "application/xml",
    "Content-Type": "application/xml",
    "Authorization": "Basic " + Utilities.base64Encode(dude@dude.com +":"+pw)
     };
  var response = UrlFetchApp.fetch(url,headers);
  var text = response.getResponseCode();
  Logger.log(text);
}

score 5 · Accepted Answer · answered May 11 '13 at 06:03

5

Got it. Thanks to Brian, too. I finally realized that you need an "options" object where you pass the method and headers.

function myFunction() {
    var url = "https://swellpath.harvestapp.com/people/";
    var user = "dude@dude.com";
    var password = "supersecurepw";

    var headers = {
        "Accept": "application/xml",
        "Content-Type": "application/xml",
        "Authorization": "Basic "+ Utilities.base64Encode(user+":"+password)
    };

    var options = {
        "method" : "get",
        "headers" : headers 
    };

    var response = UrlFetchApp.fetch(url,options);

    Logger.log(response);
}

answered May 11 '13 at 06:03

Blexy

9,573
6
42
55

This was very helpful. Do you have any other code examples? It would be awesome to get something on https://github.com/harvesthq/api/wiki/Community-Creations-&-Hacks – chrowe Sep 23 '13 at 16:38
I have some documentation and code examples, but I never completed the project. – Blexy Sep 23 '13 at 16:51

ScampMichael · Answer 2 · 2013-04-16T01:32:11.600

0

EDITED:

Try:

   "Authorization": "Basic " + Utilities.base64Encode("dude@dude.com:"+pw)

edited Apr 16 '13 at 01:32

answered Apr 16 '13 at 01:09

ScampMichael

3,688
2
16
23

This is quite a short answer. – TheHippo Apr 16 '13 at 01:37

score 0 · Answer 3 · answered Apr 16 '13 at 03:02

There might be addtional errors, however your first problem is that you need to add the "headers" object to a "options" object and then do the following

    var url = "https://company.harvestapp.com/people";

    var headers = { "Accept": "application/xml",
                   "Content-Type": "application/xml",
                  "Authorization": "Basic " + Utilities.base64Encode(dude@dude.com +":"+pw)
                  };

      var options ={
                    "headers" : headers
                   };
       var response = UrlFetchApp.fetch(url,options);

Google Apps Script and External API Authorization Failing in Header

3 Answers3