search

michie1 / bc

Script that reads all orders of a topic from wtos.nl, puts everything in the cart of bike-components.de and generates a Google spreadsheet with Python, lxml, Google API, Docker
5 stars 5 forks source link

Update Google Spreadsheet API to new version #9

Closed michie1 closed 4 years ago

michie1 commented 5 years ago 
We're writing to let you know that Google Sheets v3 API will be shut down on March 3, 2020.
What do I need to know?

The Sheets v4 API, launched in 2016, opened new doors to custom development with programmatic access to critical features like conditional formatting, charts and pivot tables. Since then, we’ve continually improved version 4 by supporting new Sheets features and introducing developer metadata.

As part of the migration to the Sheets v4 API, we will shut down the Sheets v3 API on March 3, 2020.
What do I need to do?

To ensure projects originally built on the Sheets v3 API continue working long after it is gone, please migrate your projects (listed below) to the Sheets v4 API before March 3, 2020.

    You can review this migration guide which provides tips on how to transition your apps, including a mapping of operations in Sheets v3 API to operations in Sheets v4 API and some ideas for using the new functionality to your advantage.

https://developers.google.com/sheets/api/guides/migration

Axel-Koper commented 5 years ago

Zal eens kijken of ik hiermee kan helpen

bcvanmeurs commented 4 years ago

gspread can use the API v4, says the documentation. Apparently gspread started to use the API v4 in version 2.0.0 and dropped support for v3 in version 3.0.0. We are using version 0.6.2. So maybe it is a matter of updating to gspread > 2.0.0 and test it? https://github.com/burnash/gspread/blob/master/HISTORY.rst