Hi guys,
I am trying to connect to API through G App Script and I am having some problems and getting the following log message: {error=Invalid Authorization, type=ch:service}. Please see the code below:
function myFunction() {
var id = “1298GArBDveRacbw9koz8eluBsZUrACuNNj9_E2U4Ah0”;
var ss = SpreadsheetApp.openById(id);
var sheet = ss.getSheetByName(“Sheet1”);
var my_api_key = sheet.getRange(1,2,1,1).getValue();
Logger.log(my_api_key);
var headers = {
“Authorization”: “Basic” + Utilities.base64Encode(my_api_key+":"),
}
var params = {
“method”:“GET”,
“headers”:headers,
muteHttpExceptions: true,
};
var url = “https://api.companieshouse.gov.uk/company/00000006”;
var response = JSON.parse(UrlFetchApp.fetch(url, params).getContentText());
Logger.log(response);
}
Any ideas ?
Thank you,
Emanuel