Page 1 of 1

Request for API surfacing of timestamps

Posted: Fri Aug 27, 2021 8:49 am
by jasonisla
Hello,

We're working on a data synchronization mechanism between open dental our teledentistry solution, TeleDent. In order to only update records that have been modified since the last sync, we need the ability to query against that parameter for patients and providers. Otherwise, we have to synchronize all patients and all providers at every run, which is very inefficient.

Would it be possible to have the "last modified" timestamp added to the API search query parameters for GET patients and providers?

Thanks,
Jason

Re: Request for API surfacing of timestamps

Posted: Fri Aug 27, 2021 9:19 am
by SLeon
Jason,

The field DateTStamp found in many of the API methods is the timestamp you are looking for. It is the exact server time that row in the database was last modified. The ability to specify the DateTStamp as a search paramater for patients already exists in the newer Patients GET Simple method. Details can be found in our updated documentation here https://www.opendental.com/resources/OpenDentalAPI.pdf.

Providers GET does not currently support the DateTStamp paramater, but I will add this to our development list.

Re: Request for API surfacing of timestamps

Posted: Thu Sep 16, 2021 9:46 am
by SLeon
We have added support for the DateTStamp parameter to Providers GET. Details can be found in our updated documentation here https://www.opendental.com/resources/OpenDentalAPI.pdf.