Que. You are configuring a record type and utilizing data sync. Appian does Not have access to the source database table, and will not make updates. which data Sync is appropriate?
is it 1)Daily Sync 2)hourly Sync 3)Immediate Sync 4)Manual Sync
Discussion posts and replies are publicly visible
pushpaks1412 said:Appian does Not have access to the source database table
Can you explain then how in this scenario the Record is connected to the data? Is there data in your record?
hi pushpak, please try write records smart service instead of write to data store entity smart service. The write records stores the data in records as well as in database table. If you do any changes in data, it will automatically update the data in records and in database table also. hope you get a solution according to the method i told you.
The best way to do this is by Daily sync with the external system sending an event to Appian in case of any data change. You can configure a web API that will receive the record identifiers which are newly created or recently updated by the external system. This way you will never go out of sync.
If the event mechanism is not possible then go for Daily sync. But in this methodology sometimes record data might not be live/correct, so whenever you are displaying a summary record/ consuming in a related action do the live calls to avoid any kind of discrepancies.