Open Dental Forum

Hi! I'm a vendor integrated w/ a practice that just updated their OpenDental server to 24.4. We're relying on the ShortQuery endpoint quite extensively - one of our queries started breaking w/ a 401 error recently and we can't seem to figure out why. The query is: SELECT PopupNum, PatNum, Descriptio...

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

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?

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.

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...

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...