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!
Discussion posts and replies are publicly visible
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-expressionAlso, you have to pay attention, if there is some API limits in existence regarding the # of records which can be retrieved.
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
As I understand sync expressions are used to sync specific records, mostly identified using record primary key. I am referring to scheduled full overnight syncs that run in batches of a thousand records at a time and need to pass information from one batch to another.
The sync record node has an output which indicates, if records were synced in that loop.