Hi All,
I'm encountering an issue with syncing data in Service based records. Here are the details: - I have scheduled a full sync, but it only occurs once per day. - The API data can update multiple times throughout the day. so I set up the sync expression rule for multiple daily syncs. However, I've observed the following issue when running the "Sync Records" smart service: - If the API returns fewer rows than the current record, the old data is not being removed after the sync.
For example : currently record has 40 rows and now the API returns 15 and I see all 40.
Has anyone faced a similar issue or have any suggestions on how to resolve this?
Discussion posts and replies are publicly visible
AFAIK, Appian only picks up deleted records in a "Full Sync".
so how to remove the incorrect data from the list or do full sync more often.
And in the identifiers , do we have to pass the identifiers from current record or new identifiers( if its known). when I give more identifiers than the list , Appian ran into error saying identifiers exceeded
I do not have that much practical experience with such a situation, but I think the best option would be to get notifications from that other system via API calls.
An if your data changes so frequently, you might want to reconsider the need for sync in general.
thanks for the response btw. I am expecting to sync it around 5 or 6 times a day not a lot. because of performance , sync becomes more inevitable