I’m fairly new to Knime and I apologize if this question was asked before, but I couldn’t find an answer.
I’m looking to read a CSV or XLS files stored on Google Drive.
I would like to access the files via a URL since the workflow could be run by different machines.
I am assuming that an authentication process will be required since the files are not public.
What would be the best method to access these files? Would a REST service using Google API work?
did you give our google sheet integration a try?
In theory it is constructed to directly read the google sheet files, but maybe this works for csv as well.
You can find an example how to use it from @ScottF here
Thanks armingrudd for your suggestion.I would preferred a solution that doesn’t require permanent storage. Would there be a solution where Knime would read the CSV with a URL and temporarily store in the local machine?
Ideally, I’d like Knime to simply read the files each time we run the flow. I am trying to figure out how to configure the authentication part though.