Map no longer loads on template or on our servers

[charlaburnett]

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]

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

[mmarder]

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]

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 <#126 (comment)>, 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]

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!