Record Sync in Batches

Question

Hi!, 
 We have a web service based record type that needs to be synced overnight in batches as we need to sync more than a thousand records. Batch 1 returns information that needs to be used while calling subsequent batches. We have not been able to find a way to store this information as the record data source expression rule is not allowing to call write record smart service or do a post call to a web API. Any help is greatly appreciated. Thank you!

juergeng0002 · Answer

Hi, To use the Sync Records smart service with a service-backed record type , you must first configure a Sync Expression on your record type. You mention the record data source expression, which only applies for synced record types (database). Sync Expressions are similar, but not the same. Maybe the documentation might be helpful here: https://docs.appian.com/suite/help/23.4/records-data-sync.html#generate-a-sync-expression Also, you have to pay attention, if there is some API limits in existence regarding the # of records which can be retrieved.

juergeng0002 · Answer

A detailed example how to loop around the batches of 1000 and to exit the loop when no further updates available can be found here:
https://docs.appian.com/suite/help/23.4/Sync_Records_Smart_Service.html#sync-more-than-1000-records