Skip to main content

Hello, 

I have a SharePoint List that I am already using. Can FME be used to update this list? What Transformer(s) would I use? 

At this stage, I am looking for general information to help me get started, so anything you can provide would be excellent. 

Hi ​@vxn43 I think your only choice here is the SharepointList Reader and SharepointList Wrtier. You can also define the format using the FeatureReader and FeatureWriter.

There is a SharpointOnlineConnector but for some reason it doesn’t recognize lists. Only Document Libraries. 

Another option is to define all the parameters using the HTTPCaller. Have you tried any of these options?

 


The recent Safe software webinar details all things Sharepoint.

NB. editing a Sharepoint list url requires web connection to Sharepoint API.

sharepointonline connector is more about dealing with document libraries. https://fme.safe.com/webinars/navigating-sharepoint-integration-from-seamless-configuration-to-workflow-automation-3/ or YouTube 

https://youtu.be/ye0NcZ7DrKQ?si=22lNxwCcQNw3iEGy

 

You will need to configure oauth 2.0 authorisation code AND have your IT register an app in Azure with delegated permissions to Sharepoint API