Question

Sync in service based records with sync expression rule

Forum|Forum|2 years ago
May 30, 2024
5 replies
0 views

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?

stefanhelzle0001

AFAIK, Appian only picks up deleted records in a "Full Sync".

gokulv342828Author

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

stefanhelzle0001

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.

konduruc733182

Yes, As Stefan mentioned this would happen only on a Full sync.

Sign up

Login with SSO

Login to the community

Login with SSO