Sharepoint List Data connection

KNIME Analytics Platform
1

Hi,

 

I am very confused as to how to get a SharePoint list data into Knime.  Essentially what does the workflow look like to output SharePoint list items as a table in Knime?

 

And Step 2 would be how can I modify or wite back a table in Knime to a SharePoint list?

2

I have had some success in using the GET Request node and using the url in the format

http://{0}/_vti_bin/owssvr.dll?Cmd=Display&List={1}&XMLDATA=TRUE
  • {0} – The URL to your site.  This could be the root web or a child site.
  • {1} – The GUID for your list. 

More details on the above format here https://blogs.msdn.microsoft.com/kaevans/2009/05/01/getting-xml-data-from-a-sharepoint-list-the-easy-way/

but now the part I have difficulty with is using the XPath node after.  In this node I am not sure how to define columns.

 

And Step 2 remains unresolved.  Step 2 would be how can I modify or wite back a table in Knime to a SharePoint list?

3

Hey famajeed,

Unfortunately, I cannot help you with SharePoint, but I might be able to give you some pointers for the XPath node.

To extract elements to columns you need to double-click on the respective tag in the preview of your XML. Then click on "Add XPath". Alternatively you can just click Add XPath and enter the path yourself. To find out more about XPath you can look at https://www.w3schools.com/xml/xml_xpath.asp.

Attached you will find a very basic workflow that shows an example on how to use the XPath node in KNIME Analytics Platform.

Hope I could help you a little.

Cheers,
Ferry