function getItemName(itemID) {
  var myUrl = "https://api.guildwars2.com/v2/items/" + escape(itemID);
  var jsonData = UrlFetchApp.fetch(myUrl);
  var jsonString = jsonData.getContentText();
  return jsonObject;
}

function getItemSellValue(itemID) {
  var myUrl = "https://api.guildwars2.com/v2/commerce/listings/" + escape(itemID);
  var jsonData = UrlFetchApp.fetch(myUrl);
  var jsonString = jsonData.getContentText();
  var jsonObject = JSON.parse(jsonString);
  if (jsonObject.sells.length === 0) {
    return 0;
  }
  var adjustedValue = (jsonObject.sells[0].unit_price / 100);
  return adjustedValue;
}

function getItemMaxOffer(itemID) {
  var myUrl = "https://api.guildwars2.com/v2/commerce/listings/" + escape(itemID);
  var jsonData = UrlFetchApp.fetch(myUrl);
  var jsonString = jsonData.getContentText();
  var jsonObject = JSON.parse(jsonString);
  if (jsonObject.buys.length === 0) {
    return 0;
  }
  var adjustedValue = (jsonObject.buys[jsonObject.buys.length-1].unit_price / 100);
  return adjustedValue;
}

function formatAsGold(sellValue) {
  var n = sellValue;
  var s = "";
  if (sellValue < 0) {
    s = "-";
    n = Math.abs(n);
  }
  var gold = Math.floor(((n / 1000) % 100));
  var silver = Math.floor(((n / 100) % 100));
  var copper = Math.floor((n % 100)) + "c";
  if (gold == 0) {
    gold = "";
  } else {
    gold += "g ";
  }
  if (silver == 0) {
    silver = "";
  } else {
    silver += "s ";
  }
  return s+ gold + silver + copper;
}