Skip to main content
Solved

Has anyone successfully used the SharepointOnlineConnector to read files directly? Or know why all Sites are not showing when browsing?

  • April 14, 2021
  • 3 replies
  • 82 views
brian_
Contributor
Forum|alt.badge.img+4

Hi FME community

I have successfully added a web connection to my Sharepoint site following this tutorial https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection using the Client ID multitenant method.

Then when I browse the Site: parameter (image below) only a subset of all sites in my organisation are showing.

Capture My goal is to read files hosted in Sharepoint just as if they are sitting on my hard drive. Anyone have any suggestions on my issue above or know of an alternative way to connect to Sharepoint?

Thanks

Best answer by owen

Ive got the same issue, but found out that if you enter the url formatted with the site ID, rather than browsing it works. For example yourcompany.sharepoint.com,siteid

 

You can find the site id by appending this to the end of the URL

 

/_api/site/id

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+61

No solution, only a similar experience.

I recently got this working with the SharePointOnlineConnector from the hub and came to the same conclusion. (only a subset of the sites were showing) Also, when I created a new shared library I could not find it in the (quite long) list. When I tried again the next day it appeared in the list. I'm not sure what changed. The only thing I did after the first try was create a folder in the Documents section and add a file to it. I also shared the (private) site with some colleagues.

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...
owen
Forum|alt.badge.img+1
  • owen
  • Best Answer
  • December 13, 2021

Ive got the same issue, but found out that if you enter the url formatted with the site ID, rather than browsing it works. For example yourcompany.sharepoint.com,siteid

 

You can find the site id by appending this to the end of the URL

 

/_api/site/id

nielsgerrits
VIP
Forum|alt.badge.img+61

Ive got the same issue, but found out that if you enter the url formatted with the site ID, rather than browsing it works. For example yourcompany.sharepoint.com,siteid

 

You can find the site id by appending this to the end of the URL

 

/_api/site/id

Thanks @owen​ this works great!

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...

Community Stats

32,129
Posts
121,967
Replies
39,779
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.