Open Dental Forum

Hi Support, Question about replication, please: customer has Open Dental interface eConnector connected to one site A, and database is replicated to and from two other sites. If I get call the API to get appointment deltas for the last hour, do I get appointments from all three sites. Can three diff...

Thanks. That solved the mystery, except one thing.

In the list I got from appointmenttype table there no AppointmentTypeNum 0. Some appoinments (actually most) I pull seems to have that value. What does "AppointmentTypeNum": 0 mean?

When getting appointment details, how does the AppointmentTypeNum value work? I don’t see API appointments returning values mapped to Appointment Type. For instance, I pick Appointment Type “Cosmetic Whitening”, which in my definitions is set up with number 328. Then I save the appointment. I’d assu...

A question about ASAP appointments when getting multiple appointments, please. It looks like currently getting multiple appointments (with DateTStamp) includes also ASAP appointments. Is there a way to identify which ones of those ASAP? Currently it looks like I'd have to do a separate request to GE...

Thank you for the quick reply. I have couple more questions, please: 1. Do the eConfirmation status settings (as in the picture in https://www.opendental.com/manual/automatedmessagingadvanced.html) apply to confirmations received over the REST API? For instance, I'd map Accepted to "Confirmed - <som...

I use PUT /appointments/<appointment number>/Confirm with {"confirmVal":"Confirmed"} to confirm an appointment at one site. Somehow the status becomes mapped to a custom status value "Confirmed - <some string>". Could you tell me how that mapping is done, please? I have tried to find it in the manua...

Thanks for the info. Much appreciated.

The link https://www.opendental.com/OpenDentalDocumentation21-3.xml#appointment mentions couple AptStatuses I don't see in the GUI: 1. Planned: 6- Planned appointment. Only shows in Chart module. User not allowed to change this status, and it does not display as one of the options. 2. PtNote: 7- Pat...

Is there a chance you could store the defNumApptType and include it in the response when we ask for appointment details, all appointments and appointment deltas?

Thank you. That's explains. I forgot to look for it in the schema document first.

No problem. Thank you for the update.

What's the purpose of Pattern in the API? I receive that in the appointment details. for example: {"AptNum":893,"PatNum":15,"AptStatus":"Scheduled","Pattern":"//////XXXXXXXXX///","Confirmed":19,"confirmed":"Unconfirmed","Op":2,"Note":""... Is it some sort of time pattern for what work the patient wi...

I'm missing something with setting appointment to Status broken. The API document mentions use of confirmVal and defNum, but those seems to impact only Confirmed status in the application (and in the REST responses). Status stays Scheduled although Broken is available in the application. I tried fee...

Thanks for your response. Perhaps we haven't been clear what we are trying to achieve. How about this scenario: 1. Patient wants to reschedule existing appointment. 2. Our application knows the ID (AptNum) of the existing appointment. 3. In order to ask Open Dental for slots, we need to specify the ...

I think I need a little help with this. In our app we are trying to reschedule an existing appointment. We have the appointment Id so we can query the API for appointment details. In order to reschedule we call “get SlotsWebsched”. This API call requires us to specify an appointment type. An example...

Thank you for the update. I'll take a look at it soon.

Thank you. Works great with the latest Beta.

Thank you, that explains. I missed the Pagination section in the document.

Hello, I have couple questions about Getting multiple appointments: -What is the maximum limit of number of appointments returned (can I ask for instance 30,000 records at once, or all there is at once)? -Can we ask to get me the next 100 appointments from a certain offset? -Is there are maximum dat...

Excellent. Thank you.

There's one more thing about Appointments GET SlotsWebSched. The specs say ClinicNum: Required if clinics enabled.

How do I find out if clinics are enabled?

I'm able to confirm appointments using PUT, for example: https://api.opendental.com/api/v1/appointments/63/Confirm with body {"confirmVal":"Confirm"}. Querying appointment status show the status as Confirmed. I can use some other statuses in confirmVal as well. What would be the way to cancel an app...

Thank you

This service type should go to both GET single appointment and GET multiple appointments.

Do you have plans to provide through the API a way to query alternative contact information for patient (Power of attorney for someone, next of kin...)?

Very good to hear you added appointment type to the development list.

I'll back back to you soon if there's more that could be good for the GET SlotsWebSched. Now I believe location Id (ClinicNum) might be useful. There's an Op (operatory), but a more specific location may be good.

I got the GET SlotsWebSched working. To further clarify my question about service types, I'd like to ask: In our app we are trying to reschedule an existing appointment. We have the appointment Id so we can query the API for appointment details. In order to reschedule we call “get SlotsWebsched”. Th...

Thank you for the help, Sleon. Much appreciated. One more question about this, please. I currently have Patient and Appointment permissions for development purposes (no real patient data). https://www.opendental.com/manual/webschedexistingpatsetup.html says that "Sign up for Web Sched Existing Patie...

I have a question about clinic number. Is ClinicNum an external Id of a practice (location or account id)?

If practice has multiple locations, is ClinicNum the location?

Thank you for the speedy response!

I'm thinking of a use case example where a patient a crown scheduled. The patient wants to cancel that appointment and reschedule crown for another date and time. Patient then want to query open slots that are available for crown operation, and pick a new appointment time from from those. Do you cat...

There’s a GET for appointments altered after the specified date and time (GET appointments with DateTStamp).

It would be very beneficial to have GET patients altered after the specified date and time as well.

Is there a possibility that it will be made available for the REST API?