Connecting to Share point

KNIME Analytics Platform
1

Hi,

Currently I have a Knime flow that reads 30+ files from a folder and spits out an output into a tableau dashboard.

The excel files stored in the share drive are being copy and pasted from share point. I would like Knime to be able to read the files in the share point site directly as the current process is too manual to be doing every 2 weeks.

I am looking for some help/guidance on how access excel files stored in an online share point site.

I have watched a couple youtube videos which touch on reading data into share point but nothing that helpful. I have also searched the community forums and looked at 3/4 posts that were about issues after getting a flow set up

I think what would help me would be to know:

  • what components are needed in the flow
  • see a basic example flow
  • understand what permissions/access is needed from me to be able to run this flow (I assume I will need to have convos with IT security to get this to work)

Many thanks,
Fin

2

Hi Fin

Use the SharePoint connector:

Be aware that you have to login each time, if you are using user / password. This has to be done manually (Config / F6) with the button on the bottom of the node, which opens a new browser tab.

The output provides you a filesystem type port. Meaning the next node needs to be able to use this as input. Take the “List Files/Folders” node with right click → “add File System Connection port”. Execute this node, check the result. You now have a table with the files of the folder you’ve pointed to and can proceed them, e.g. in the Excel reader within a chunk loop or row to variable loop.

1 Like