Open Dental Forum

In open dental, users are allowed to create confirmation status for appt (e.g., unconfirmed, text, confirmed, READY, etc.). We would like to get the history of confirmation status thru the API. Is this possible?

Good morning,

Can you please clarify? Are you wanting the full list of confirmation statuses the dental office uses or are you wanting to know what confirmation statuses a single appointment has had over time?

We are you wanting to know what confirmation statuses a single appointment has had over time.

beacondental wrote: ↑

Mon May 08, 2023 10:50 am

We are you wanting to know what confirmation statuses a single appointment has had over time.

Good afternoon beacondental,

We can add GET histappointments to our development list. In the meantime, you can use PUT queries/ShortQuery to query histappointment table in the database.

Is there a way to add GET histappointments, PUT or POST histappointments as well. I do recognize that we do can a short query on histappointments appts , but we can not change the histappointments status. Or, is there a way to change the histappointments confirmation status

beacondental wrote: ↑

Sun Jul 02, 2023 6:37 pm

Is there a way to add GET histappointments, PUT or POST histappointments as well. I do recognize that we do can a short query on histappointments appts , but we can not change the histappointments status. Or, is there a way to change the histappointments confirmation status

Good morning beacondental.

If you check out the histappointment schema it reads:

histappointment
"A historical copy of an appointment. These are generated as a result of an appointment being edited. When creating for insertion it needs a passed-in Appointment object."

This means that every time an appointment is made, updated, or deleted in Open Dental and/or Open Dental API, a histappointment entry is made to the histappointment table.

We are currently in the final development stage for histappointments GET. histappointment POST, PUT, or DELETE will never be allowed via the API.

Good afternoon beacondental.

HistAppointments GET is available in version 23.1.30.