Mini-Search Engine can't read Google Sheet. Have the urls changed?

I have a working mini-search engine that reads JSON from a Google Sheet. It was working last year. I think Google may have changed their API or URLs.

In line 544, there is a variable:

 $(function() {
   var GSHEET_JSON_URL 
  • Whatever variable I use, it will return: The specified GSHEET_JSON_URL does not contain JSON:’

Even using a dummy URL like

`https://www.jake.com`

will return the same message.

  • I think google have changed the URL structure.

I checked the original Codepen, from a different designer. It’s also returning the same error. Im guessing the change must come from the Google Sheets API.

The last URL I remember working is

https://spreadsheets.google.com/feeds/list/1WUzfGeyOMVVOb8tbYLqHTrAk7Ii2p6l58EXG-kcgOcY/1/public/values?alt=json’;

The console returns 404.

Im not sure where to go from here. I will continue looking at Googles Sheets API Docs.

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.