Before the update I used the https://spreadsheets.google.com/feeds/list/{SHEETID}/1/public/values?alt=json link to get the values from the spreadsheet and display it in an html page
$(document).ready(function() {
var sheetURL ="https://spreadsheets.google.com/feeds/list/{SHEETID}/1/public/values?alt=json";
$.getJSON(sheetURL, function(data) {
var entryData = data.feed.entry;
console.log(data);
jQuery.each(entryData, function() {
$("#list").append(
' <div class="contentList">'+ this.gsx$list.$t +'</div>'
);
});
});
});
After upgrading to API v4 the link stopped working. someone with the same problem? I tried to solve it through the documentation, but I didn't get a solution.