Search found 13 matches
- Wed Mar 01, 2023 9:51 am
- Forum: Developers
- Topic: Privilege Escalation
- Replies: 1
- Views: 17425
Privilege Escalation
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?
- Thu Sep 22, 2022 1:04 pm
- Forum: API
- Topic: Moved OD db now cant access new data
- Replies: 3
- Views: 4378
Re: Moved OD db now cant access new data
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.
- Thu Sep 22, 2022 11:57 am
- Forum: API
- Topic: Moved OD db now cant access new data
- Replies: 3
- Views: 4378
Moved OD db now cant access new data
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 ...
- Fri Sep 16, 2022 7:50 am
- Forum: Developers
- Topic: Appointment API issues
- Replies: 6
- Views: 10035
Re: Appointment API issues
Ill check that out.. Thank you.
- Wed Sep 14, 2022 1:51 pm
- Forum: Developers
- Topic: Appointment API issues
- Replies: 6
- Views: 10035
Re: Appointment API issues
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...
- Wed Sep 14, 2022 1:23 pm
- Forum: Developers
- Topic: Appointment API issues
- Replies: 6
- Views: 10035
Re: Appointment API issues
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?
- Tue Sep 13, 2022 2:53 pm
- Forum: Developers
- Topic: Appointment API issues
- Replies: 6
- Views: 10035
Appointment API issues
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...
- Thu May 19, 2022 9:37 am
- Forum: Developers
- Topic: Scheduled KPI in Monthly Production and Income report
- Replies: 0
- Views: 8308
Scheduled KPI in Monthly Production and Income report
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...
- Fri Feb 04, 2022 1:14 pm
- Forum: Developers
- Topic: Standard Report Syntax Question
- Replies: 4
- Views: 9822
Re: Standard Report Syntax Question
Thank you. I really appreciate the insight.
- Fri Feb 04, 2022 10:24 am
- Forum: Developers
- Topic: Standard Report Syntax Question
- Replies: 4
- Views: 9822
Re: Standard Report Syntax Question
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.
Thanks again.
- Fri Feb 04, 2022 7:11 am
- Forum: Developers
- Topic: Standard Report Syntax Question
- Replies: 4
- Views: 9822
Standard Report Syntax Question
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...
- Fri Jan 21, 2022 9:18 am
- Forum: Developers
- Topic: ShoryQuery Syntax Question
- Replies: 4
- Views: 10358
Re: ShoryQuery Syntax Question
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...
- Thu Jan 20, 2022 7:17 am
- Forum: Developers
- Topic: ShoryQuery Syntax Question
- Replies: 4
- Views: 10358
ShoryQuery Syntax Question
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...