How to Pass Variables for Multiple SharePoint Site URLs in KNIME SharePoint Online Connector?

KNIME Analytics Platform
,
1

I want to read multiple files from multiple SharePoint sites using the Table Row to Variable Loop Start node. I plan to store the SharePoint site URLs in an Excel file or use the Table Creator node, and then pass these URLs into the SharePoint Online Connector. However, I am unable to pass the variable (which contains the SharePoint site link) into the SharePoint Online Connector node under the “Web URL” option, as it seems the node does not support variables.

Can anyone assist with this issue, or suggest a better way to achieve this functionality?

2

Hey @Vinay1995,

If you successfully authenticated yourself the connector node should accept flow variables. If you just drop the node into KNIME the flow variables are disabled.
Does this help ?
All the best
Linus

2 Likes