Import Google Spreadsheet to JS Object

by Sergio Spagnuolo

HTML

<ul id="superDump"></ul>

<script src="https://spreadsheets.google.com/feeds/list/12TIuxaVN-_nAE6ZrX2lveuIDdx9Xr4zKddV9KAJqAxY/ola2m5e/public/values?alt=json-in-script&callback=passaralhos"></script>

JavaScript

function foodItem(veiculo, mes, midia) {
  this.veiculo = veiculo;
  this.mes = mes;
  this.midia = midia;
  this.toxicity;
  this.links;

  //this.getInfo = function() {
  //   return this.veiculo; // + ': ' + this.desc;
  //  }

  this.buildListItem = function() {
    return "<li><b>" + this.veiculo + "</b> [" + this.mes + "] - - - " + this.midia;
  }
}

var foodList = new Array();

function passaralhos(json) {
  //console.log(json.feed.entry);
  //console.log("COUNT: " + json.feed.entry.length);
  for (var i = 0; i < json.feed.entry.length; i++) {
    entry = json.feed.entry[i];
    var newItem = new foodItem(entry.gsx$veiculo.$t, entry.gsx$mes.$t, entry.gsx$midia.$t);
    foodList.push(newItem);
  }
  //console.log(foodList.length);
  dumpFood();
}

function dumpFood() {
  for (var j = 0; j < foodList.length; j++) {
    $('#superDump').append(foodList[j].buildListItem());
  }
}