FME Best / Standard practice - query sharepoint - upsert feature

​@benhanson 

Have you checked this article?

https://support.safe.com/hc/en-us/articles/25407427123597-Reading-and-Writing-SharePoint-Lists-with-FME

SRG

I have, though I saw it early in my exploration. I’ll give the Change Detector a deeper look.

You are right! ChangeDetector will help you to update selected records with the matching ids.

Happy FME:-) ing

Cheers

SRG

I’m still struggling to determine the best path forward with this. The ChangeDetector seems to work well. My workflow only attempts to update changed records. Unfortunately, the writer fails with an error: “ArcGIS Portal Feature Service Writer: UPSERT failed for feature service 'TestFeature': the feature service does not support Append, or has Sync/ChangeTracking enabled”

My writer only has the changed columns referenced. I don’t know if I have to have EVERY column in the destination mapped. If I do, then I’d need to do some sort of Join I presume.

If I switch to Insert, it us able to write data, but upsert functionality is what I’m looking for.

​@benhanson 

From my understanding the  Append capability is not currently supported if the ArcGIS Portal feature service has sync or changeTracking capabilities enabled.

Can you confirm that this is not the case for the “TestFeature” service?

SRG

GeoDB functionality has:

Unchecked: Versioning, Archiving, Replica Tracking, Attachments, Editor Tracking

Checked: Global IDs

Operations Allowed:

Checked Create, Query, Delete, Update

Unchecked: Sync, Extract