I am using the “Google Spreadsheet Input/Output” plugin from the Pentaho Data Integration marketplace, which is no longer maintained. Github repository link. Recently I have received an email from Google with the subject:
[Action Required] Google Sheets v3 API is being shutdown on March 3, 2020
Can someone please have a look the source code and check if the plugin is using API v3 or v4. Not being a Java developer, I tried to find out myself, but looking at the code I don’t have a clue.
I also posted this question to the Hitachi Pentaho community forum. But instead of answering the question, they removed the plugin from the marketplace without any further comment.
Any help would be much appreciated.
Advertisement
Answer
I confirm that this plugin is the latest one (I am the author) : https://github.com/jfmonteil/Pentaho-Google-Sheet-Plugin It uses Google Drive API V3 for parsing and Google Sheets API V4. I have just upgraded the code to be up to date with the deprecated components.