Open Dental Forum

I’m experiencing an issue with the blockout feature in OpenDental. Despite creating a blockout period, I am still able to book appointments within that blockout time, both from the appointment view in the OpenDental software and via the API. Is there a setting I may have missed to prevent booking ap...

I am working with the Open Dental API and need to retrieve patient and appointment details, including data stored in custom fields (PatFields and ApptFields). Currently, I see that: - The Patients API returns standard patient details but does not include PatFields. - The Appointments API retrieves a...

Thank you for your prompt response and the provided details. To clarify, since there is no direct association between a Provider and a specific Clinic, does this imply that Providers within a single Open Dental instance can be linked to patients and appointments across multiple Clinics? In essence, ...

Hello, We are integrating Open Dental with an external system and are currently working with the Provider API. Upon reviewing both the API response and the database schema, we could not find any column or property that directly links a Provider to a ClinicNum. Could you please confirm: 1. Is there a...

Thank you for the prompt response and confirmation regarding retrieving deleted patients using the PUT ShortQuery API. We now have another query: We attempted to delete appointment records using the PUT ShortQuery API with the following query: { "SqlCommand": "DELETE FROM appointment WHERE AptNum = ...

I have a query regarding the Schedules GET API. How is the SchedType determined? According to the data dictionary, the following types exist: - 0 = Practice - 1 = Provider - 2 = Blockout - 3 = Employee When and for what scenarios are these types used? I tested adding a schedule for a specific opera...

We are trying to update operatories based on the availability of providers and found two APIs that seem relevant: Schedules GET and Appointments GET Slots. Is there a better or more recommended way to achieve this? Additionally, I have a query regarding the Schedules GET API. How is the SchedType de...

We are looking for the best way to retrieve deleted patients using Open Dental’s API. Based on our findings, Open Dental does not provide a direct API to get deleted patients, as the GET Patients API does not return records with a "Deleted" status. However, we found that using the Queries PUT ShortQ...

I would like to know the way to stop multiple appointments from being booked for the same time slot through both the desktop application UI and the API. My goal is to ensure that only one appointment can be scheduled per time slot. Any guidance on how to achieve this would be greatly appreciated.

Thank you for your insights and clarifications regarding my previous questions. I have some additional inquiries based on the responses I received: ProcedureLogs Module 1. GET /procedurelogs Response: In the response from the `GET /procedurelogs` endpoint, I noticed the fields "Priority" and "priori...

Thank you for your detailed response regarding my questions about the Open Dental API modules. I appreciate the clarifications provided. I have a few follow-up questions based on your insights: FamilyModule 1. GET Insurance Response Tables: Could you specify the names of the tables that generate the...

I'm working with various Open Dental API modules to sync data, and I have several questions regarding the handling of specific parameters like `DateTStamp` and the behavior of certain endpoints. Below are my questions for different modules: FamilyModule 1. Tables used in GET Insurance response: What...

Thank you for the helpful response to my last questions about syncing patient data with the Simple Patients API. Based on your guidance, I've developed a plan to initially fetch data using the Queries POST API and subsequently use the API calls for each module with the DateTStamp parameter. Is this ...

I'm working with the Simple Patients API to sync patient data, and I have a couple of questions regarding the handling of `DateTStamp` and record fetching. 1. Fetching in DateTStamp Order: Is there a search parameter or any other way to fetch patient records in an ordered manner by `DateTStamp`? Cur...

Hello SLeon, Thank you for the detailed response and the helpful insights on pagination and handling large datasets with the Open Dental API. I have another related query: I'm looking to fetch patient records between two specific dates using the Open Dental API. While I understand the pagination and...

I am currently working with the OpenDental API to retrieve patient records and I need to handle large datasets. Specifically I need to fetch potentially large volumes of data such as hundreds of thousands of records in a manageable way. I have been using the offset parameter for pagination but I've ...