Config Sharepoint Online connector

KNIME Analytics Platform
#1

Hi everybody,

I’m trying to configure this node without success.

I can successfully logon into my organization via Microsoft Authentication node:

image

In the SharePoint Online connector I fill the URL with the group Sharepoint and in the Working Directory my personal folder:

image
image681×565 21.1 KB

Until this point everything seems fine but then in the Excel Reader, the file can’t be read:

image
image981×879 32.2 KB

This is the file path (it can be opened in a browser):

/https://bayergroup-my.sharepoint.com/:x:/g/personal/roberto_mulesantagati_bayer_com/EYOGQa2ehSZMuP1lQ5m5UVUB6X_OWyYFe5LsxGNpAu9ZZQ?email=roberto.mulesantagati%40bayer.com&e=dXTsMC

What is wrong?

Thanks!

Roberto

1 Like
#2

Hi @bermq,

i think the / at the beginning of your working dir link looks strange. Does it work when you remove it?

So:
https://bayergroup-my.sharepoint.com/:x:/g/personal/roberto_mulesantagati_bayer_com/EYOGQa2ehSZMuP1lQ5m5UVUB6X_OWyYFe5LsxGNpAu9ZZQ?email=roberto.mulesantagati%40bayer.com&e=dXTsMC

instead of
/https://bayergroup-my.sharepoint.com/:x:/g/personal/roberto_mulesantagati_bayer_com/EYOGQa2ehSZMuP1lQ5m5UVUB6X_OWyYFe5LsxGNpAu9ZZQ?email=roberto.mulesantagati%40bayer.com&e=dXTsMC

also not sure if you need the whole link… maybe you could try the sharepoint folder link e.g. site/yourSPSite/shared documents/…
At least that would be the dir structure I would expect :thinking:
Could you maybe try

  :x:/g/person/roberto_mulesantagati_bayer_com

or

 /:x:/g/person/roberto_mulesantagati_bayer_com

followed by an list files node - and see if it works on that folder?

#3

Hi!

Yes, the / at the begin is a typo, and yes, without it works in a browser.

I have followed your suggestion:

image
image646×546 20.6 KB

But I have still this error:

image
image983×190 9.35 KB

#4

Hi @bermq,

if you replace the Excel Reader node with a list files node which also points to

/:x:/g/person/roberto_mulesantagati_bayer_com

what error do you get?

#5

It says it doesn’t exist:

image
image936×352 47.9 KB

#6

Hi @bermq,

could you show me how the path is displayed in sharepoint itself?

E.g. if I want select the following example file from my SharePoint:
SharePoint name = BFM_Test
In the path Dokumente/General/New
(the default folder shared documents is just autotranslated in sharepoint)

grafik

I would use the following path in the list files node:
/BFM_Test/Shared Documents/General/New

or in the Excel Reader Node:
/BFM_Test/Shared Documents/General/New/Example.xlsx

Path syntax: Paths for SharePoint are specified with a UNIX-like syntax, /mylibrary/myfolder/myfile. An absolute for SharePoint consists of:

  1. A leading slash ("/").
  2. Followed by the name of a document library (“mylibrary” in the above example), followed by a slash.
  3. Followed by the path to the file (“myfolder/myfile” in the above example).

->what do you see in your sharepoint if you navigate to the folder where I see:
grafik

*cannot check how I did it with the KNIME node at the moment but I think that was the path that I used (hope it helps anyways) :see_no_evil:

If the above still does not work try the root path as explained in the description:

  The default working directory is the virtual root "/", under which all the document libraries are located.
3 Likes
#7

Thank you so much, I was referring to the file link but I had to look at the SharePoint path itself.

4 Likes
#8

great that it worked! :slight_smile:

3 Likes
#9

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