Retrieve deleted Appointments for syncing
Posted: Mon Jan 15, 2024 10:25 am
I am writing a module that synchronises my local database with a list of appointments and schedules. I will use DataTStamp to only update/add appointments that have changed since the last sync. The problem is that deleted appointments are just removed instead of changing to status 'deleted'...so I am not sure what the most efficient way to sync deleted appointments would be.
I considered SecurityLog->PermType=237, but the AptNum does not populate in the FKey). I could just search for missing AptNum in the sequence but I am trying to limit API calls and bandwidth since the program will update on intervals as short as 5 min.
Any advice? Has anyone written an open source database sync they are willing to share?
Taha
I considered SecurityLog->PermType=237, but the AptNum does not populate in the FKey). I could just search for missing AptNum in the sequence but I am trying to limit API calls and bandwidth since the program will update on intervals as short as 5 min.
Any advice? Has anyone written an open source database sync they are willing to share?
Taha