SHEET TO JSON

sheet to json

by George Obregon

HTML

<div id="demo"></div>
Row Data: <br/>

CSS

* {
    font-family: monospace;
}

JavaScript

var JSONURL = 'https://spreadsheets.google.com/feeds/list/1WNwg-NxKRliA6i3rj3iDiZxQIUBE7YxccD_e_55_QTU/2/public/basic?alt=json';

var JSONURL2 = 'https://spreadsheets.google.com/feeds/list/1WNwg-NxKRliA6i3rj3iDiZxQIUBE7YxccD_e_55_QTU/2/public/basic?alt=json';

function callback(data){
    var rows = [];
    var cells = data.feed.entry;
    
    for (var i = 0; i < cells.length; i++){
        var rowObj = {};
        rowObj.timestamp = cells[i].title.$t;
        var rowCols = cells[i].content.$t.split(',');
        for (var j = 0; j < rowCols.length; j++){
            var keyVal = rowCols[j].split(':');
            rowObj[keyVal[0].trim()] = keyVal[1].trim();
        }
        rows.push(rowObj);
    }
    
    var raw = document.createElement('p');
    var jayson = JSON.stringify(rows);
    raw.innerText = jayson;
    document.body.appendChild(raw);
   
   
   // Setup JSON for parsing
    var formulate = '{"slam":' +
jayson +
'}';

   // Parse JSON
	obj = JSON.parse(formulate);
	document.getElementById("demo").innerHTML =
	obj.slam[1].timestamp + ", please call " + obj.slam[1].phone;
}

$(document).ready(function(){
    
    $.ajax({
        url:JSONURL,
        success: function(data){
            callback(data);
        }
    });

});