Open Dental Forum

For all the tables, that support last edited values, there is a way to retrieve data that has been edited/added after a certain time; "get simple" for patients and "DateTStamp" param for appointments. However this is not the case with Schedules. Is there any way to get all the schedules that has been added, edited after a certian period of time?

BardUser wrote: ↑

Mon Dec 30, 2024 2:32 am

For all the tables, that support last edited values, there is a way to retrieve data that has been edited/added after a certain time; "get simple" for patients and "DateTStamp" param for appointments. However this is not the case with Schedules. Is there any way to get all the schedules that has been added, edited after a certian period of time?

Good morning BardUser,

I have added either enhancing the existing GET schedules (multiple) endpoint to include the DateTStamp field or possibly creating a new GET schedules/Simple endpoint. The Simple endpoint would return everything from the schedule table, rather than a datatable like the current schedules GET (multiple) does. This is similar to the patients/Simple endpoint.

In the meantime, you can setup a schedule database event that sends out an API event to your endpoint anytime a schedule is inserted or edited, or you can use the ShortQuery endpoint to retrieve schedules and related data in any format you'd like.

Please see:
https://www.opendentalsoft.com:8085/for ... f=9&t=7935
https://www.opendental.com/site/apievents.html
https://www.opendental.com/site/apisubscriptions.html

Thanks!

The GET schedules (multiple) endpoint and GET schedules (single) endpoint have been enhanced to include the DateTStamp field.

Thanks!