Failed to load resource from spreadsheets.google.com - Google jsonp persistent 404

[schlos]

Site is failing to load spreadsheet data: https://dev.codeforcroatia.org/PredizborniProgrami/

Console error:

Failed to load resource: the server responded with a status of 404 (), https://spreadsheets.google.com/feeds/worksheets/1wo_D2bJji_Sbq_tmuvOIlzbSst7Mbl5_TjoB769xVLI/public/basic?alt=json

lib.min.js:1 SyntaxError: Unexpected token < in JSON at position 0
    at JSON.parse (<anonymous>)
    at XMLHttpRequest.n.onload (lib.min.js:1)
n.onload @ lib.min.js:1

lib.min.js:1 Uncaught TypeError: Cannot read property 'feed' of undefined
    at loadSheets (lib.min.js:1)
    at XMLHttpRequest.n.onload (lib.min.js:1)

Code:

• https://github.com/codeforcroatia/PredizborniProgrami/blob/gh-pages/common/js/lib.min.js#L1
• source: https://github.com/codeforamerica/PoliceOpenDataCensus/blob/master/public/datasets/js/datasets.js (using Tabletop.js)

Related:

• https://forums.tumult.com/t/google-jsonp-intermittent-404/21046
• https://www.highcharts.com/forum/viewtopic.php?f=9&t=47123

[schlos]

This is related to deprecation of the v3 of the Google Sheets API in favor of the more robust v4. v3 technically reached EOL on August 2, 2021.

Source:

• https://www.highcharts.com/forum/viewtopic.php?f=9&t=47123
• Google sheets data import highcharts/highcharts#16210

[schlos]

Help wanted:

• develop a formal Pull Reqyest to address the changes required to support Sheets API v4.

[rodik]

tabletop.js is outdated:
jsoma/tabletop#199

solution:
https://github.com/frrrrank/Google-Sheet-Stuff

[schlos]

https://frankbueltge.de/en/google-sheets-as-database-or-tiny-cms/

Since tabletop.js is dead and not compatible with the current Google API v4 (2021) I had to look for a new solution or alternative to export data from Google Sheets via JSON and import it to a web page.
In this case the holy grail is Papa Parse. Additionally, I’m using isotope.js to add a fancy quick search and a “filter by category” option. For hipsters, I can even offer a solution in vue.js

[schlos]

Alternative:
https://jekyllrb.com/docs/datafiles/
https://jekyllrb.com/tutorials/csv-to-table/
https://jekyllrb.com/docs/step-by-step/06-data-files/
https://github.com/theyworkforyou/jekyll-csv
https://stackoverflow.com/questions/33370965/how-to-access-specific-row-from-csv-with-jekyll
https://github.com/avillafiorita/jekyll-csv_read
https://github.com/goinvo/Visual-Town-Budget

[schlos]

In this repo we have minimized js, but in the source repo you can see original js.

Datasets sheet/table handling: https://github.com/codeforamerica/PoliceOpenDataCensus/blob/master/public/datasets/js/datasets.js

Datatype sheet/table handling: https://github.com/codeforamerica/PoliceOpenDataCensus/blob/master/public/datatype/js/datatype.js

Grid table handling: https://github.com/codeforamerica/PoliceOpenDataCensus/blob/master/public/grid/js/grid.js