I have a workspace created inside a Sharepoint. It contains some workflows, which I run periodically.
In the past, only I ran the flows, so the path pointed to reading/writing Excel files (Excel Reader and Writer nodes), despite being in Sharepoint, are linked to my user.
For example: C:\Users\myuser\mycompany\PRA - Documents\Business Intelligence\01. Contracts\01. Databases\myfile - RDE.xlsx
Nowadays, another coworker will also run these flows, so I need to make the path above point directly to Sharepoint, making it more dynamic.
I got the reading through the nodes:
- Microsoft Authenti (using interactive authentication);
- Sharepoint Online Connector;
- Excel Reader.
I would like to know how I can pass the value of the authentication variable to all other flows in this workspace, so that a new authentication is not required when starting a new flow. (I understand that when closing and reopening KNIME this authentication becomes necessary, but without problems).
In addition, I would also like to know, as I was not able to when trying to use Excel Write, how do I write the data treated in Sharepoint as well.
Thanks a lot for the help.