Skip to main content
  • EN

I’m connecting a Sharepoint dataset to a portal dataset, with the intention of creating geospatial data in portal, each record having an object-id along with geometry. The Sharepoint record would be manually linked via this object-id, and then FME would sync changes of related columns.

My question is which transform (there are so many!) makes the most sense, and how can I limit the updates to only those records that have a matching object-id?

In my writer, the upsert action exposes a match column config, but the update action doesn’t. I feel like I’m missing something, as an update statement still needs something to match on.

​@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.

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

 

Reply


Community Stats

31,821
Posts
120,861
Replies
39,452
Members

Latest FME

Terms & ConditionsCookie settings
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.