function FetchBlizzApi() {
  var response = UrlFetchApp.fetch("https://eu.api.battle.net/wow/auction/data/C'Thun?locale=en_GB&apikey=ak5jhhr88e4z7zgdmrwyuhff9xjfbd96");
  var apiString = response.getContentText().match("http.+json");
  var date = new Date(response.getContentText().match("[0-9]{10,15}")*1);
  var response2 = UrlFetchApp.fetch(apiString);
  var object = Utilities.jsonParse(response2.getContentText());

  var ssheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Precios");

  if (ssheet.getMaxColumns() > 3) {
    ssheet.deleteColumns(3,ssheet.getMaxColumns()-3);
  }
  if (ssheet.getMaxRows() > 10000) {
    ssheet.deleteRows(2,ssheet.getMaxRows()/3-2);
    ssheet.deleteRows(2,ssheet.getMaxRows()/2-2);
    ssheet.deleteRows(2,ssheet.getMaxRows()/2-2);
  }
  if (ssheet.getMaxRows() > 4) {
    ssheet.deleteRows(2,ssheet.getMaxRows()-2);
  }
  ssheet.clear();
  i = 2;

  ssheet.getRange(1,1,1,3).setValues([["Item","Buyout","Quantity"]]);


  //for (var side in object) {
   //if (side == "horde") {
      for (var auc in object/*[side]*/) {
        for (var item in object/*[side]*/[auc]) {
          ssheet.getRange(i ,1).setValue(object/*[side]*/[auc][item].item);
          ssheet.getRange(i ,2).setValue(object/*[side]*/[auc][item].buyout);
          ssheet.getRange(i ,3).setValue(object/*[side]*/[auc][item].quantity);
          i++;
        }
      }
    //}
  //}
  Browser.msgBox("Fetched " + i + " auctions for date " + date);
}