Sync Records Smart Service - full sync

Question

Hi 
 How do you use Sync Records Smart Service to fully sync a record type that was just modified by a back end stored procedure 
 My case is new data comes in daily in CSV files - which gets uploaded into a set of temporary tables 
 After this a stored procedure inserts them into the main tables that are connected with the record types. 
 As of now we are syncing these record type manually from the web page 
 I though this smart service would have an option to do a full sync, but it needs the IDs of the record types to sync - well these are unknown since they were just inserted by the stored procedure in DB so not available yet. 
 
 Do I need to come up with another data base query to retrieve the new ID - form the database?

Harshit Bumb (Appyzie) · Answer

You must be having a timestamp when these CSV files are introduced in the system, considering this is a repetitive activity. If yes, you can schedule the sync of the records 2-3 minutes after the SP has been completed. Or, if you are using a process model to write this data, then as you said, you can use the sync record smart service. Here is the link on how to configure it - https://docs.appian.com/suite/help/22.2/Sync_Records_Smart_Service.html It requires you to provide primary keys of the record. You can run this smart service for the data you just inserted and if it is more than 1000 rows, then run this service in batching.