Open Dental Forum

beacondental

Yes, please add it to development.

beacondental

Hello, I selected procedures from the Active Treatment Plan and attempted to create a Pre-Auth claim, but encountered the same error: "Cannot create a PreAuth claim with procedures from a saved treatment plan." I’ve attached the relevant screenshots. Could you please guide us on this matter? This is...

beacondental

Hello,
How would I be able to GET, POST, and PUT any items related to API Ortho Chart. I see in the API you can do it for normal chart here - https://opendental.com/site/apichartmodules.html

But, we are looking for Ortho Chart. Let us know.

beacondental

Good morning, You are attempting to use a procedure with an incorrect status. From our schema : PrecedureLog.ProcStatus.png As the error message indicates, you cannot use procedures that are of type TP. I am already checking the ProcStatus=1 in my query. Still, I see this error. Also, the ProcNum f...

beacondental

Thanks for the previous help.

One more question I have is, how can I find the Pri Ins Amount shown in the treatment plans module for an active treatment plan?

If you can help me with the query or the API, it will be very helpful.

Thanks in advance.

beacondental

Hello API Team, Can you please help me with this process, as are development has stalled unless we get clarity.

beacondental

[Forum moderators have deleted the contents of this post as it contained PHI.]

beacondental

Hi Team, I recently observed that for a patient when I checked the FamFinUrgNote in the Open Dental software, there was no Note present in the accounts module, but for the same patient when I tried getting the data using the GET API, the FamFinUrgNote was showing up. Ideally, it should be the same o...

beacondental

Hello, I tried posting a pre-auth claim using the Claim POST API, with the below Request Object, patNum=38663, procNums=[1704688], claimType='PreAuth', insSubNum=35025, patRelat='Self' The request object is as expected by the POST API, but I am getting the below error, 400 Bad Request: ""Cannot crea...

beacondental

Do you know roughly when this could be done? I recognize that you have huge list of changes to be done on the API, but we just wanted to plan accordingly on our end.

beacondental

Good afternoon, I would recommend a query to obtain this information. One of the advantages of this would be the ability to grab the information easily for list of patients. Calculations for populating the text boxes in your screenshot: AnnualMax - This is directly from the Benefit table (benefit.M...

beacondental

Hi Team,

In the ProcTPs API, there is no PUT API at present. I request you to please add this to your development list. I want to PUT discounts for patients on the pre-payments done.

Thanks.

beacondental

Hi Team,

Please provide me some guidance on how to fetch the balance amount from the treatment plan module of Open Dental software.

beacondental

Hi Team,

I tried to make a connection using PuTTY & also using FileZilla, but I am getting a network error saying "Network error: Connection refused"

What should be the problem here? Please help.

beacondental

Good Morning,

I checked it with my IT team and they told me that the user I am using has full permissions for the AtoZ folder in the dental office machine, still, I am getting the same error.

Please help.

beacondental

Hi Team,

While trying to update ProvNum in a procedurelog, I am getting this error from the API response,

""ProvNum is invalid. Provider is not associated with the claimproc's clinic.""

Can you please explain why I am getting this error & why I cannot update the ProvNum for a procedurelog?

Thanks,

beacondental

Hi Team, How can I download the sheet document into a PDF document? While trying to use the DownloadSftp I am getting this error, "Unable to save file. Connecting to ###.###.###.### has failed with user: ********\r\nNo connection could be made because the target machine actively refused it" Please s...

beacondental

I request you to please add the statement GET API to your development list, and also using that API, will I be able to generate a PDF file of that statement for a specific patient? I mean will that statement response contain the statement text, as we have receipt text in the payments GET?

beacondental

Hi Team,

Is there a way to update the "Prosthesis" field of a procedurelog? In the PUT API request body documented in the API specification, I can't see the prosthesis parameter, can you please let me know if the API is under development or if there is another way to do it?

Thanks.

beacondental

Hi Team,

Can you please guide me with an API or query on generating the latest statement document for a given patient number?

beacondental

Hi Team,

I have noticed that around 6:00 pm to 6:30 pm the eConnector automatically shuts off. This has happened many a time in the last one month. Please help me with this issue.

beacondental

Hello Open Dental,
How can I get a notice on which patient account number is merged and which patient accounts are not merged. I can get archived from Patient Status. But in Open Dental Archived and merged are separate.
https://opendental.com/site/apipatients.html

beacondental

Yes, our request is to PUT ProcessStatus to OnlineProcessed

beacondental

We want to make the PUT function for the online payment for Xcharge, Global Payments, etc.

beacondental

Also, can you add API Recalls POST function for the follow database fields "PatNum": 38, "DateDue": "2022-09-09", "DatePrevious": "0001-01-01", "RecallInterval": "6m1d", "RecallStatus": 142, "recallStatus": "Mailed Postcard", "Note": "", "IsDisabled": "false", "DateTStamp": "2021-07-21 10:05:47", "R...

beacondental

Can Open Dental API add a parameter for Payment PUT for "ProcessStatus": "OfficeProcessed", etc. Please let me know.

beacondental

I wanted to add a few things to API Recalls development list.
PUT fuction in API Recalls for:
"IsDisabled"
"DisableUntilBalance":
"DisableUntilDate":

Could you let me know if you can add this?

beacondental

Yes, I am aware of this. But, there is not way to do POST or PUT for Prosthesis and DateOriginalProsth. Is there a way you can add this to development?

beacondental

Some dental codes have initial or replacement reason attached to each code.
Under prosthesis replacement, you will see the selection here under Procedure edit.
https://opendental.com/manual/procedureedit.html
Is there a way to get initialg or replacement info in API (GET, PUT, and POST)?

beacondental

Hi Team,

I want to know how I can fetch a patient's outstanding balance. Please guide me on this.

beacondental

I got it. Thanks.

beacondental

Hi Team, I want to know, how I can get the Subscriber's Birthdate from the Patient Registration form. I tried using GET [/sheets] & [/sheetfield], but I got this response, { "SheetFieldNum": 17835860, "SheetNum": 126029, "FieldType": "StaticText", "FieldName": "", "FieldValue": "Subscriber’s Birthda...

beacondental

Well, I guess that is just the full list of pharmacy for the database in open dental. I was thinking how to GET and POST the pharamacy to the patient's acct so it populates on eRX.

beacondental

Is it possible to add this to your development list?

beacondental

Hello API Team,
Is there a way to get Pharmacy GET, PUT & POST. I tried to find it in API specification, but I could not. We would like to POST or PUT pharmacy information for patients. How can we do this?
Thanks,

beacondental

Hi Team, Today, while submitting an SQL query in the PUT API of open dental, it returned the below response message with an HTTP status code of 400, ""Error submitting query. Unable to connect to any of the specified MySQL hosts."" Please help me understand the issue & how I can prevent this from ha...

beacondental

Hi Team,

I have a requirement where I have to create treatment plan procedurelog but the condition is that it should not be attached to any appointment. Is it possible to have a treatment procedurelog with no appointment attached to it?

Please guide me on this.

beacondental

Hi Team,

Is there a possibility of setting a custom logtext for the API audit trails? if possible can you please provide some reference for the same?

beacondental

Hi Team, Suppose there's a wrongly entered benefit with a limitation of "3 times per benefit year" for a specific frequency under an insurance plan, and if I want to update it to "Every 3 Years" using benefit PUT API, how to do it? I tried it using the benefit PUT API, and provided below request obj...

beacondental

I would like to get "Fam Urgent Fin Note" which is in the Account module to have the ability to GET, POST, and DELETE. Where is this located in API Specfics.

beacondental

Hi Team, I am trying to POST below json object to the Claims API, { "patNum": 3062, "procNums": [1503483, 1503484, 1503485], "claimType": "P" } But I faced this error in response with a 400 Bad request, "ProcNum(s) 1503483, 1503484, 1503485 are invalid for this patient." Please explain what does thi...

beacondental

I did see the documenation here on this URL.
https://www.opendental.com/site/apiclaimprocs.html
ClaimProcs InsAdjust

But, I am looking for ClaimProcs GET InsAdjust (not the PUT or POST). How can I get this?

beacondental

Would the payment PUT be for Putting ProcessStatus as accepted online pending payment to processed payment. Right now, it says as pending and it can only be done manually.

beacondental

Hi team,

In the response model of GET /familymodules there are two fields planType & PlanType. can you please help me understand the possible values for both fields & how I can get 'PPO Fixed Benefit' value out of any of these two fields?

Thanks.

beacondental

Thank you for this. I did see this in beta version. Would it be possible to add IsDateProthEst POST and Prosthesis POST.

beacondental

Hello,
How can we get the GET and POST / PUT function for Adjustments to insurance benefits under the API protocol?
https://opendental.com/manual/adjinsbenefits.html

beacondental

If a patient is eligible for whitening or night guards, we would like to add this code into his treatment plan so the front desk/doctors and discuss the treatment plan and estimates. So, we want to add D9944 code to the patients treatment plan and then have the ability to put priorities and phase th...

beacondental

We need it associated with individual PATNUM accts. How can we do that?

beacondental

How can we POST TP codes for select PATNUMs?

beacondental

Hello Open Dental,
Can you enable a function for ProcTPs POST. We would like to add procedure codes to certain PATNUMs thru the API.
Thank you.

beacondental

Hello Team, I am using Patient's simple GET API: "GET /patients/Simple?LName=smi&FName=eter&Birthdate=1976-05-24" While incorporating this into my Java code, I encountered a scenario where there was a space in the first name. My code automatically converted that space into '%20', which resulted in i...

beacondental

Good morning, I am writing to inquire about the available options for filtering appointment data in the subscribed polling-seconds time. Currently, we are receiving a large number of appointments, including cases where a user simply double-clicks to view an appointment from the UI. I noticed there i...

beacondental

Hello team, We have reviewed the API subscription and event documentation and have successfully subscribed to receive appointments. However, we are receiving batches of 1000 appointments every 5 seconds, even when there is no change in the response. Could you please guide us on how to listen for eve...

beacondental

Hello API team. I am getting an error on our API request. It says “ : 400 Bad Request: ""Error. This is most likely a version issue. The version that the customer is using might be too old to support the API method used."" Do we need to upgrade our version?

beacondental

Is there a way to create Claim Finalize POST and PUT functions? It is helpful when a claim has $0 of estimated payment, and offices do not want to send a claim just to get a denial.

beacondental

A few questions regarding Claims Post. 1) Will Claims POST allow the API service to skip codes that are marked as "do not bill” codes or $0 procedure codes when posting a claim? 2) Will Claims POST posting and finalizing a claim whereby the total insurance estimate comes to $0 for insurance estimate...

beacondental

Its really automate ProcessStatus as accepted online pending payment to processed payment. Right now, it says as pending and it can only be done manually.

beacondental

Payment PUT would be for these fields.
"PayType": 69,
"payType": "Check",
"CheckNum": "12798",
"BankBranch": "20-6",
"PayNote": "",
"DateEntry": "2022-06-24",
"Receipt": "",
"PaymentSource": "None",
"ProcessStatus": "OfficeProcessed",
"IsCcCompleted": "false",

beacondental

Does the API allow Payment PUT to edit an existing payment that has been posted by the dental team. Is there a way to add this to the development list?
https://opendental.com/site/apipayments.html

beacondental

Does the API allow payment post via the local program link bridge? For example, if a practice uses Global Payments (Xcharge), then can the API user run a Payment POST using xcharge as the payment tool? Or does the payment POST will allow us to post if we have a third party connection for merchant pr...

beacondental

Is there a way to add the GET and POST function for Relationship to subscriber
https://opendental.com/site/apiinssubs.html

beacondental

Thank you for the message. Yes, we would like the enhancement feature for enhance our existing ClaimProcs GET to all the ClaimProcs by the 'ProcNum', and ProcedureLogs GET (Single)

beacondental

Also we want to update ClaimProc for that also the API doc do not have facility to get ClaimProc using 'ClaimProcNum'. It would be great if you could provide that also. If it requires all other data to update ClaimProc and not just single field.

Thank you.

beacondental

Good morning, We can add ProcedureLogs GET (Single) to our development list. It would return the single procedurelog associated with the specified procnum. However if your goal is to update an existing procedure you will only need the procnum, which it sounds like you already have. Can you please c...

beacondental

Hello API Team. We are looking to update a completed appt provider and amount with a GET, PUT and POST option. For example, if the dental office completed a code for Missed appt (D9986), then we would like to change the amount and provider on the completed account module. In the API documentation, w...

beacondental

Hello Team, I want your guidance on, what is the direct relationship between employee table and provider table. We tried thinking of a connection via email or ProvNum, but no success. Also tried via FName and LName, but it is again not fetching proper data if there present a preferred name in provid...

beacondental

Good morning,

Following your suggestions, I get the required data in 'emailmessage' table.

Thank you,

beacondental

Hello Team, We are trying to fetch data from commlogs, whether the an email is sent or not to patient. And we found that we are able to see the list in the patient-->account section, but the same logs are not visible if we try to fetch using user query or using GET-API ("/commlogs?PatNum="). In fact...

beacondental

Can you put in development for IsWebForm GET?

beacondental

Sending email notifications that a form has been received from the URL.

beacondental

Where in the API can we find out if a sheet was submitted via web or in-person? Some patients can click the patient forms and fill it out and some do it from eClipboard and some is done with front office submission by click Add in forms button. How can the API find out which method the form was subm...

beacondental

Is there a way to add GET histappointments, PUT or POST histappointments as well. I do recognize that we do can a short query on histappointments appts , but we can not change the histappointments status. Or, is there a way to change the histappointments confirmation status

beacondental

Yes, please add it to SheetFields GET

beacondental

For the MISC, I did find it in the database schema and it's under Reportable Name. But, how would I get this in the API Sheets? I do not see the reportable name in the API sheets. Or would it be in another API table?

beacondental

No, its fine to keep your list as you have it. I was just inquiring about POST function and whether that was feasible.

beacondental

Dear Team, I want to know where do we store the responses of all forms. Specifically I am looking for responses of form 'Release of Dental Records'. In the database I was able to get the date and the type of sheet a particular patient filled, But I need the information filled by patient in that form...

beacondental

Were you able to research the feasibility/workflow of adding procedurecodes/procedurelogs POST?

beacondental

That query is working fine if I run it in User Query window of Open Dental, but if I try running it in PUT ShortQuery method API then it is giving unauthorized as error. Good morning beacondental, Depending on how you are sending your API request, the application/program/client may have trouble par...

beacondental

That query is working fine if I run it in User Query window of Open Dental, but if I try running it in PUT ShortQuery method API then it is giving unauthorized as error.

beacondental

Under API query, I am getting an error saying 'Unauthorized' if I run Dentist KPI (QR41564) query in my local machine. We tried but has not worked for us. See attached error message. Please help and let me know the issue.

: Error message; image(2).png (23.62 KiB) Viewed 7239 times

beacondental

Hello Team, We are working on an automation email service for Summary of Records Released by Clinic. For that we need data of the field 'Reason for Releasing Records' submitted by a form(I have attached the form's image), we tried finding relation based on the table documentation provided by the tea...

beacondental

Hello Sir/Ma'am, I am working on an email service of 'Summary of records release by clinic' and use Query #43132, in that I need to find the reason why the patient is changing or moving to some other clinic e.g: 21711-Richard F. (Choosing another doctor) here the reason is choosing another doc. This...

beacondental

Wanted to follow up to see what the progress was for this function for Claim Post. Also, I did want to clarify my earlier question regarding DXC attachments. Currently, attachments are available to send via dental change in Open Dental. We would like to the ability to add attachments to the Claim Po...

beacondental

When we run a sample run on the local work stations, a 1800 line query takes about 2 minutes and 10 seconds. And even when we split the query or split the clinic to run only one clinic, it still does the same time.

beacondental

We have tried both ways for query that has 1800 lines of code and it gets timeout. Is it possible to request to do 120 seconds timeout on your end? This will give ample time for slightly complex queries.

beacondental

Yes, please do add Prosthesis (and probably DateOriginalProsth and IsDateProsthEst) to procedurelogs. We would need the GET and POST functions for all these date sets.

beacondental

I was looking to get the prosthesis replacement GET function in ProcTPs. I don't see it here in this link. Would it be somewhere else?
https://www.opendental.com/site/apiproctps.html

beacondental

Is there a way to run the income transfer manager thru the API short query?

beacondental

We would need the patients username. The use case it that many times patients can not get into their patient records and need to be emailed the usernames. The API will allow the username to be emailed.

beacondental

Hello Open Dental. Is there a way to GET the API for Username for open dental patient portal?

beacondental

I see that DiscountPlanSubs DELETE is a new feature. When reading the online explanation, I had a clarification. Is this DELETE function such that API users are dropping the discount plan? Or is it deleting the discount plans in List.

beacondental

Dear OpenDental Team, 1) Which Queries method are you trying to use: Queries POST or Queries PUT ShortQuery? -> We are using the PUT ShortQuery method API 2) Is the query you are running via the API and in Open Dental identical to the same database? -> Yes 3) How long does the query take to execute ...

beacondental

Hello API Team, We are trying to run API queries, but they are timing out after 60 seconds. Is there a way to change this as when we run the query in Open Dental, it works fine.

beacondental

Yes, we would need to download the EOB files and get the info on the files? Thank you.

beacondental

We would like to know if we could add to the development of GET and POST functions for Status History information like custom track status, claim error code, and notes. It is found here in open dental. https://opendental.com/manual/claimtabstatus.html

beacondental

Is there a way to GET an API call for the the stored files in the OpenDentImages\EOBs folder and eobattach table and claimpayment table?

beacondental

Is there a way to GET EOBs attached to primary or secondary claims. We were looking to get the files that were attached.

beacondental

In this method "ClaimProcs PUT InsAdjust", it does not allow DELETE and GET fuction.

beacondental

Yes, please add the GETs function for these request.

beacondental

As an additional request on API benefits tab, we would like to get the GET, POST, DELETE for Adjustments to Insurance benefits.
https://opendental.com/manual/adjinsbenefits.html

beacondental

For API security permission, it would be helpful to get all the items available in the security table. Items like user ID, employee associated, User groups, hidden or not hidden, provider link, dosespot ID, clinic attached, etc.
https://www.opendental.com/site/apisecurity.html

beacondental

Well, we often get front desk to create a new patient without checking prior history that we do have that patient on file. We would like to auto merge if the patient does match name/dob. There are lots of finished features in open dental that would be great to have in the API (whereby staff does not...

beacondental

Is it possible to have an API for patient merge capability. PUT OR POST merge for patient duplicates. This is located in Open Dental under Tools, Misc Tools, and then Patient merge.

beacondental

I am referring to DXC tab attachments. We wanted an API protocol for get and post attachments to DXC tab.

beacondental

It would be great if Claim PUT or Claim POST can have the ability to attach xrays, periocharts, doc narratives to the claim. We would like to the ability to edit attachments and add attachments.

beacondental

It would be great if Claim PUT or Claim POST can have the ability to attach items to the claim. Currently, attachments are available to send via dental change in Open Dental. We would like to the ability to edit attachments and add attachments.

beacondental

Yes, please do add GET etrans, GET etransmessagetext, and GET insverifies to your development list.

beacondental

I guess the question outstanding is the following: Is there a way for the api to ping "request benefits" to see if a plan is active and not get results that a staff member clicked "Now" When you put Getinsverity, then you are just getting the info a staff member manually modified by clicking now or ...

beacondental

Please do add GET etrans, GET etransmessagetext, and GET insverifies to your development list.

beacondental

Yes, we are talking about eBenefits under "Request benefits." Is there a way to do an API call and request results from the 271 response.
As well as, is there a way to GET and POST for eligibility date verified and benefits date verified.

beacondental

Within family module, open dental has "Request benefits" - is there a way to get an API for request benefits feature and retrieve results of the 271 normal response from Dentalxchange. This is to see if it's active coverage or not (and maybe benefit information) under 271 normal response. As of now,...

beacondental

What would you mean by "their database"

beacondental

Hello Open Dental, We understand that API documents (https://www.opendental.com/site/apidocuments.html) has the ability to get and post images saved to open dental images module. But, with program links, we link to Kodak xrays with Open Dental patnum ID. Is there a way thru the open dental API to ge...

beacondental

We are you wanting to know what confirmation statuses a single appointment has had over time.

beacondental

In open dental, users are allowed to create confirmation status for appt (e.g., unconfirmed, text, confirmed, READY, etc.). We would like to get the history of confirmation status thru the API. Is this possible?

beacondental

For Claims POST, it would be great if you could do the claim post for Claims and Preauth as well. So both options for postings.

beacondental

Is there a way to do database maintenance thru the API protocol. So, we can Get results from database maintenance and then post fixes as necessary.

beacondental

When you say "under development", then is it expected to be released in the next one month or so? Or longer?

beacondental

Hello Open Dental API Team,
Is it possible in open dental API to create a claim based on unsent claims. What exact link should I review to create a new claim (I think it should be the post function), but just wanted to clarify.

beacondental

Hello Open dental API, I wanted to see if your API allows download of payment receipts based on payment date. So, the sheet PDF would be extracted and saved on our hosting via the API. Also, would we be able to access the scanned/imported images folders in Imaging module of Open dental. Basically, b...

beacondental

Got it. We are on Version 22.3.48. We will upgrade once we get a stable version to use.

beacondental

Below API functionality not working. GET RefAttaches API functionality not working. it gives the error message "refattaches GET is not a valid method." with HTTP status code 400. GET /refattaches?PatNum= API functionality not working. it gives the error message "refattaches GET is not a valid method...

Search found 122 matches