I’m trying to automate a workflow that needs to fetch files from a SharePoint Online location. I do not have an API token, and I will not be able to ask the tenant IT to approve the KNIME application.
Power BI and Excel are both able to get SharePoint files using an interactive flow and without additional approval - and it’s also possible to access files through a web browser using interactive login.
Is there a way to do this same flow with KNIME to allow us to use it in cases where we don’t have API tokens and we can’t get the special KNIME application approved in our SharePoint Online tenant?
Hello @derek_alkalight,
As you mention it’s possible to access through a web browser, might I suggest if you could try out KNIME Web Interaction Extension?
Another suggestion would be to use the Python Script node and have it pass your credentials you currently use to download the files.
TL
1 Like
Thank you for the tip! I didn’t realize there was a node like this, and while it may not be as automatic as I hoped it may still be better than doing all of it manually in Python. I’ve been avoiding using Python because I don’t want to make users have a Python environment just to use this KNIME flow.
1 Like