I have a synced record with a database table. I can successfully write new data to the table using the "import excel to database" within a process model. Unfortunately, after uploading new data the synced record is not updating. If I manually sync the record it will update correctly. How do I ensure the data is synced when I upload new data?
According to Appian Documentation the record is suppose to automatically sync: "To keep your synced data up-to-date with the source, an immediate sync occurs whenever Appian writes to the source of your data."
https://docs.appian.com/suite/help/21.2/Records_Monitoring_Details.html
Additionally, I've confirmed that Sync is enabled:
Any thoughts or suggestions is appreciated.
Thanks!
Discussion posts and replies are publicly visible
Records get automatically updated when using the write to data store nodes/functions. That plugin is going directly to DB by-passing this mechanism.
Is it possible to NOT sync that record?
we can turn off the sync from the record type settings. if we don't want to sync it automatically
I know that. My question is: Why is that records synced and would that chosen design work without it.
Got it, thanks! fortunately I can re-work the design to not depend on the table updated by the "import excel to database". Earlier in the process we use the "Write to Datastore" function and I was able to use this as the record source.