We upgraded to 4.5.1. Knime Analytics platform on server and individual desktop envrionments.
In 4.2.2 platform, We had some google nodes to connect to Google Drive ( Shared Drives ), get data from EDW, format and then update the google sheet one or more tabs.
Now with 4.5.1, the drive connectivity is upside down, changed horribly, only see drive content of the person who is authenticated which is good, but if the person and we all belong to a team and we have “Team Shared Drive”, which everyone can see… which is where we want to create/share our reports, now we can’t see them.
Even with using the “STAR” process, we can’t see the file in the list.
Listing can not be sorted so one has to painfully select a file from randomly sorted list… .ugggh.
Google Drive Authenticated and then Google Sheet Connector linked to Google Sheets Updated but the updater interface is such a disaster… that we have to wait for file list to appear …
Google Drive Connector has the ability to navigate to the particular share drive, but then we can’t connect to Google Sheet Connector.
Any one out there has any suggestions…
I need to update tabs in google sheets with raw data which are used in formatted output, which then gets turned into PDF using Google Script API.
It is failing misreably.