Open Dental

Hi, Through the open dental application Once we create the claimtracking note through UI, System updating the claim.customtracking column with latest note from definition claimtracking.trackingdefnum (i.e. definition -> defnum) to respective claim. Through ClaimTracking POST Api Once we create the c...

Thank you.

Hi, We are seeing lot of duplicate records for sequence type 4,5,6 in PerioMeasure table, below is the query we are running to check the data. select SequenceType , IntTooth , PerioExamNum from perioMeasure group by SequenceType , IntTooth , PerioExamNum having count(*) > 1; Can you please confirm w...

SLeon, You are seeing old commlogs in the dental office's database that do not correspond to a CommLogType/Category=27 definition but instead to a different category? Or do they not correspond to a valid defnum at all? When you say, "antiquated", how old are these commlogs and where they made within...

Recently, while accessing data via the API, we ran into a data issue related to Comm Log Notes. We discovered that the primary key value 'defnum' in the 'definition' table does not match the 'CommType'. This issue is prevalent for some records with more than 1 client. For instance, There are antiqua...

Thank you

Thank you

SLeon,

Thank you for the update.

Hi SLeon,

Any update on this notes request, when can be completed? and in which version we will get this functionality?

Thanks,

Thank you SLeon

Hi, We are supporting the OrthoRemainM update from our system, if we update in our system then we are going to update in open dental, as I don't see this column added to https://opendental.com/site/apiclaims.html to Claim PUT API request details. Can you please update this API to allow the OrthoRema...

Thank you SLeon

In our application, there is a requirement for integration with Open Dental notes. We would like to request the following functionality in the Open Dental API, as I don't see any APIs which support the functionality we currently need. Request 1: Add custom tracking status history Use Case - - We imp...

Hi SLeon,

Thank you so much, This will help. If anything will update you.

Hi, I have gone through the open dental solution to find the patient ledger and patient aging logic, below are the things which I have found. 1. Patient Ledger - Created the custom queries for tables below to get the patient or patient's family account records. ClaimSnapshot Claim Procedurelog Patie...

Thank you SLeon, I will check on that.

Hi - We have one registration key which we are using 3 different machines were Open Dental Software installed. - We have created a Customer API key for those 3 different machines and added to respective machine. - We have different data on each machine. - When we are calling the Patient/Claim, etc. ...

Thank you SLeon!!

Yes, I need the same feature request to update the claims via API request.

Thanks in advance

Thank you

Hello,

I want to update the claim table using https://api.opendental.com/api/v1/queries/ShortQuery API, How can I achieve this?

Thanks,

Thank you

Thank you

Hi, Can you please help to know what permission or steps require to see the clinics menu in Open dental?

It works thank you very much for all the help.

GRANT SELECT ON *.* TO ''@`localhost`

I already have all this Grant permission to mysql user but still getting the same error for shortquery api, Please help me on this?

GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED BY PASSWORD '' WITH GRANT OPTION
GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION

Thank you I will check that

Thank you so much, I have updated to version 21.2. Now I am getting the below error while calling the shortquery API.

"An SQL error occured: Authentication to host 'localhost' for user '' using method 'mysql_native_password' failed with message: Access denied for user ''@'localhost' to database"

I am able to get the data from PATIENT GET API, but "/queries/ShortQuery?Offset=99" this API isn't working PUT method and its gives me Bad Request.

I am using PUT method for this URL https://api.opendental.com/api/v1/queri ... ?Offset=99, I will check with Patient GET

Open Dental Version 21.1.52.0

1. I have Developer Key received from the vendor.relations@opendental.com. 2. I have created multiple keys by login to Developer portal https://api.opendental.com/portal/gwt/fhirportal.html. 3. I have assigned those keys to a customer by going to Setup -> Advanced Setup -> FHIR in the Open Dental pr...