Connecting to Share point

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