Getting ProgNotes by edit date

[dannybess]

We’re currently facing an issue with retrieving ProgNotes through the OD API. It appears that ProgNotes can only be accessed on a patient-by-patient basis (i.e. chartmodules/{pat_num}/ProgNotes), which forces us to ingest the data one patient at a time. This approach makes it challenging to keep our data fully synced.

For other data types like appointments and treatment plans, we can fetch them at the practice level and filter by entries that were added or updated after a specific timestamp, which is much more efficient.

Does anyone know of a technique, workaround, or API feature that would allow us to retrieve patient ProgNotes/commlogs at a larger scale or based on a timestamp? Any insights or suggestions would be greatly appreciated!

Thanks in advance!

[SLeon]

Good afternoon. I moved your question into the appropriate forum for visibility.

The ChartModules GET ProgNotes endpoint returns the data displayed in the ProgNotes grid within Open Dental's Chart Module. This data is simply the compilation of different tables that have that patient's data. These tables are listed in the API documentation:

ObjectType: The type of object being displayed: Appointment, Commlog, Task, Email, LabCase, Rx, or Sheet.

You can get obtain this data without a PatNum constraint by using either a GET method (such as LabCases GET) or a query (with Queries PUT ShortQuery).

[dannybess]

Thanks for the reply! I'm specifically looking to get Commlogs (https://www.opendental.com/site/apicommlogs.html).

However, we are ingesting data for a lot of patients - so it gets pretty slow for us to re-ingest all commlogs for every patient anytime we want to check if there has been a new Commlog.

I know TreatPlans has a SecDateTEdit param that lets us get all TreatPlans, for all patients, that have been edited past a certain timestamp. We were wondering if there would be a way to do this for Commlogs (such that we can just, for instance, ingest all Commlogs that have been written today, without needing to re-ingest all previous Commlogs).

[SLeon]

The "timestamp" column for the Commlog table is called DateTStamp. This date field is automatically updated whenever a change is made to the row (including insertion).

We can add this field to the API response for Commlogs, as well as add a DateTStamp parameter filtering. I have added this to our development list.

In the meantime, you can write a query to leverage this column and use the ShortQuery method I mentioned above.

[dannybess]

Great, thank you for adding that request - ShortQuery is working for now!

On that note, is there anywhere I can see all available tables? Wondering if I can query https://www.opendental.com/manual/chartbig.html somehow to get a list of completed / scheduled procedures per tooth.

[SLeon]

... is there anywhere I can see all available tables?

Open Dental's database schema can be found here.

[dannybess]

Got it, thanks! It looks like `toothgriddef`, `toothgridcol`, and `toothgridcell` are relevant - but these tables are empty. Curious where OD queries the information from which is displayed in the Chart Module odontogram?

[dannybess]

Ah, sorry, just looked at the `procedurelog` schema. I'm guessing it just constructs a query against this?

[JTS]

We have completed this feature request. Commlogs GET now allows filtering by DateTStamp, and it shows the DateTStamps of returned Commlogs as well. We've also added a GET single, and adjusted the existing PatNum filter to be optional.

This functionality is available as of beta version 25.1.13. Please see https://www.opendental.com/site/apicommlogs.html for more information.