Sharepoint REST POST PUT

KNIME Extensions
1

Hi , I have been working on a workflow that uses the KNIME REST extensions to access a SharePoint List … I have no issue with Connecting via the GET node to download a list in xml format for further processing, however, I cannot seem to any examples of using the POST node (to create a new list ) or the PUT node (to create or update a list). Any help on this would be very much appreciated.

2

Hi @werewulf,

You can use https://hub.knime.com to search for nodes and also workflows in which they are contained. We do have two example workflows for the POST Request node: https://kni.me/n/jDedZ_onUp4c833B.

Best,
Stefan

1 Like
3

Great Stefan… thanks for the advice, I will have a look at nodepit
regards

4

Hi @werewulf,
May I ask how you configured your GET node to download a SharePoint list? I’ve been struggling to do the same and can’t seem to figure it out. Thank you!

5

Hi, sbrasfield , apologies for the delay in replying…

  1. SP URLs are created in the following way:

Anatomy of a SP List URL:
https://companyname.sharepoint.com/sites/site-name/Lists/list-name/AllItems.aspx**

My list configuration:
https://companyname.sharepoint.com/sites/my-site-name/_api/web/lists/getbytitle(‘my_list_name’)/items?&$top=5000

  1. Place URL in the URL field
  2. Tick SSL
  3. Tick Trust all certificates
  4. Tick Follow redirects

Leave everything else unticked and other tabs at default
This should work for you

Regards

4 Likes
6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.