Skip to main content
Solved

Update SharePoint List?


vxn43
Supporter
Forum|alt.badge.img+18

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. 

Best answer by j.botterill

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

 

 

View original
Did this help you find an answer to your question?

2 replies

crutledge
Enthusiast
Forum|alt.badge.img+29
  • Enthusiast
  • March 20, 2025

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?

 


j.botterill
Influencer
Forum|alt.badge.img+36
  • Influencer
  • Best Answer
  • March 24, 2025

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

 

 


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