exotel_dnd_checker_google_sheets_script

function checkDND(phone) {
  var phoneToBeChecked = phone;
  if(phone == undefined) {
    phoneToBeChecked = '8956613425';
  }

  var options = {};
  var username = 'gigindia';
  var password = '161d76260392034b7864965889a3611b67aaea90';
  options.headers = {"Authorization": "Basic " + Utilities.base64Encode(username + ":" + password)};
  var url = 'https://api.exotel.com/v1/Accounts/gigindia/Numbers/' + phoneToBeChecked + '.json';
  var xml = UrlFetchApp.fetch(url, options).getContentText();


  var data = JSON.parse(xml);
  Logger.log(data.Numbers.DND)
  return data.Numbers.DND;
}