Google Spreadsheet custom function to get the full ip report from Auth0 Signals/Apility

Code.gs

function SIGNALSFULLIP(input) {
  var response = UrlFetchApp.fetch("https://signals.api.auth0.com/ip/" + input + "?token=YOUR_API_TOKEN");
  // Parse the JSON reply
  var json = response.getContentText();
  var data = JSON.parse(json);
  var score = data['fullip']['score'];
  var blacklists = data['fullip']['badip']['blacklists'].join(',');
  var as = data['fullip']['geo']['as']['name'];
  var asnum = data['fullip']['geo']['as']['asn'];
  var country = data['fullip']['geo']['country'];
  var history_score = data['fullip']['history']['score'];
  array = [];
  array.push(score);
  array.push(blacklists);
  array.push(country);
  array.push('AS' + asnum + ' - ' + as);
  array.push(history_score);
  Logger.log(score);
  Logger.log(blacklists);
  Logger.log(country);
  Logger.log('AS' + asnum + ' - ' + as);
  Logger.log(history_score);
  return [array];
}