Skip to main content
C
cedricj425261
May 19, 2022
Question

How to refresh a SYNC Record Type when external data changed

  • May 19, 2022
  • 5 replies
  • 0 views

Hi,

We have a process that calls a stored procedures to modify some data records. These data are used by a SYNC Record Type in the application.

To make synchonize and refresh automatically the RecordType from the Appian application, we added in the process a Smart service (Write to Datastore Entity) that updates a field of the concerned records, this works fine.

Now, we have a stored procedure that cleans the DB (deleting a lot of rows of many tables). So how would you tell to Appian that the data have been deteled ?

(the Record types still display the same data because they did not have been synchonized)

5 replies

mathieud0001
mathieud0001
Brainy
May 19, 2022

The way I would do it is have the stored proc update a table and have a process that runs every 5 mins monitoring that table and trigger a write to data store if something pops up.

mathieud0001
mathieud0001
Brainy
May 19, 2022

This might get addressed in 22.2 though. Stay tuned. [emoticon:9b9b78d905024c3ea42ec0d85601dccf]

stefanhelzle0001
stefanhelzle0001
Brainy
May 19, 2022

True, 22.2 will get you covered with a smart service to be used in a process model and an API endpoint you can call from external to update certain records.

davel001150
davel001150
May 19, 2022

New from the webinar, they also introduced a "Sync Record" smart service node that you can configure to sync a record from a process.  So, call 3rd party integration likely to change this record's data, then sync the record right after that, then close the process.

Terms & ConditionsAccessibility statement