search

HandsOnDataViz / leaflet-maps-with-google-sheets

Customize Leaflet maps with a linked Google Sheets template and GeoJSON data on GitHub
https://handsondataviz.github.io/leaflet-maps-with-google-sheets/
MIT License
143 stars 585 forks source link

Map no longer loads on template or on our servers #126

Open charlaburnett opened 3 years ago

charlaburnett commented 3 years ago

I'm trying to figure it out now because the leaflet code library hasn't changed. It has to be something else. If you could help advise, thank you.

ilyankou commented 3 years ago

Could you share a link to your map please @charlaburnett ?

mmarder commented 3 years ago

I ran into a similar issue. Looks like the API for retrieving JSON from Google Spreadsheets has been turned down and has been replaced by a new v4 (https://cloud.google.com/blog/products/g-suite/migrate-your-apps-use-latest-sheets-api / https://developers.google.com/sheets/api/guides/migration#v4-api_2).

charlaburnett commented 3 years ago

Hello Michael and Ilya,

Sorry about my late reply. Our intern was supposed to follow up. I was able to make the updates to the API. The other issue we ran into is that Google Sheets no longer processes query or array functions as data. We use google forms to create a participatory mapping environment. We had to write a script for google sheets to pull from a forms worksheet and add the results.

Thanks for the support!

On Tue, Aug 31, 2021 at 2:20 PM Michael @.***> wrote:

I ran into a similar issue. Looks like the API for retrieving JSON from Google Spreadsheets has been turned down and has been replaced by a new v4 ( https://cloud.google.com/blog/products/g-suite/migrate-your-apps-use-latest-sheets-api / https://developers.google.com/sheets/api/guides/migration#v4-api_2).

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/HandsOnDataViz/leaflet-maps-with-google-sheets/issues/126#issuecomment-909485737, or unsubscribe https://github.com/notifications/unsubscribe-auth/AKMSMXUPMUXOXHIMMECKXETT7UMNZANCNFSM5CTIOSWA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

--

ilyankou commented 3 years ago

Hi @mmarder and @charlaburnett

We did anticipate this and wrote a guide to transition to API v4 (scroll down the README to see), and it is now the standard instructions on HandsOnDataViz. I believe you encountered the issue because you forked the project a while ago before Google made the announcement of the changes.

Glad you were able to fix it, @charlaburnett!