Open Dental Forum

PBECKER

Hello is there any update on the last item?

PBECKER

Hello SLeon Yes we know how to use sftp, this case has nothing to do with any software workflow. In our case since we're huge adopters of open dental's apk and we would rather leverage the api methods and not have to manage another layer sftp. We hope you understand, how this case be seen as a bug/m...

PBECKER

Hello Derek The Documents POST UploadSftp, does not leverage the open Dental Api but allows software vendors to successfully upload a patient profile with zero issues and the profile photo shows successfully But if we're using Open Dental's API which is the tech stack OD has been building requires t...

PBECKER

API Team We have found a bug in the below POST method. Scenario > After we POST under the patient profile folder using the below POST documentation the thumbnail of that patient does not get updated/shown until after we open/view the image in open dental by double the actual image. Documents POST Up...

PBECKER

Thank you so much Derek, greatly appreciated.

PBECKER

apologies on the miscommunication on our end. we meant to inquire on the last item that was remaining - Mark TP as marked with the "X" as for TP signed. Note* For the capturing the actual physical signagure we got that covered on our end. All were needing is to mark the TP as where which show "X" wh...

PBECKER

Is there any update on the last item (remove proc code) from TP? This request started back in june of last year. we understand the request takes times but were wondering how much longer should we be anticipating?

Thank you

PBECKER

any update on the last API method?

PBECKER

any update on the pending items?

Thank for you innovating @OpenDental API Team

PBECKER

Request: Please add "Reschedule" as a value for "confirmVal" as we would pr3fer to utilize "confirmVal" instead of defnum Please let us know if approved and timeline. thanks Appointments PUT Confirm Version Added: 21.1 Only one field is allowed in the JSON object, either confirmVal or defNum. A conf...

PBECKER

Hello API Team, Can you please review the below and advise. Thank you so much API Team. 1. TreatPlans POST for Inactive and Active treatment plans was completed in version 23.2.13. - Completed 2. TreatPlanAttaches POST and PUT are now complete and available starting in version 23.2.17. These methods...

PBECKER

Hello API Team

yes it would be great to have ProcTPs DELETE as that would allow us to remove Procedure code from a "saved treatment plan"

We will wait for the update thank you so much

PBECKER

Is this the option only in order to remove procedure codes from a treatment plan that is in "saved" status? If yes how long do we anticipate this new ProcTPs DELETE method? One other question, procedure Codes that are removed from a "saved" TP would those proc codes be moved to the inactive TP or ar...

PBECKER

Yes we're needing the ProcTPs DELETE as our goal is to have the ability to remove procedure codes from a saved treatment plan that is not signed.

Will this require a new Open Dental version upgrade?

Thank you Open Dental API Team

PBECKER

API Team, We have treatment plans in "saved" status that we would like to update. For example if the TP has 5 procedure codes we would like to remove some of procedure codes and make existing treatment plan as saved or saved and signed. Ref: https://opendental.com/site/apitreatplanattaches.html Trea...

PBECKER

API Team while attempting a POST procedure logs were receiving a response back that "A Surf is required for the procedure code's treatment area" and some procedure codes were receiving a response back that response "A tooth range is required for the procedure code's treatment area" Where can we find...

PBECKER

Hello API Team, For the saved treatment plan were using ProcTPs API call which gives us all the details of the procedure code But in the case of an Active treatment plan, were using the Treatplanattaches API call and it does not return procedure code details, please view the screenshots attached Req...

PBECKER

Hello API Team, We believe we have found a bug with the TreatPlanAttaches GET. We notice when we do a GET "active" TreatPlanAttaches we do not get procedure cost details(fee amount, fees allowed, prim ins amount, sec ins amount, patient amount and discount. When we use the GET TreatPlanAttaches with...

PBECKER

Hello API team, TreatPlans POST (create), we see there isnt a field for "Presenter". Can TreatPlans POST (create) be updated to include Presenter. Parameters: PatNum: Required. Heading: Optional. Default "Inactive Treatment Plan". Note: Optional. Defaults to the TreatmentPlanNote preference. TPType:...

PBECKER

Hello API Team,

Is this in progress? We see the the first item is completed post treatment.

Thank you so much!

PBECKER

Hello API Team Thank you so much! So the remaining methods that are apart of this request are still on progress is that correct? 1. Create Treatment Plan - TreatPlans POST - Done 2. Attach Procedure Codes to Treatment Plan. TreatPlanAttaches POST will allow you to do this for both "Active" and "Inac...

PBECKER

Hello API Team,

Just checking in, are there any updates.

Thank you so much

PBECKER

rockin! Heres the latest feedback 1. Create Treatment Plan - TreatPlans POST will allow you to do this. response > Yes that would be great! 2. Attach Procedure Codes to Treatment Plan. TreatPlanAttaches POST will allow you to do this for both "Active" and "Inactive" treatment plans. It is a linker t...

PBECKER

Is there any API call that returns the cost of a scheduled appointment?

Thank you.

PBECKER

Do we also need a PUT method as we would also need the below capabilities

1. Create Treatment Plan
2. Attach Procedure Codes to Treatment Plan
3. Save Treatment Plan
4. Mark Treatment plan As signed.

Thank you so much API TEAM!!!!

PBECKER

Out of the the dozen that are in the pipeline do any of those happen to be TreatmentPlan Post and reatPlanAttaches POST?

PBECKER

Any timeframe on estimated completion? We we looking at months?

We just now realized that a post method didn't exist.

Looking forward to feedback.

Thank you API Team

-Pedro

PBECKER

We do not see a TreatPlans POST mehtod where we can create a Treatment plan and attach procedure codes

Can TreatPlans POST please be added with same values TreatPlans GET to include marking the treatment plan as signed.

PBECKER

How can these items we added to any of the Treatplan Get methods and/or any other API call? Note these fields are existing fields that are shown to patients for their treatment plan as the patients wants to see how much the insurance is covering and what is their out of pocket cost. Thank you API te...

PBECKER

for ProcedureLog GET we don't see insurance Estimate and Patient Estimate. Is it possible to get these two items added to ProcedureLog GET

PBECKER

any way to update the existing TreatPlansAttaches GET to return all fields names instead of having to GET then compare with ProcedureLogs GET

PBECKER

Is it possible to add the below fields to the api response for TreatPlanAttaches GET

tooth Number
Procedure Cost
Insurance Estimate
Patient Estimate

PBECKER

How can we do a post for Patient photo. We dont see any api methods to post a photo of the patient for their patient profile.

We would prefer not to have to use mysql

Thank you.

PBECKER

restarting econnector solved the issue

PBECKER

API Team, we're getting "504 Gateway Time-out) for a couple of our production locations when trying to communication with the following endpoint https://api.opendental.com/api/v1/patients This is effecting production <html><body><h1>504 Gateway Time-out</h1> The server didn't respond in time. </body...

PBECKER

API Team,

Is there any update on this item? As agreed this is a bug and its causing some big issues for us.

Apologies on asking again.

-Pedro

PBECKER

Question:

What version of open dental is required for (API Subscription) subscription/events/watch tables?

Please and thank you

PBECKER

Thank you so much Sarah.

PBECKER

Hello API Team,

Any timeline on getting this completed? Since its more of a bug will a new version of Open Dental be required once your team is able to resolved this?

Would this be an update to the OD api or to the practices OD version that is installed on their server and workstations?

Thanks

PBECKER

We have found a bug, when a appoint post create is completed it is not updating the "PatientFirstVisitDdate" with datetime samp in Patient Table. Can you please advise Appointments POST (create) Version Added: 21.1 The following fields cannot be set as part of a POST: AptNum, provAbbr, ProcDescript,...

PBECKER

Hey Derek

sorry to be a pain any ETA on when we may hear back on the decision and estimated completion.

Thanks so much Derek

PBECKER

Hello API team,

Can you please kindly advise on the below request?

Please and thank you

PBECKER

Can BlockOutType please be added to > Appointments GET Slots Appointments GET Slots Version Added: 21.1 This is closer to how search behaves from within Open Dental instead of WebSched. This requires no advanced setup. It looks at open schedule times, whether the schedules are attached to a provider...

PBECKER

Hello API Team

Are there any updates on this request?

Thank you!

PBECKER

Question: How can we find out how many patients did or did not show up for their scheduled appointment for a particular day utilizing any of API Get methods.

Greatly appreciated

-Pedro

PBECKER

Sarah any update on this item?

PBECKER

Hello Sarah Yes we loved the new subscription and events document that was just posted a couple days ago. We have successfully subscribed to "Patients" with no issues When any change is made in the patient demographics for example patient name, date of birth, gender, phone number so we're not receiv...

PBECKER

Hello We are trying to implement The data we pass for post request is below : { "EndPointUrl": "https://dev.meetaxle.com/OpenDentalPatientUpdate.aspx/", "Workstation": "AXLE-DEV", "WatchTable": "Patient", "PollingSeconds": 5, "DateTimeStart": "2023-01-01" } or { "EndPointUrl": "https://dev.meetaxle....

PBECKER

nice! Thank you Sarah!

PBECKER

Hello API

Can an API Get TreatmentPlans be created with all columns for each treatment plan.

Goal is to pull all treatment plans that are not yet completed.

we're really loving the API Platform.

Please let me know thank you

-Pedro

PBECKER

Hello Sarah

we agree the od api side is secure.

the issue is were running out of keys that we have to manually add each time.

our goal is either add api keys via an api get method or have a 15 days stored on our database ready for use.

Please let me know

Thank you Sarah

PBECKER

we're seeing the latest available version is 22.3.26.

Is .27 available yet? or can we use .26 to utilize InsVerifies GET

PBECKER

Jordan/Sarah and Team

If a PUT method can be added that would help greatly.

Goal: Update Ins patient plan details for any fields.

please

-Pedro

PBECKER

Hello API Team, Instead of having to manually log into the Open Dental API site and having to click >add > to create a new key we're needing the ability to create the tier 3 key via an API Put method. In the future it would also be nice to disable a key via an API call. Pretty please with a cherry o...

PBECKER

Hello ApI team ,

Are there any updates on this item?

PBECKER

The issue is hit and miss.

The second the the api is working and a couple seconds later its not working

PBECKER

911 Open Dental API appesr to be down Can you please advise . This is the api response "The is most likely a version issue". The version that the customer is using might be to old to support he API method" We haven't made any changes and the above error is occuring at many of our practices. this is ...

PBECKER

Hello API Team

yes if we can get all the insurance details for a patient to also include the insurance plan that would be perfect.

Thank you to the worlds greatest PMS.

PBECKER

Thank you Sarah, it would be greatly appreciated.

-Pedro

PBECKER

Hello API Team,

What is the best method for us to get a patient first visit date? Is there a method for this?

Would it happen to be DateTStamp" from Patients GET (single)?

As Always thank you so much.

PBECKER

We there is a InsVerifies Get method but we would also to request a GET method. We are looking to further automate how we compare insurance data. In order to accomplish this we would like to run a GET InsVerifies that would return all insurance plan benefits with percentages, CoInsurance(s) , Deduct...

PBECKER

The requirement is so that we can easily view each provide has an open slot and which one doesn't. example we would see Dr Becker has open slots (i.e open time available) for an appointment to be created. But, we also need to easily view what open slots for available for Dr Jones. If there are conce...

PBECKER

Hello API team, we have a request: Request : For the following API call --- GET /appointments/Slots? ProvNum=1 & OpNum=18 &dateStart=2022-03-28&dateEnd=2022-04-01 we need the ability to gives us results for all providers and with all operatories. Please let me know. Thank you so much API team Appoin...

PBECKER

Hello Sarah My apologies on the miscommunication. We're trying to find out when we use POST Appointment how can we also attach a certain type of procedure code for example d110? If we're not able to attach a procedure how how would the practice know what the appointment was created for if we dont' a...

PBECKER

Can we get some guidance on AppointmentTypeNumber for Appointments POST (create) What values can we pass for AppointmentTypeNumber? Where is their more rerferene info on how we can utilize AppointmentTypeNumber? Thank you API team. Appointments POST (create) Version Added: 21.1 The following fields ...

PBECKER

example if we perform a Get Recall we would like all results returned and not just 100 or having to use any other methods.

PBECKER

Justine I need a favor you may need to ask Jordan but we're ready to utilize the below get but the limit of 100 is an issue for us as we really need all results without having to use pagination or the localhost options. Is there anyway to get the rows returned to be at the minimum of 2000 rows. This...

PBECKER

Hello API Team Request: update Recalls GET List method https://www.opendental.com/site/apirecalls.html Question 1 or end Date, how can we do current date + x number of days? If this isn't possible can this type of functionality be added for DateEnd? DateEnd: Due date range. String in "yyyy-mm-dd" fo...

PBECKER

Yes that would be great thank you so much.

PBECKER

Hello API Team,

Can the below method please be updated to also GET the below two fields. The method were using is > Patients GET (multiple)

"Gender": "Female",
"Position": "Single",

Thank you API Team, appreciate your team.

-Pedro

PBECKER

Justine

Its back up, thank you so much Open Dental API team!

-pedro

PBECKER

Justine

no worries at all. we use it heavily so we were able to catch it right away.

If you can let us know when its back online it would be greatly appreciated.

Thank you so much Justine

#teamwork

-Pedro

PBECKER

API Team,

Some of our API calls to Open Dental API/EConnecctor are 100% failining?

Can you check and see if everything is ok on theOpen Dental API endpoints?

Let me know, thanks so much API team!

-Pedro

PBECKER

Hello API Team Attn Jordan or Sarah. Really need your help unless you recommend we go with a custom sql query. Question: We're trying to see if any of the Open Dental's APIs offers the below results. The following method appears to do the below can you please advise: https://www.opendental.com/site/...

PBECKER

Hello API Team Question: We're trying to see if any of the Open Dental's APIs offers the below results. The following method appears to do the below can you please advise: https://www.opendental.com/site/apiprocedurelogs.html Patient ID patient Full Name Date of Service: This is the date a procedure...

PBECKER

API We got this to work on the open dental server and did receive the results. As we're looking to continue to build out our APIs calls with open dental, using of local host instead of the public open dental end points we would like to request that this functionality please be added to reports uri. ...

PBECKER

Hello API Team, We have attempted to run this locally on the actual open dental server and we're receiving the following error message. Error Message: Error: Connect ECONNREFUSED 127.0.0.1:30222 Please note we also turned off the firewall on the server to ensure no ports are being blocked. Do you ha...

PBECKER

oK this is now making more sense.

Is there any reason why this has to be run with a different port and as localhost? Instead of the same Open Dental public API endpoints?

We've been a big adopted of the OD API and this is the first we have seen this new method using a port # and localhost.

PBECKER

API Team, We're still unable to do a get with 1000. Everythign we have tried it continues to return 100 records. When we use the End URL (example): https://api.opendental.com/api/v1/reports/Aging?Offset=1000&DateAsOf=2022-07-13&ClinicNum=5 on the local machine we get only 100 records even if the off...

PBECKER

Will this require an updated version of OD?

PBECKER

Awesome, do you know when we can expect the below to be added just a rough timeline?

Thank you so much Sarah.

PBECKER

Hello API Team,

For the "Appointments GET" can you please add the appointment field named > Ask to Arrive Early ?

Please let me know.

Lets keep Innovating!

Thank you API Team

-Pedro

PBECKER

Love it!

As always, Thank you!

PBECKER

Yall are crushin it Thank you Sarah!

PBECKER

Sarah

Thank you friend, any timeline on when we can expect the ability to do a GET by clinics?

#Thank4Rockin!

PBECKER

Hello Sarah, Happy Thursday, Here is our latest feedback on this item: 1) we would like to request an increase for the limit to 1000-1500 for this specific endpoint call > https://api.opendental.com/api/v1/reports/Aging 2) where can we get results according to clinics? with below API link, returns f...

PBECKER

Thank you Sarah!

PBECKER

API Team

We're not seeing a post method to update the Referred from field for a patient. Please see attached screenshot.

Can the API patient info section please be update to allow updating of the > Referred from field.

Please and thank you.

PBECKER

Jordan or API Team, is the max record to pull 100? we have tried to pull more by setting a value of 1000 but it still only returns 100 records https://api.opendental.com/api/v1/reports/Aging?Offset=100&DateAsOf=2022-07-13 We're using the below new API reports Aging but need to pull the entire result...

PBECKER

Hello Sarah!

What if we only would like to see ASAP priority for any records that have today's date and in the future. Meaning we don't want to see any records prior to today's date.

Let me know if this makes sense, my friend!

-Pedro

PBECKER

API Team We believe we may have found a limitation on the Appointments GET (ASAP) method. Scenario: If we runt the GET method it will attempt to return all records that have a priority of ASAP. But...As we know that is a max limit of rows that can be returned. Proposed Solution: Update Appointments ...

PBECKER

API Team Can the below api please be updated the include the following Request: Add Blockouts to the below method, return three columns per record (Block out Unique ID, Block out Name, and Block out Color) and Blockout is it true or false Note the current GET slot does not return the above items tha...

PBECKER

Oh Wow! Seriously? Sarah you Rock!

One question what is the minimum OD version required to perform the above GET

Thanks a Ton Sarah!

PBECKER

API Team,

Is there any API GET method i.e GET Patients or GET Appointments etc that would reflect if a patient is Medicaid vs Non Medicaid Patient?

Thank you API Team!

PBECKER

Hello Sarah Would the method also include the procedure code and/or the description of the completed procedure. Do you think we should work with the OD DB SQL team or is this something that can be added to the OD API? Thanks so much Sarah example Patient Name Amount PCODE John Doe $5.00 d1110 John D...

PBECKER

Jordan/API Team First off thank you for rolling out the Open Dental API! We love it! Request: We currently pull the "standard Open Dental" Aging A/R report that shows total patient balance by Aging period and also insurance balance by patient. We have noticed that the patient balance is the sum that...

PBECKER

Hello API Team

We're not seeing any API method in the API specification document to do a POST of a patients Medical History. Could you kindly advise if this API method exists? If not can it be added?

Request: POST method to update a patients Medical Summary. see screenshot attached as reference

PBECKER

issue: When we use the open Dental API > Allergies POST method > we're getting the following error message: Developer API key does not have permission for ApiAllOthers. https://www.opendental.com/site/apiallergies.html Note we have tried our tier 2 and tier 3 keys and we're still getting the followi...

PBECKER

Jordan

Request: Can the api be updated to allow us to do a GET or perhaps a short query to pull patient profile photo? If we have to go the short query route is there an existing query that we can utilize?

Thank you so much Jordan, love the route your taking with building out the Open Dental API!

PBECKER

#ROCKIN

PBECKER

Thank you so much Sarah greatly appreciated.

Thank you for all that you do!

PBECKER

Hello Sarah We have gone ahead and checked out the below link and the OpenDentalEConnector.exe and also the opendental.exe are both on the same version which is 21.3.35. Also noticed per Jordan's response in the thread that we should not have to modify any user mysql permissions. Could we possibly h...

PBECKER

Jordan Issue: When running the PUT short query against our development open dental database were able to issue the below "select database" with no issues. When we attempt to run the exact same short query against a production database we receive the below error message any ideas on why this may be o...

PBECKER

Jordan

Our contact at Open Dental requested that we post the below question in this forum.

Question, what is the associated functionality with each API Tier key.

Thank you so much Jordan.

PBECKER

Request: Allow get get practice database name and opendentimages path for the practice that the API key is assigned to

If we could get this in the open dental api we would be super grateful.

Thank you Jordan and Team

PBECKER

Hello today we have applied a tier 4 api key and when performing the below GET we're presented with the below error permissions error

GET = https://api.opendental.com/api/v1/operatories
Rrror message = "Developer API key does not have permission for ApiReadAll."
Open Dental Version = 21.3.51

PBECKER

Hi, sorry to piggy back off of this post, but I feel that it might be related- I am trying to GET any available appointment slots for any provider without any date parameters. I'm using the GET Slots endpoint.. I am only able receive an empty JSON array. I've also tried with each provider ID using ...

PBECKER

Just want to make sure we're following along here. Right now when we do GET on slots we get the below response which is an entire business day. 8am to 7pm, which is great but how do find out which slot are not yet taken i.e already scheduled. Should we also be pulling all scheduled appointments and ...

PBECKER

Jordan

Quick question, is there currently any GET method that will return what times are available to be scheduled?

example provider 1 works in op3 and schedule is 8am to 8pm. but they have many open slots that can be filled. example 8am-10am and 1pm-2pm.

If not what is good method to achieve this?

PBECKER

perfect, we'll make sure to send you a PM once we need to move over a key to the Tier 3.

We're shooting for later this week or the latest early next week

PBECKER

Thank you Jordan Greatly appreciated.

PBECKER

Hello Leon Yes we're using the following exact URI https://api.opendental.com/api/v1/appointments/Slots?date=2022-02-16&ProvNum=18 If the provider has various empty "available slots" why are they not being returned? Instead we're receiving the actual "entire day working hours" instead of empty slots...

PBECKER

- All of a sudden we're having 2 practices that are returning "The server has encountered an error." -We have also utilized postman and checked with a working api key compared to the two keys that don't work Thus far we have verified the following: -GET url is correct and operational for all other A...

PBECKER

Jordan When FHIR was made public we worked with Brian Miller and they provided us with two differenet username, one for Tier 2 and one for Tier 3. We're trying to figure out how can we have just a single user id that allows us to upgrade or vice versa down grade the tier of the key tier 1-tier 4 It ...

PBECKER

Jordan Need you help on this one. Overview: We have many practices on Tier 2 key but we need an efficient way to upgrade the key to Tier 3 without having the change the actual key itself. As we don't have access to many of the practices and it would cause alot of hovoc Question/Request: How can we u...

PBECKER

Open Dental Team We believe we may have found an issue with the following API call. https://api.opendental.com/api/v1/appointments/Slots?2022-02-16&ProvNum=18 Scenario: Provider 18 is scheduled to work in OPNum 21 from 0800 to 1900. Issue: When we run the following GET https://api.opendental.com/api...

PBECKER

ok, please let us know as adding blockout's would greatly assist and enhance the Open Dental API.

PBECKER

Thank you so much Justine, greatly appreciated.

PBECKER

Hello Open Dental Team,

We're not finding any api reference to pull blockouts.

Request: Pull all details of blockouts that are on the schedule.

Could you kindly let us know if this request is approved or denied.

Thank you so much

PBECKER

Hello Leon Are there any updates on the below remaining items 1. https://www.opendental.com/site/apidefinitions.html (Ability to create definitions) 2. https://www.opendental.com/site/apiproviders.html (Ability to create provider) 3. https://www.opendental.com/site/apiapptfields.html (Ability to cre...

PBECKER

Hello Jordan

Sorry to ask are their any timelines on any of the requests?

specifically #7 last visit date

Thanks so much Jordan, we love Open Dental

PBECKER

5. its a tricky one for sure. would be nice to allow our installer package to enable and activate with key. Thank you Jordan

PBECKER

Thank you so much Jordan!

PBECKER

Hello Jordan 5. We see your point, sounds like this step will need to continue to be a manual step. 6. yes that is the correct generate query button. We're wondering is there a method to run a GET and retrieve the same results as the Generate button query produces? 7. we're ok with a GET of past app...

PBECKER

Jordan its been awesome working with your team for many years, thank you! Below are some new requirements for the Open Dental API, please let me know know if these can be added. 1. https://www.opendental.com/site/apidefinitions.html (Ability to create definitions) If you agree, we we would need the ...

Search found 125 matches