Thank you Marco, your solution worked!
I'm using the Get resource node to pull all the items from a Sharepoint list.
The following node configuration works fine:
url: http://site url/_api/web/lists/GetByTitle(‘Test')/items
method: GET
headers:
accept: "application/atom+xml"
If anybody is interested, you can see details of Sharepoint rest API here:
https://msdn.microsoft.com/en-us/library/office/dn292552.aspx#RetrieveLists
Finding this solution has triggered other thoughts, like using the POST node to add an item to a Sharepoint list.
This is still something I'm unable to do: the POST request would require two headers that are not included in the node
- content-length
- X-RequestDigest
I assume this is due to the inability to customise the headers in the node; this post in the community contributions is also mentioning this problem, which appears to be unresolved
https://tech.knime.org/forum/krest-nodes/krest-no-more
Are you aware of any workaround? E.g.: using the java snippet instead?
Thank you again for your great support.