Skip to main content

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

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


Thanks for that, ​@hkingsbury