Getting data from Google spreadsheet

Having this spreadsheet from Google: https://docs.google.com/spreadshee…

This is what I did to show the quote daily:

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js"> </script>
<div id="result">loading</div>
<script>
var today = new Date();
var aday = today.getDate();
var amonth = today.getMonth();
var sq = "amonth=" + amonth + " and aday=" + aday;

var url = "https://spreadsheets.google.com/feeds/list/0AjgIgMIuXFo2dF9fQnUybkFLeE5ybHE0bVJ4Z3F0Unc/od6/public/values?alt=json";
$.getJSON(url, {
"sq": sq
}, function (data) {
$("#result").html(data.feed.entry[0]["gsx$atext"]["$t"]);
});
</script>

 

Leave a Reply