Skip to main content
Question

Is it possible to truncate a sharepoint list within FME before writing into it?

  • September 12, 2023
  • 1 reply
  • 15 views
edward_skanska
Contributor
Forum|alt.badge.img+2

Hi there

 

Just as the title says. I know how to do this with a shapefile within the writer but I cant see the same options within the sharepoint list writer

 

Thanks in advance

-Ed

1 reply

j.botterill
Influencer
Forum|alt.badge.img+55
  • j.botterillInfluencer
  • Influencer
  • September 12, 2023

Hi Edward,

I think you may need to flag the format attribute fme_db_operation with INSERT or UPDATE values.

In this article, they show how ChangeDetector can be utilised to compare original vs revised data streams

FME Community (safe.com)changeDetectorThe list general parameters would like this sp_list_writer_feature_operation

Community Stats

32,207
Posts
122,305
Replies
39,891
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.