Skip to main content
Question

Reading files from Sharepoint into FME Flow


scarter
Contributor
Forum|alt.badge.img+9

Hello Forum,.

 

I would like to connect to files stored in SharePoint. This is a redacted example of one of the URLs….

 

I’ve seen the ‘SharePointOnlineConnector’ transformer from https://support.safe.com/hc/en-us/articles/25407532347661-Reading-and-Writing-SharePoint-Libraries-with-FME. However that only works on build FME Build 24577 or higher. We’re on build 23619 - note that we are planning to upgrade in Summer 2025, but that’s a while off.

 

Is there a way of reading from SharePoint without the SharePointOnlineConnector transformer? I see I can select Microsoft SharePoint List as a reader format in FeatureReader. However when I enter the URL (the un-redacted one in the image above) I’m then asked what features to read. When I then select the ellipsis I get this error

 

 

Am I misunderstanding how the reader works? Do I need to present the reader with a different set of information per file in SharePoint? Is there another way of doing this?

 

Thanks,

Stuart

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+53
  • Celebrity
  • April 10, 2025

Without the sharepoint connector, your best bet is going to be to interact directly with the Sharepoint REST API - https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest#working-with-files-by-using-rest

The Lists transformer won’t allow you to interact with files, it only supports Sharepoint Lists


scarter
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • April 11, 2025

Thanks for that, ​@hkingsbury 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings