Search found 32 matches

by jarkkok
Wed Dec 20, 2023 7:23 am
Forum: API
Topic: Replication and API to get appointment deltas
Replies: 1
Views: 2004

Replication and API to get appointment deltas

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...
by jarkkok
Wed Jun 07, 2023 6:25 am
Forum: API
Topic: API AppointmentTypeNum and Appointment Type
Replies: 3
Views: 2690

Re: API AppointmentTypeNum and Appointment Type

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?
by jarkkok
Mon Jun 05, 2023 11:10 am
Forum: API
Topic: API AppointmentTypeNum and Appointment Type
Replies: 3
Views: 2690

API AppointmentTypeNum and Appointment Type

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...
by jarkkok
Wed Feb 09, 2022 12:56 pm
Forum: API
Topic: ASAP and Appointments GET (multiple)
Replies: 2
Views: 2356

ASAP and Appointments GET (multiple)

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...
by jarkkok
Thu Dec 02, 2021 11:03 am
Forum: API
Topic: Confirm appointment status mapping
Replies: 3
Views: 2955

Re: Confirm appointment status mapping

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...
by jarkkok
Wed Dec 01, 2021 12:16 pm
Forum: API
Topic: Confirm appointment status mapping
Replies: 3
Views: 2955

Confirm appointment status mapping

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...
by jarkkok
Tue Oct 19, 2021 8:20 am
Forum: API
Topic: Cancelling appointments
Replies: 10
Views: 11156

Re: Cancelling appointments

Thanks for the info. Much appreciated.
by jarkkok
Mon Oct 11, 2021 12:15 pm
Forum: API
Topic: Appointment statuses Planned, PtNote and PtNoteCompleted
Replies: 2
Views: 4229

Appointment statuses Planned, PtNote and PtNoteCompleted

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...
by jarkkok
Mon Oct 11, 2021 11:01 am
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Re: Categories and appointment service types question

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?
by jarkkok
Fri Oct 08, 2021 1:53 pm
Forum: API
Topic: Pattern
Replies: 2
Views: 4302

Re: Pattern

Thank you. That's explains. I forgot to look for it in the schema document first.
by jarkkok
Fri Oct 08, 2021 1:39 pm
Forum: API
Topic: Cancelling appointments
Replies: 10
Views: 11156

Re: Cancelling appointments

No problem. Thank you for the update.
by jarkkok
Fri Oct 08, 2021 12:10 pm
Forum: API
Topic: Pattern
Replies: 2
Views: 4302

Pattern

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...
by jarkkok
Fri Oct 08, 2021 11:34 am
Forum: API
Topic: Cancelling appointments
Replies: 10
Views: 11156

Re: Cancelling appointments

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...
by jarkkok
Thu Oct 07, 2021 2:52 pm
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Re: Categories and appointment service types question

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 ...
by jarkkok
Wed Oct 06, 2021 2:15 pm
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Re: Categories and appointment service types question

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...
by jarkkok
Tue Oct 05, 2021 7:07 am
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Re: Categories and appointment service types question

Thank you for the update. I'll take a look at it soon.
by jarkkok
Fri Aug 20, 2021 12:20 pm
Forum: API
Topic: GET Patients altered after the specified date and time
Replies: 4
Views: 6613

Re: GET Patients altered after the specified date and time

Thank you. Works great with the latest Beta.
by jarkkok
Tue Aug 10, 2021 1:40 pm
Forum: API
Topic: GET multiple appointments pagesize and offset
Replies: 2
Views: 5064

Re: GET multiple appointments pagesize and offset

Thank you, that explains. I missed the Pagination section in the document.
by jarkkok
Tue Aug 10, 2021 12:33 pm
Forum: API
Topic: GET multiple appointments pagesize and offset
Replies: 2
Views: 5064

GET multiple appointments pagesize and offset

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...
by jarkkok
Fri Aug 06, 2021 2:38 pm
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Re: Categories and appointment service types question

Excellent. Thank you.
by jarkkok
Fri Aug 06, 2021 2:07 pm
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Re: Categories and appointment service types question

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?
by jarkkok
Thu Aug 05, 2021 8:06 am
Forum: API
Topic: Cancelling appointments
Replies: 10
Views: 11156

Cancelling appointments

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...
by jarkkok
Thu Aug 05, 2021 8:00 am
Forum: API
Topic: Power of attorney query
Replies: 3
Views: 5530

Re: Power of attorney query

Thank you
by jarkkok
Wed Aug 04, 2021 8:10 am
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Re: Categories and appointment service types question

This service type should go to both GET single appointment and GET multiple appointments.
by jarkkok
Tue Aug 03, 2021 12:42 pm
Forum: API
Topic: Power of attorney query
Replies: 3
Views: 5530

Power of attorney query

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...)?
by jarkkok
Tue Aug 03, 2021 11:08 am
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Re: Categories and appointment service types question

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.
by jarkkok
Tue Aug 03, 2021 7:48 am
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Re: Categories and appointment service types question

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...
by jarkkok
Fri Jul 30, 2021 2:29 pm
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Re: Categories and appointment service types question

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...
by jarkkok
Thu Jul 29, 2021 1:26 pm
Forum: API
Topic: ClinicNum question
Replies: 1
Views: 5427

ClinicNum question

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?
by jarkkok
Thu Jul 29, 2021 11:41 am
Forum: API
Topic: GET Patients altered after the specified date and time
Replies: 4
Views: 6613

Re: GET Patients altered after the specified date and time

Thank you for the speedy response!
by jarkkok
Thu Jul 29, 2021 10:17 am
Forum: API
Topic: Categories and appointment service types question
Replies: 16
Views: 12665

Categories and appointment service types question

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...
by jarkkok
Tue Jul 27, 2021 2:14 pm
Forum: API
Topic: GET Patients altered after the specified date and time
Replies: 4
Views: 6613

GET Patients altered after the specified date and time

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?