GW2 Spidy API

function GetItemSellValue(itemID) {
  var myUrl = "http://www.gw2spidy.com/api/v0.9/json/item/" + escape(itemID);
  var jsonData = UrlFetchApp.fetch(myUrl);
  var jsonString = jsonData.getContentText();
  var jsonObject = JSON.parse(jsonString).result;
  var adjustedValue = (jsonObject.min_sale_unit_price / 100);
  return adjustedValue;
}


  function GetItemBuyValue(itemID) {
  var myUrl = "http://www.gw2spidy.com/api/v0.9/json/item/" + escape(itemID);
  var jsonData = UrlFetchApp.fetch(myUrl);
  var jsonString = jsonData.getContentText();
  var jsonObject = JSON.parse(jsonString).result;
  var adjustedValue = (jsonObject.max_offer_unit_price / 100);
  return adjustedValue;
}