I have a point feature class that I published with feature access enabled with Create, Update and Sync options.
The feature class has object ID, Global ID, Notification number, notification created date, due date, comments, work order. I enabled keep tracking on edits on the feature class. So it created Created date, created by, last edited date and edited by fields. The feature class is versioned as well.
One of the team that I work with uses applyEdits REST endpoint of the feature service to post data to the feature class.
All they do is insert into the feature class through applyEdits which is on a daily basis. My condition is, if the notification number already exist in feature class, it should update the corresponding values for that particular record. If not, it should insert a new record.
I tried creating trigger on Adds table from Oracle following this link but I have very limited knowledge on python and oracle.
Can someone please point in the right direction how to proceed on about this either using python or FME or any other ways?
Really appreciate your time and consideration.
In your case I believe would be better to ask from the team using the apply Edits to make a query with the notification number in order to check if already exist in feature class.
Thank you Panagiotis for your answer.
The team using the below endpoint via automated DataPower gateway technology. I'm trying to understand how to use the applyEdits(adds?, updates?, deletes?, callback?, errback?) method for them to query the data before do a insert or update.
Also, the SAP team sending the data, do not have objectID to validate the query. From the feature class, whenever a new insert happens, the ObjectID, GlobalID generates.
Can you please help me get an idea to understand how?