Retrieve deleted Appointments for syncing

[thjomha]

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

[DerekR]

When an appointment is deleted and removed from the appointment table, an entry is made in the histappointment table indicating that the appointment was deleted when the HistApptAction field equals "Deleted". See HistAppointments GET (multiple) for more details.

Another option would be to utilize API Events, and more specifically, the Database Events to keep track of deleted appointments.

Thanks!