Googlesheets Client Code For Plumber Demo

code.js

/**
 * Call plumber API with id to return profile
 *
 * @param {number} id The customer id
 * @param {string} key API Key
 * @customfunction
*/

function getProfileFromPlumber(id, key) {
  
  var headers = {'Authorization': 'Key ' + key.toString()};
  var options = {'headers' : headers}
  
  var request_url = 'http://colorado.rstudio.com:3939/content/614/profile?id=' + id.toString()
  
  var r = UrlFetchApp.fetch(request_url, options)
  var txt = r.getContentText()
  Logger.log(txt)
  var j = txt.replace("[","").replace(/[\]]$/,'')
  Logger.log(j)
  var p = JSON.parse(j)
  Logger.log(p)
  var res = [p.name,p.gender, p.education,p.occupation, p.marital_status] 
  Logger.log(res)
  return   res
}


/**
 * Call plumber API with id adn age to return prob income >50 K
 *
 * @param {number} id The customer id
 * @param {number} age 
 * @param {string} key API Key
 * @customfunction
*/
function getProbAtAge(id, age, key) {
  
  
  var headers = {'Authorization': 'Key ' + key.toString()};
  var options = {'headers' : headers}
  
  var request_url = 'http://colorado.rstudio.com/rsc/content/614/income?id=' + id.toString() + '&age=' + age.toString()
  
  var response = UrlFetchApp.fetch(request_url, options)
  var prediction = response.getContentText()
  
  return prediction.replace("[","").replace("]", "")
}