Google Spreadsheet API v3 Deprecation

[daemon1024]

For spreadsheet based layers and utility, we are dependent on APIv3 of Google. Which has now been deprecated as noted in https://cloud.google.com/blog/products/g-suite/migrate-your-apps-use-latest-sheets-api. It seems the deadline was August 2nd, and since we have already crossed it, our layers are broken rn, specifically pfasLayer

Here's the migration guide https://developers.google.com/sheets/api/guides/migration

TODO

• Migrate pfasLayer
• Update spreadsheetlayer utility function

[daemon1024]

https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get has the browser code for making the API call.
It seems like it's important to initiate and authorize client before making requests now.

[daemon1024]

Noting a few important changes:

• You need an API key irrespective of the visibility of the spreadsheet
• The spreadsheet needs to be viewable by anyone with link, instead of published

[daemon1024]

bpk68/g-sheets-api#97 (comment) has highlighted and explained things in a great way 🙌🏽

[jywarren]

Ah! There may be a way to get just CSV (via bpk68/g-sheets-api#97):

Another option is to use the Publish to Web option and select CSV.
This doesn't require a key:
https://docs.google.com/spreadsheets/d/e/2PACX-1vTkCHOZXGAAoL4mMNQLUKfOKzLHCcf9XhdvQhV_cXOwgFWTWw4M-_L9SdkPJlNvYHwVvy4D_xqS5na9/pub?output=csv

We could parse that, it wouldn't be too hard!

We'd have to link people to this page to show how to Publish to Web: https://support.google.com/docs/answer/183965?hl=en&co=GENIE.Platform%3DDesktop and include a screenshot in the docs.

[jywarren]

Maybe using this? https://csv.js.org/parse/

[daemon1024]

Ohh, I used the CSV to make a copy, but it didn't cross my mind that we can use it in the code too 😅 Looking into it, thank you.

[daemon1024]

https://github.com/fureweb-com/public-google-sheets-parser Found this npm package, seems like it's returning the data in a very nice way. Tried it out at https://api.fureweb.com/#/spreadsheets/spreadsheetId

[jywarren]

Noting also that the FracTracker layer uses a spreadsheet and is also failing: #668

[julianavmgiusti]

@jywarren and @TildaDares I'm looking foward to work on my contributions. Just looking for a second issue to solve. I found this one and wondering can I claim this issue?

[jywarren]

Hi @julianavmgiusti I appreciate it -- it's probably a pretty complex issue, but if you'd like to try using https://github.com/fureweb-com/public-google-sheets-parser, we would love your help! Thank you!

[julianavmgiusti]

Hi @jywarren ok I'm outreachy applicant, so the project that is on the program is Improve MapKnitter Lite for mapmaking with aerial photos as a lightweight web service and I just found one, I metioned you on comment, can you help me to contribute to this project?