Sharepoint REST POST PUT

#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.

0 Likes

GET Sharepoint list
#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

0 Likes

#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!

0 Likes

#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

2 Likes

GET Request - Timeout , where the same Url submitted through YARC (Chrome Plugin) works