Open Dental

My dev account currently have Query and read all access to the API for my companies clinics. We wanted to add Appointments to the privileges and wanted to ask is that something done on the OD software side per clinic or is that something done via you at OD to give my dev account the authorization?

I created a new API key specifically for the new db location and im pulling with that key which is only in the new software not the AWS instance with the old company.

Our company recently changes IT support vendors for one of our clinics. In doing so we went from housing the OD db in a vendor supplied AWS VPC to an in-clinic server supported by the new company. Since doing the switch I am unable to get updated data via the API. I even tried changing to a new API ...

Ill check that out.. Thank you.

So the goal is to identify all XX minute slots open in the near future for a clinic regardless of Pov or Op for new patient appointments. It save a little time for the front desk but can also be a metric for identifying when prov staffing might need to be increased, based on how far out the next ava...

That was very helpful, thank you. My issue was i wasnt giving a ProvNum and heaven knows what the default is set to. Once I specified a ProvNum it worked. Is the ability to also specify ClinicNum something that may be coming in the future?

When I use the Appointment Slots API of offices not on "Clinic" I get results but when I use it on a "Clinics" db i get no results. It doesnt error it just shows me no results. I have tried adding a ClinicNum to the url just incase but that doesnt change anything. Is this API fuction not usable to G...

On the Monthly Production and Income OD report if you run it mid month you have scheduled $ for future days. I have been trying to replicate this one KPI through the API but cant seem to match it. I know that the procedurelog table has the procfee and one could just total that BUT the claimproc tabl...

Thank you. I really appreciate the insight.

That worked. Thank you. If you happen to know why getting patient payments strictly from the payments table isnt adding up right either I'll take one last asssit. If not no worries. I'll figure these tables out eventually.

Thanks again.

To Whom it May Concern, I am constructing custom sql reports for our offices and have found my equations dont match those found in the standard monthly (day by day) Production and Income report. Particularly the 'Ins Income' numbers. I was wondering if I might be able to see the whole sql syntax use...

Good morning I tried utilizing the test keys with no luck there either. So it’s not a clinic software version issue. Dev_KEY = "NFF6i0KrXrxDkZHt" Customer_KEY = "VzkmZEaUWOjnQX2z" header = {"Authorization" : "ODFHIR %s/%s" % (Dev_KEY,Customer_KEY)} ShortQuerysite = "https://api.opendental.com/api/v1...

I am currently trying to utilize the ShortQuery feature of the API and having issues. My Get requests for other resources work fine so I know authentication isnt the issue. I have had the clinics update to 21.3.39 to ensure its not an outdated version that doesnt allow for ShortQuery usage. My pytho...