Syncing Third Party Updates to a series of Database Tables

Question

We have a series of Records configured in one large relationship structure (50 + record types). A third party process retrieves data from a SOAP webservice, extracts pertinent data and using a series of stored procedures inserts that into the database. 
 Is there a way to capture those new entries and sync them into my records without having to examine 50 tables and perform 50 Sync Record operations?

Stefan Helzle · Accepted Answer

You already run a stored procedure that could keep track of all the updates. Why not write these to a separate table. Then a scheduled process in Appian could manage these update by syncing the modified records.

Shubham Aware · Answer

You can automate the process by setting up periodic database queries to retrieve new entries, mapping the data to your record types, and then using Appian's record sync functionality to seamlessly integrate the new entries without manual examination or sync operations for each record type. 
 
 Refer for sync records 
 https://docs.appian.com/suite/help/24.1/Sync_Records_Smart_Service.html#:~:text=The%20Sync%20Records%20smart%20service,first%20configure%20a%20sync%20expression .

Shubham Aware · Answer

Yeah that would be really nice. If Appian releases that feature. Try this workaround if possible 
 To identify unsynced records in an record, you could create a rule that compares the completion time of the previous poll with the timestamps of records in each table. This rule would recognize the discrepancy between synced and unsynced values in the underlying tables. You could automate this process to run periodically or trigger it manually as needed.

Syncing Third Party Updates to a series of Database Tables

Top Replies