Skip to main content
sudipd0003
sudipd0003
December 8, 2022
Question

Sync newly created records from database

  • December 8, 2022
  • 3 replies
  • 0 views

Hi,

We have a database table where data gets dumped in a regular interval by a ETL job. We are using database Backed record with synced functionalities. Now, we need to sync/import newly inserted data to record in a regular interval, but FULL SYNC cannot be done automatically (more than once a day). Is there any way to get those new data in Record?

3 replies

stefanhelzle0001
stefanhelzle0001
Brainy
December 8, 2022

Is this what you are looking for? https://docs.appian.com/suite/help/22.4/records-data-sync.html#sync-changed-data

sudipd0003
sudipd0003Author
December 8, 2022

Hi Stefan,

In order to use 'Sync Record' function/smart service, I need to specify the record identifiers. I am looking for a way that the Record syncs newly inserted data in the database table.

L
laura.marin
December 8, 2022

How does it know it's newly inserted? If you can query the data first to identify the new records (modified date? create date?) you can feed the identifiers to syncRecords (up to 1000). 

Terms & ConditionsAccessibility statement