Search found 277 matches

by justine
Thu Apr 10, 2025 11:19 am
Forum: API
Topic: API Chart Ortho
Replies: 3
Views: 3194

Re: API Chart Ortho

beacondental wrote:
Wed Apr 09, 2025 4:00 pm
Yes, please add it to development.
Hello beacondental,

I have added orthocharts to the API development list.

Thanks!
by justine
Thu Apr 10, 2025 11:18 am
Forum: API
Topic: Developer Portal Access
Replies: 1
Views: 671

Re: Developer Portal Access

Is there an api that could allow me to access my opendental developer portal to create or fetch API keys? Good morning aearl23, No, there is not an API endpoint for this. However, within the Developer Portal, you are free to create several unassigned API keys and export them. You are not charged fo...
by justine
Wed Apr 09, 2025 3:25 pm
Forum: API
Topic: API Chart Ortho
Replies: 3
Views: 3194

Re: API Chart Ortho

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. Hello beacondental, All chartmodules endpoints are GETs on...
by justine
Wed Apr 09, 2025 3:11 pm
Forum: API
Topic: Issue with Posting PreAuth Claim
Replies: 8
Views: 6240

Re: Issue with Posting PreAuth Claim

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 i...
by justine
Thu Apr 03, 2025 3:29 pm
Forum: API
Topic: EOB Delete
Replies: 1
Views: 806

Re: EOB Delete

aearl23 wrote:
Thu Apr 03, 2025 2:23 pm
Is there a method that would allow me to delete an attached EOB from the system?
Hello aearl23,

There is currently no way to delete an EobAttaches via the API.

Thanks!
by justine
Mon Mar 31, 2025 9:30 am
Forum: API
Topic: URGENT Issue with OpenDental ClaimTracking API: "claimtrackings is not a valid resource"
Replies: 1
Views: 1145

Re: URGENT Issue with OpenDental ClaimTracking API: "claimtrackings is not a valid resource"

Hi everyone, I am trying to use the OpenDental ClaimTracking API to create new claims. The API endpoint I am using is: Endpoint: https://api.opendental.com/api/v1/claimtrackings Method: POST Payload: { "ClaimNum": "", "Note": "", "TrackingDefNum": "" } According to the OpenDental API documentation ...
by justine
Tue Mar 25, 2025 9:10 am
Forum: API
Topic: Clarification on Provider and Clinic Relationship in Open Dental
Replies: 3
Views: 1205

Re: Clarification on Provider and Clinic Relationship in Open Dental

Thank you for your prompt response and the provided details. To clarify, since there is no direct association between a Provider and a specific Clinic, does this imply that Providers within a single Open Dental instance can be linked to patients and appointments across multiple Clinics? In essence,...
by justine
Mon Mar 24, 2025 10:56 am
Forum: API
Topic: Clarification on Provider and Clinic Relationship in Open Dental
Replies: 3
Views: 1205

Re: Clarification on Provider and Clinic Relationship in Open Dental

Hello, We are integrating Open Dental with an external system and are currently working with the Provider API. Upon reviewing both the API response and the database schema, we could not find any column or property that directly links a Provider to a ClinicNum. Could you please confirm: 1. Is there ...
by justine
Fri Mar 21, 2025 8:45 am
Forum: API
Topic: API Request | subscriptions.WatchTable == 'Schedule'
Replies: 4
Views: 4863

Re: API Request | subscriptions.WatchTable == 'Schedule'

API database events fire whenever something changed in the table you are subscribed to. This includes a new row, or an updated row. However, it is impossible to return a row that has been deleted. We cannot add schedule delete. The schedule table does not contain an operatory field. We are not addi...
by justine
Thu Mar 20, 2025 2:59 pm
Forum: API
Topic: API Request | subscriptions.WatchTable == 'Schedule'
Replies: 4
Views: 4863

Re: API Request | subscriptions.WatchTable == 'Schedule'

Hello. re: Open Dental v. 24.4.24 Question. Can you please confirm which db events events.Schedule is listening for? As far as I can tell it's only ADD. Two requests 1. Please add the operatories string array to the event. Please also see my notes regarding type inconsistencies. { "ScheduleNum": "2...
by justine
Mon Mar 17, 2025 12:19 pm
Forum: API
Topic: Request: Allow ProcedureLogs PUT/POST to use ProcStatus "R" for referred
Replies: 7
Views: 146130

Re: Request: Allow ProcedureLogs PUT/POST to use ProcStatus "R" for referred

Good morning notsosuperman1, This feature request to add the ability to set/update procedurelogs.ProcStatus to "Cn", "EC", or "R" is currently in development. I estimate 2-3 weeks before it is completed. Thanks! Just checking if there’s any update on this. I’m looking to finish up a project using L...
by justine
Wed Mar 12, 2025 8:27 am
Forum: API
Topic: Best Way to Retrieve Deleted Patients via API
Replies: 3
Views: 14643

Re: Best Way to Retrieve Deleted Patients via API

Thank you for the prompt response and confirmation regarding retrieving deleted patients using the PUT ShortQuery API. We now have another query: We attempted to delete appointment records using the PUT ShortQuery API with the following query: { "SqlCommand": "DELETE FROM appointment WHERE AptNum =...
by justine
Sat Mar 08, 2025 4:25 pm
Forum: API
Topic: Request to Filter by ProcedureLog in /accountmodules endpoint
Replies: 1
Views: 1376

Re: Request to Filter by ProcedureLog in /accountmodules endpoint

Hello, I'm reaching out to see if I can request a development enhancement to the /accountmodules endpoint where an additional Query Param could be added to filter results by the "ProcedureLog" key. Currently, our product uses this endpoint to retrieve open balances on charges for patients to submit...
by justine
Sat Mar 08, 2025 3:56 pm
Forum: API
Topic: API Request: Addition of UserName Field in ClaimTrackings POST/PUT APIs
Replies: 1
Views: 1387

Re: API Request: Addition of UserName Field in ClaimTrackings POST/PUT APIs

Hello, We have been using the ClaimTrackings POST/PUT APIs, https://www.opendental.com/site/apiclaimtrackings.html but we have encountered an issue. When adding a new claim tracking status through the API, the username field shows as empty, creating inconsistencies for users. This is because there ...
by justine
Sat Mar 08, 2025 3:34 pm
Forum: API
Topic: API Request | Post/Put Claims - allow InsSubNum2 to be set to 0 when ClaimType == P || S
Replies: 2
Views: 1597

Re: API Request | Post/Put Claims - allow InsSubNum2 to be set to 0 when ClaimType == P || S

Effectively mimicking the behavior within Open Dental that allows a user to open a claim and set the other insurance plan to 'None'. Good afternoon rinse-dental, It is currently possible to set InsSubNum and InsSubNum2 via the claims POST endpoint. I have added evaluating the feasibility of adding ...
by justine
Tue Mar 04, 2025 2:12 pm
Forum: API
Topic: EOBAttaches POST/ SFTP Upload
Replies: 6
Views: 3213

Re: EOBAttaches POST/ SFTP Upload

I am using the sftp address from an AWS sftp server. I have been using the Upload SFTP for single claims without a problem, but when I do so with a batch payment, I get the error Here is the error: OpenDental API error: 400 - "Error. This is most likely a version issue. The version that the custome...
by justine
Mon Feb 24, 2025 9:43 am
Forum: API
Topic: UiEventType list?
Replies: 2
Views: 4030

Re: UiEventType list?

irfan wrote:
Mon Feb 24, 2025 9:39 am
Is "PatientSelected" the only available UiEventType ? I can find any documentation showing a more complete list, and every example uses PatientSelected. Thank you.

-Irfan
Good morning irfan,

Yes, PatientSelected is currently the only UI Event.

Thanks!
by justine
Mon Feb 24, 2025 9:37 am
Forum: API
Topic: Pay plan
Replies: 1
Views: 2152

Re: Pay plan

We would like to get payment information for payment plans and if they failed. How can I get it? Specifically, I mean the cc recurring charges and GET functions for failed CC recurring. https://opendental.com/manual243/recurringcharges.html Good morning akjain1@gmail.com, This information is stored...
by justine
Mon Feb 24, 2025 9:32 am
Forum: API
Topic: Updating Operatories Based on Provider Availability & Scheduling Behavior
Replies: 3
Views: 3300

Re: Updating Operatories Based on Provider Availability & Scheduling Behavior

I have a query regarding the Schedules GET API. How is the SchedType determined? According to the data dictionary, the following types exist: - 0 = Practice - 1 = Provider - 2 = Blockout - 3 = Employee When and for what scenarios are these types used? I tested adding a schedule for a specific opera...
by justine
Mon Feb 24, 2025 9:19 am
Forum: API
Topic: Posting pay splits
Replies: 1
Views: 2679

Re: Posting pay splits

Hi, I am a developer and I want to post pay splits in Open Dental. The purpose is to map a particular chunk of total payment amount to a specific procedure. Is there an API to do that? If not, are there any other ways to achieve that? Good morning abhishekcs028, There is no paysplits POST. However,...
by justine
Fri Feb 21, 2025 3:30 pm
Forum: Main Forum
Topic: EOB question
Replies: 1
Views: 1578

Re: EOB question

I have data extracted out of EOB from a backend system and I would like to post this information to the Open Dental database. Which APIs should I be using? If there are multiple APIs then please let me know. I have the following fields from the backend system InsuranceCompanyName InsuranceCompanyAd...
by justine
Fri Feb 21, 2025 9:21 am
Forum: API
Topic: EOBAttaches POST/ SFTP Upload
Replies: 6
Views: 3213

Re: EOBAttaches POST/ SFTP Upload

Is there a way where an sftp upload can be sent as a batch process to upload the same file for multiple patients? Hello aearl23, The EobAttaches POST UploadSftp endpoint is only for claim payment EOB attachments, not for general patient file uploads. If you're trying to upload documents for multipl...
by justine
Fri Feb 21, 2025 8:21 am
Forum: API
Topic: Best Way to Retrieve Deleted Patients via API
Replies: 3
Views: 14643

Re: Best Way to Retrieve Deleted Patients via API

We are looking for the best way to retrieve deleted patients using Open Dental’s API. Based on our findings, Open Dental does not provide a direct API to get deleted patients, as the GET Patients API does not return records with a "Deleted" status. However, we found that using the Queries PUT Short...
by justine
Thu Feb 20, 2025 9:16 am
Forum: API
Topic: Patient search improvement
Replies: 5
Views: 5340

Re: Patient search improvement

I am trying to do a request such as: curl https://api.opendental.com/api/v1/patients?LName=Smith&FNname=John where the last name and first name are used together. Is this possible? Hello aearl23, Your request example uses the param 'FNname' and should use 'FName'. The following example worked for m...
by justine
Thu Feb 13, 2025 1:59 pm
Forum: API
Topic: API Request - ScheduleDeleted Subscription/Event
Replies: 1
Views: 3062

Re: API Request - ScheduleDeleted Subscription/Event

Requesting the ability to use Subscriptions on ScheduleDeleted similar to how it is done for AppointmentDeleted. We would like to be notified when a blockout schedule record is deleted. Hello rcoble, Unfortunately we cannot add scheduleDeleted or similar to the subscriptions endpoint. The reason th...
by justine
Thu Feb 13, 2025 10:57 am
Forum: API
Topic: EOBAttachesNum
Replies: 1
Views: 2829

Re: EOBAttachesNum

If I am creating a new claim and want to retrieve the EOBAttachesNum, how can I do so without having an EOB currently attached? For example, I am making a GET request /eobattaches?ClaimPaymentNum={correct num} but only see an empty [] message. I will be needing the EOBattachesNum to then upload a f...
by justine
Thu Feb 13, 2025 10:42 am
Forum: API
Topic: Patient search improvement
Replies: 5
Views: 5340

Re: Patient search improvement

What is the required syntax for such ra equest? I am trying a request formatted as : curl -i https://api.opendental.com/api/v1/patients?LName={PHI}&FName={PHI} -H "Authorization: {key}/{key}" and get this message : "You are missing an Authorization header."'FName' is not recognized as an internal o...
by justine
Mon Feb 03, 2025 12:09 pm
Forum: API
Topic: API Request DELETE treatplans
Replies: 2
Views: 4046

Re: API Request DELETE treatplans

rinse-dental wrote:
Mon Feb 03, 2025 10:18 am
By TreatPlanNum

thank you
Good afternoon rinse-dental,

I have added the ability to delete a treatplan by PK to our development list.

Thanks!
by justine
Thu Jan 30, 2025 12:44 pm
Forum: API
Topic: Documents/DownloadSftp API
Replies: 4
Views: 3182

Re: Documents/DownloadSftp API

aearl23 wrote:
Thu Jan 30, 2025 12:40 pm
Yes, the user has write permissions, but does the API support SSH authentication or only password?
Hello aearl23,

POST documents DownloadSftp documentation clearly states that SftpUsername and SftpPassword fields are required.

Thanks!
by justine
Thu Jan 30, 2025 12:29 pm
Forum: API
Topic: Documents/DownloadSftp API
Replies: 4
Views: 3182

Re: Documents/DownloadSftp API

I am on version 24.3.43 and I got this error: Error in POST request to documents/DownloadSftp: OpenDental API error: 400 - "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." The API specs tell me that the POST Downlo...
by justine
Tue Jan 28, 2025 3:09 pm
Forum: API
Topic: API Request -- Documents Import?
Replies: 2
Views: 2356

Re: API Request -- Documents Import?

If I am overlooking something please forgive me and redirect. Is there a chance we can get an import/refresh function of the Documents in the API? There are so many ways of placing something int the A-to-Z folder but nothing currently in place to trigger Open Dental to index them until someone clic...
by justine
Wed Jan 22, 2025 12:19 pm
Forum: API
Topic: API Request -- InsPlans
Replies: 2
Views: 18531

Re: API Request -- InsPlans

I'm hoping this is a quick and easy one. Looking to get IsMedical added as an option in /insplans on PUT. Right now we can see that it is true/false with the /familymodules but we are unable to update it. You can send it in to the existing endpoint but it is ignored. Doc Link: https://www.opendenta...
by justine
Tue Jan 21, 2025 11:16 am
Forum: API
Topic: API Request | ProcedureLogs GET (multiple) by ProcStatus, ProcCode
Replies: 1
Views: 2734

Re: API Request | ProcedureLogs GET (multiple) by ProcStatus, ProcCode

Hello - Requesting you add the following optional parameters to the ProcedureLogs GET (multiple) endpoint: Param: ProcStatus (array) - example ['TP', 'C'] Param: ProcCode (array) - example ['D1110', 'D0120'] alternatively, array of CodeNums Thank you! Hello rinse-dental, I have added the ability to...
by justine
Tue Jan 21, 2025 9:15 am
Forum: API
Topic: Is there an api endpoint for daily production and income
Replies: 1
Views: 3052

Re: Is there an api endpoint for daily production and income

AndyJordan wrote:
Sun Jan 19, 2025 3:38 pm
Api endpoint for production and income
Hello AndyJordan,

Please see Reports FinanceCharges or run a custom production query using Queries ShortQuery.

Thanks!
by justine
Mon Jan 20, 2025 11:11 am
Forum: API
Topic: Can't search for "Carole"
Replies: 8
Views: 18296

Re: Can't search for "Carole"

graham_mueller wrote:
Mon Jan 20, 2025 11:04 am
An additional random word check that's failing-

Code: Select all

Query cannot contain "SLOW".
When searching for, eg, John Oslow.
Thanks for the heads up, this ShortQuery endpoint enhancement is coming up next. I have added 'John Oslow' to the job/unit test requirements.

Thanks!
by justine
Mon Jan 20, 2025 10:43 am
Forum: API
Topic: pop-up -- disable or update?
Replies: 2
Views: 3330

Re: pop-up -- disable or update?

We have pop-ups with Create and Get is there any change we can get an update with PUT to allow us to update them? Including the disable? Current: https://www.opendental.com/site/apipopups.html Proposed: PUT /popups?PopupNum=10 { "Description": "Verify cell phone number is accurate.", "PopupLevel": ...
by justine
Mon Jan 20, 2025 10:31 am
Forum: API
Topic: Cannot "Complete" procedures (bug?)
Replies: 2
Views: 3265

Re: Cannot "Complete" procedures (bug?)

Hello, I'm trying to complete an appointment, all its attached procedures, and submit a claim. If I set the appointment as complete first, and then try to set all the procedures as complete, I (incorrectly) get this error message: "ProcStatus may only be set to Complete (C) when attached to an appo...
by justine
Mon Dec 30, 2024 11:01 am
Forum: API
Topic: MedicaidID on Patient POST and PUT?
Replies: 4
Views: 4864

Re: MedicaidID on Patient POST and PUT?

I always try to look before I ask and this one appears to been open since 2021 and only GET was added into production. -- https://www.opendentalsoft.com:8085/forum/viewtopic.php?f=9&t=7766&p=34501&hilit=MedicaidID#p34501 Good morning laborspy, I really appreciate you searching the forums for answer...
by justine
Mon Dec 30, 2024 9:47 am
Forum: API
Topic: Golden age dental care API request
Replies: 8
Views: 10664

Re: Golden age dental care API request

laborspy wrote:
Mon Dec 30, 2024 9:22 am
+1 ... I'd also like this functionality as well.
Hello laborspy,

I replied to your other post. This job is currently being worked on. We will reply to this thread when it is complete.

Thanks!
by justine
Mon Dec 30, 2024 9:43 am
Forum: API
Topic: MedicaidID on Patient POST and PUT?
Replies: 4
Views: 4864

Re: MedicaidID on Patient POST and PUT?

There any chance MedicaidID can be added to the POST and PUT for the patients API? I see we can GET, and it is a response from the creation on POST but you can never touch that field via API. I've seen requests back several years but no updates and can confirm it is still missing today in Dec 2024....
by justine
Mon Dec 30, 2024 9:33 am
Forum: API
Topic: Get Simple for schedules
Replies: 2
Views: 3823

Re: Get Simple for schedules

For all the tables, that support last edited values, there is a way to retrieve data that has been edited/added after a certain time; "get simple" for patients and "DateTStamp" param for appointments. However this is not the case with Schedules. Is there any way to get all the schedules that has be...
by justine
Fri Dec 27, 2024 1:39 pm
Forum: API
Topic: BlueBook Selection
Replies: 1
Views: 3617

Re: BlueBook Selection

Hello all, Hope you had a wonderful holiday! I wanted to request a quick feature. At this point, with the insplan API I am only able to identify whether or not to use blue book. Is there a way to also be able to select whcih manual blue book to select? Thank you very much in advance. Omar Good afte...
by justine
Mon Dec 23, 2024 10:39 am
Forum: API
Topic: Request: [POST] Audit Trail
Replies: 10
Views: 25689

Re: Request: [POST] Audit Trail

Hello, just wanted to bump a need for some additional context again. We had a situation today where a procedure was booked via our application as a new patient, but for a two year old. We explicitly disallow child sign up right now, so there was concern at the clinic as to how this happened. Unfort...
by justine
Mon Dec 23, 2024 10:28 am
Forum: API
Topic: Golden age dental care API request
Replies: 8
Views: 10664

Re: Golden age dental care API request

Hi Justine, I wanted to kindly check in regarding the MedicaidID field issue. Has there been any progress or updates from the development team on enabling this field to save correctly? Thank you so much for your time and assistance! Hello rober2092, API feature requests are processed in the order t...
by justine
Wed Dec 11, 2024 9:21 am
Forum: API
Topic: Golden age dental care API request
Replies: 8
Views: 10664

Re: Golden age dental care API request

We've identified that when creating a patient through the API (Patient POST), the MedicaidID value is included in our payload but isn't being saved in OpenDental. Interestingly, all other fields in the same payload are saving correctly. We've tested this through Postman, and while the request compl...
by justine
Wed Dec 11, 2024 9:15 am
Forum: API
Topic: How to fetch Blockout types from OD
Replies: 1
Views: 3469

Re: How to fetch Blockout types from OD

When i am trying to fetch definitions, blockout types don't show up there. The blockouts however, do show up in the schedules api, but i can't distinguish between whether appointments should be allowed in that blockout type or not. Is there a way i could get all blockout types and whether appointme...
by justine
Mon Dec 09, 2024 9:43 am
Forum: API
Topic: Statement generation for patient
Replies: 9
Views: 23566

Re: Statement generation for patient

Thanks for answering. Just to clarify - what should I do when API returns statement entity with DocNum = 0? Previously it was mentioned that there is a way to generate a PDF for such a statement but I can't find how. If a pdf was not already generated in Open Dental (i.e. the statement.DocNum==0), ...
by justine
Sat Dec 07, 2024 2:30 pm
Forum: API
Topic: Statement generation for patient
Replies: 9
Views: 23566

Re: Statement generation for patient

If a pdf was not already generated in Open Dental (i.e. the statement.DocNum==0), then you can generate your own statement pdf using the returned data. Hey, Guys How can I generate a pdf statement in order to be able to download it here if it exists? Or just generate the latest statement pdf for a ...
by justine
Tue Dec 03, 2024 11:40 am
Forum: API
Topic: Deleted patient
Replies: 4
Views: 5801

Re: Deleted patient

We pull in patient demographic data via GET /patients/Simple however I can't figure out how we can see if a patient has been deleted. We have some clients who do occasionally delete patients (accidental duplicates usually) but we end up with two records that appear 'live' because I'm not seeing any...
by justine
Tue Dec 03, 2024 9:56 am
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 18
Views: 35201

Re: How to retrieve Open Dental's calculated insurance and patient portions?

Hi there - We've found that patient estimates for recall appointments booked online or via the Book Recall feature within Open Dental are wrong a majority of the time. This is a result of the issues I called out earlier in the thread or because their appointment in 6 months + 1 day and we're calcul...
by justine
Tue Dec 03, 2024 8:56 am
Forum: API
Topic: Method to Retrieve OD Version
Replies: 2
Views: 4060

Re: Method to Retrieve OD Version

Hello all, as mentioned in a previous thread , I've reached the point where some of my clients have migrated to version 24 while some remain on version 23, breaking my queries. Given there is no halfway step, I need to maintain two separate queries based on which version clients are running, but I ...
by justine
Fri Nov 08, 2024 3:37 pm
Forum: API
Topic: Question | ProcTPs and 'Estimate as of'
Replies: 4
Views: 10757

Re: Question | ProcTPs and 'Estimate as of'

I'm going to research this for you, but if I recall correctly, these estimates are extremely complex and calculated in memory. Sorry if my question wasn't clear. I don't need the calculations. I'm referring to the ProcTP and TreatPlan tables. ProcTP already stores FeeAmt, PriInsAmt, PatAmt, Discoun...
by justine
Wed Nov 06, 2024 2:54 pm
Forum: API
Topic: API Event/Subscription - Tooth initial table support
Replies: 10
Views: 17219

Re: API Event/Subscription - Tooth initial table support

Hi, Thanks again for your response. I am wondering how to edit and save tooth initial information via the Desktop App so that I can use the GET endpoint to retrieve this information. At the moment I just get a 404 Not Found when trying to GET /toothinitials. I tried to play with the ToothChart from...
by justine
Wed Nov 06, 2024 2:39 pm
Forum: API
Topic: CodeGroup AgeLimit Issue
Replies: 2
Views: 5240

Re: CodeGroup AgeLimit Issue

Hello, I hope all is well with you. We have been getting an error when trying to add limitations on a custom created CodeGroup, which has AgeLimit enabled. image_720.png **Payload for age limit (not working) { "PlanNum": 101, "CodeGroupNum":14, "BenefitType": "Limitations", "TimePeriod": "None", "Q...
by justine
Wed Nov 06, 2024 9:59 am
Forum: API
Topic: PayPlans POST NumberOfPayments
Replies: 4
Views: 6519

Re: PayPlans POST NumberOfPayments

When creating a dynamic payment plan, despite providing the NumberOfPayments, it's being set to 0. Below is an example request/response from my test environment (updated to the latest stable version as of today). This came up because one of our clients noticed it and I can't figure out what we migh...
by justine
Mon Nov 04, 2024 9:47 am
Forum: API
Topic: API Event/Subscription - Tooth initial table support
Replies: 10
Views: 17219

Re: API Event/Subscription - Tooth initial table support

Up! Thanks Hello avie, We can add the ability to subscribe to the toothinitial table via the API. However, this does not mean that any and every table can be, or will be, subscribable. (Some customers have 100's of clinics.) The API is not intended to keep a 1:1 sync of every customer's database. I...
by justine
Fri Nov 01, 2024 3:53 pm
Forum: API
Topic: Question | ProcTPs and 'Estimate as of'
Replies: 4
Views: 10757

Re: Question | ProcTPs and 'Estimate as of'

I noticed Open Dental saves ProcTPs with PriInsAmt and SecInsAmt calculated using the 'Estimates as of' date. Is the 'Estimates as of' date stored in the DB and available via another API? For example, patient has a treatment plan that will exceed max or hit frequency limitations. Treatment plan #1 ...
by justine
Fri Nov 01, 2024 3:46 pm
Forum: API
Topic: Tasks API feature requests
Replies: 6
Views: 10653

Re: Tasks API feature requests

Follow up on my previous thread about the Tasks API . Thanks again for adding PUT capability! Use Case: my client's goal is to sync OpenDental Tasks & TaskNotes that clinical staff use with an external ticketing system for remote support staff. We'd like to request some new features for the Tasks A...
by justine
Fri Nov 01, 2024 3:27 pm
Forum: API
Topic: Put for the oduser table
Replies: 13
Views: 20895

Re: Put for the oduser table

Good afternoon Justine, Me again, can we add UserGroupNum to the GET request as well? Purpose would be to get which group(s) a user is currently in. Thanks! rgibbons Hello rgibbons, I believe what you are looking for is UserGroupAttaches GET . Supply a UserNum and that endpoint returns the usergrou...
by justine
Fri Oct 25, 2024 3:21 pm
Forum: API
Topic: API Request | ProcedureLogs GET (multiple) - search by PlannedAptNum
Replies: 4
Views: 10302

Re: API Request | ProcedureLogs GET (multiple) - search by PlannedAptNum

Requesting the ability to search by 'PlannedAptNum' so we can fetch appointment details for planned appointments. Thank you. Good afternoon rinse-dental, I have added the ability to filter by procedurelog.PlannedAptNum to our development list. We will reply to this thread when the request is comple...
by justine
Fri Oct 25, 2024 3:07 pm
Forum: API
Topic: PUT API for ProcTPs
Replies: 4
Views: 10747

Re: PUT API for ProcTPs

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. Good afternoon beacondental, API requests are processed in the order they are received. We will update this thread when the request i...
by justine
Fri Oct 25, 2024 3:05 pm
Forum: API
Topic: Put for the oduser table
Replies: 13
Views: 20895

Re: Put for the oduser table

rgibbons wrote:
Wed Oct 23, 2024 6:34 pm
Thanks justine! Any possibility of these get done before mid-December?
Good afternoon rgibbons,

API feature requests are processed in the order they are received. We will update this thread when the request is complete.

Thanks!
by justine
Fri Oct 25, 2024 3:00 pm
Forum: API
Topic: Getting patient's last verified eligibility
Replies: 4
Views: 12401

Re: Getting patient's last verified eligibility

Thank you! Do you have any timeline on development? Good afternoon od12345, Enhancing insverifies GET (multiple) to filter by FKey value, is currently on our development list. We will reply to this thread when it is complete. In the meantime, you can use insverifies GET with a VerifyType of Patient...
by justine
Wed Oct 23, 2024 2:16 pm
Forum: API
Topic: Put for the oduser table
Replies: 13
Views: 20895

Re: Put for the oduser table

Hello again, Another part of this request, can you also add the ability to "check" the box with an API call (both PUT and POST) so that it prompts the users to reset their password on login? "Require Password Reset: Check to prompt the user to reset their password upon logging in." Good afternoon r...
by justine
Wed Oct 23, 2024 2:15 pm
Forum: API
Topic: ODUSER Create/put update request
Replies: 2
Views: 7374

Re: ODUSER Create/put update request

rdillman wrote:
Wed Oct 23, 2024 12:33 pm
Wondering,

Is it currently possible for Create/Put API commands to force password reset on first login?
If not is it on the road map?

Thanks for your time!!
Good afternoon rdillman,

I have added the ability to set userod.IsPasswordResetRequired to the API development list.

Thanks!
by justine
Wed Oct 23, 2024 10:11 am
Forum: API
Topic: Fetching UCR Fee Schedule using API
Replies: 2
Views: 7839

Re: Fetching UCR Fee Schedule using API

abhishekcs028 wrote:
Tue Oct 22, 2024 10:14 am
Hi,

I am trying to fetch the office UCR fee Schedule using APIs. I have pms_id and location id with me.
How can I fetch that?

Thanks
Good morning abhishekcs028,

I believe the resource you are after is FeeScheds GET. See Fee Schedules for more information.

Thanks!
by justine
Tue Oct 15, 2024 10:34 am
Forum: API
Topic: Clarification on DateTStamp Filtering and API Behavior Across Multiple Open Dental Modules
Replies: 5
Views: 9139

Re: Clarification on DateTStamp Filtering and API Behavior Across Multiple Open Dental Modules

Thank you for your insights and clarifications regarding my previous questions. I have some additional inquiries based on the responses I received: ProcedureLogs Module 1. GET /procedurelogs Response: In the response from the `GET /procedurelogs` endpoint, I noticed the fields "Priority" and "prior...
by justine
Mon Oct 14, 2024 10:27 am
Forum: API
Topic: Clarification on DateTStamp Filtering and API Behavior Across Multiple Open Dental Modules
Replies: 5
Views: 9139

Re: Clarification on DateTStamp Filtering and API Behavior Across Multiple Open Dental Modules

Thank you for your detailed response regarding my questions about the Open Dental API modules. I appreciate the clarifications provided. I have a few follow-up questions based on your insights: FamilyModule 1. GET Insurance Response Tables: Could you specify the names of the tables that generate th...
by justine
Fri Oct 11, 2024 12:57 pm
Forum: API
Topic: Put for the oduser table
Replies: 13
Views: 20895

Re: Put for the oduser table

Hello there, I work with rdillman and we have another small addition that we would like to add to this PUT method. When hiding the users, we tend to like to change their group as well to a group that has no rights, however this is especially important for some of our groups that have the Setup perm...
by justine
Fri Oct 11, 2024 12:51 pm
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 18
Views: 35201

Re: How to retrieve Open Dental's calculated insurance and patient portions?

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...
by justine
Fri Oct 11, 2024 12:13 pm
Forum: API
Topic: Clarification on DateTStamp Filtering and API Behavior Across Multiple Open Dental Modules
Replies: 5
Views: 9139

Re: Clarification on DateTStamp Filtering and API Behavior Across Multiple Open Dental Modules

I'm working with various Open Dental API modules to sync data, and I have several questions regarding the handling of specific parameters like `DateTStamp` and the behavior of certain endpoints. Below are my questions for different modules: FamilyModule 1. Tables used in GET Insurance response: Wha...
by justine
Fri Oct 11, 2024 9:41 am
Forum: API
Topic: PUT API for ProcTPs
Replies: 4
Views: 10747

Re: PUT API for ProcTPs

beacondental wrote:
Thu Oct 10, 2024 3:27 am
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.
Hello beacondental,

ProcTPs PUT has been added to our development list.

Thanks!
by justine
Mon Oct 07, 2024 9:53 am
Forum: API
Topic: payments API: No procNums in Payments response
Replies: 1
Views: 6412

Re: payments API: No procNums in Payments response

Hi Regarding payments API, For payments POST, there is a support to post payment with procNums. But on GET Payments, we don't receive the procNums as part of payments response. Seems the GET payments doesn't have support to return procNums? How can i retrieve the payment link to the procs. Regards ...
by justine
Tue Sep 17, 2024 10:01 am
Forum: API
Topic: Updating Orthodontic Maximum Not Reflecting in OpenDental UI
Replies: 1
Views: 7082

Re: Updating Orthodontic Maximum Not Reflecting in OpenDental UI

We're using the /benefits API to update orthodontic information, including the lifetime maximum, but it's not appearing in the expected field in the OpenDental UI. Here's our current code: console.log('🦷 Updating orthodontic information...'); try { const orthoCovCat:any = coverageCategoryMapping['O...
by justine
Tue Sep 17, 2024 9:38 am
Forum: API
Topic: API for Uploading Patient Eligibility Verification PDF
Replies: 1
Views: 6816

Re: API for Uploading Patient Eligibility Verification PDF

Looking for guidance on how to upload a patient's eligibility verification as a PDF to OpenDental via API. Key questions: Which API endpoint should I use for this upload? How can I ensure the PDF is properly attached to the patient's record? Are there any specific parameters or data formats require...
by justine
Wed Sep 11, 2024 7:52 am
Forum: API
Topic: Error in procedurelog API
Replies: 1
Views: 10777

Re: Error in procedurelog API

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, ...
by justine
Fri Sep 06, 2024 12:30 pm
Forum: API
Topic: Patient portion owed with appointment
Replies: 1
Views: 12535

Re: Patient portion owed with appointment

We have a feature showing the practice's appointments for the day. I'm looking to show the amount the patient owes for that appointment and it looks like I need to make quite a few calls to get the data I'm looking for. Want to check whether that's correct or if there's a more efficient way to get ...
by justine
Thu Aug 29, 2024 7:30 am
Forum: API
Topic: Planned Procedure Status
Replies: 9
Views: 24679

Re: Planned Procedure Status

If I'm understanding you (and the data I'm seeing), it appears that the appointments that are linked to the PlannedAppointments do not ever have a NextAptNum, but there are appointments that are linked to *those* appointments via the NextAptNum. So if PlannedAppointment has Appointment 1 linked to ...
by justine
Wed Aug 28, 2024 11:15 am
Forum: API
Topic: API Request | Referrals GET - Add contact information
Replies: 2
Views: 15127

Re: API Request | Referrals GET - Add contact information

rinse-dental wrote:
Wed Aug 28, 2024 11:03 am
Please add address, telephone and email information to the Referrals GET (single and multiple) API. Thank you.
Good morning rinse-dental,

We can enhance referrals GET (single) and GET (multiple) to return address, telephone and email fields.

I have added this to our development list.

Thanks!
by justine
Sat Aug 24, 2024 1:52 pm
Forum: API
Topic: Request: [POST] Audit Trail
Replies: 10
Views: 25689

Re: Request: [POST] Audit Trail

Unfortunately the group that told me that the Break didn't log was apparently mistaken, I've tried now and see the same. I looked at the security log table now, and it is what I thought, just a message and a patient link more or less. Their initial complaint was the lack of detail in the messages. ...
by justine
Sat Aug 24, 2024 1:51 pm
Forum: API
Topic: Billing Estimate Endpoints
Replies: 8
Views: 22856

Re: Billing Estimate Endpoints

Ok, spend a bit more time this morning. From the API docs, it appears ProcTP is only for *saved* / inactive plans, which is why I can't see them for the patient I'm looking at. Is there a way for *active* plans to see the cost information from my screenshot? I've not been able to find an endpoint t...
by justine
Thu Aug 22, 2024 8:59 am
Forum: API
Topic: Billing Estimate Endpoints
Replies: 8
Views: 22856

Re: Billing Estimate Endpoints

Hello, We're working on a feature to allow patient to schedule treatment based on what providers have entered in their transaction plan region. I'm not sure if this is displayed via plugin, seems like it's a built in feature - the treatment plan shows a base Fee amount, which is list price, as well...
by justine
Tue Aug 20, 2024 11:26 am
Forum: API
Topic: Posting a statement to the account ledger
Replies: 13
Views: 27667

Re: Posting a statement to the account ledger

We create digital statements and want to be able to be able to show in the Patient Account that we've sent a digital statement. Right now we do post it in the comms log, but I can't figure out how to (or if it's even possible right now) to post to the account. I've highlighted what I'm trying to do...
by justine
Mon Aug 19, 2024 3:09 pm
Forum: API
Topic: Posting a statement to the account ledger
Replies: 13
Views: 27667

Re: Posting a statement to the account ledger

Good afternoon Saskia, Statements GET and PUT are currently in development. Statements PUT allows the ability to update statement.IsSent to true. This endpoint is essentially limited to existing statements where statement.IsSent is false. Updating statement.IsSent from false to true also creates an ...
by justine
Wed Aug 14, 2024 12:03 pm
Forum: API
Topic: Status URL
Replies: 4
Views: 9917

Re: Status URL

Thanks for the update Justine. If possible while working on that status page, could a status endpoint be added so that we can check this sort of thing programmatically as well? Yessir! I will add an ODAPI status check endpoint to our API research and development list. Our testing indicates the slow...
by justine
Wed Aug 14, 2024 11:52 am
Forum: API
Topic: Status URL
Replies: 4
Views: 9917

Re: Status URL

Is there an endpoint we can hit to check the Open Dental API status? We're currently seeing a major slowdown seemingly across all of our clinics, and the hang up seems to be at the API layer, but I can't find anywhere to check status. Good morning graham_mueller, Thank you for letting us know, and ...
by justine
Mon Aug 12, 2024 9:20 am
Forum: API
Topic: Request: Allow ProcedureLogs PUT/POST to use ProcStatus "R" for referred
Replies: 7
Views: 146130

Re: Request: Allow ProcedureLogs PUT/POST to use ProcStatus "R" for referred

Could we have the PUT/POST for ProcedureLogs allow the ProcStatus of "R" for referred? Currently it states: ProcStatus: Required. Either Treatment Planned (TP), Complete (C), or Existing Other Provider (EO). Ideally it would allow for all ProcStatus ("Cn" for condition, "EC" for Existing Current, a...
by justine
Fri Jun 28, 2024 8:12 am
Forum: API
Topic: Request: [POST] Audit Trail
Replies: 10
Views: 25689

Re: Request: [POST] Audit Trail

Hi Justine, Could *some* sort of audit mechanism be exposed? It would be useful as a 3rd party to be able to say "here's a snapshot of an action we took" as well. Except for GET calls, every action that the API takes is recorded to the securitylog table. SecurityLogs GET was created for a third-par...
by justine
Fri Jun 28, 2024 7:37 am
Forum: API
Topic: Request: [POST] Audit Trail
Replies: 10
Views: 25689

Re: Request: [POST] Audit Trail

There currently exists an endpoint called SecurityLogs that I am able to read from. I would like to be able to write audit items to the system as well. Is this something that could be added? Good morning graham_mueller, No. SecurityLogs are created within Open Dental for audit purpose within the Op...
by justine
Tue Jun 25, 2024 2:21 pm
Forum: API
Topic: Adjustment API
Replies: 4
Views: 11864

Re: Adjustment API

Hello jasoncartercs,

SecUserNumEntry, DateEntry, and SecDateTEdit has been added to the adjustments endpoint. This enhancement is available in Open Dental version 24.1.44.

Thanks!
by justine
Tue Jun 25, 2024 1:53 pm
Forum: API
Topic: Appointment Summary View
Replies: 7
Views: 16806

Re: Appointment Summary View

Hello rinse-dental, Open Dental version 24.2 deprecated the plannedappt table and replaced it with the appointment.ItemOrderPlanned field. Please see the schema and appointments API documentation for additional information. This functions identically to how the plannedappt table did, without having ...
by justine
Tue Jun 18, 2024 9:21 am
Forum: Developers
Topic: How to check which tables on the database are being used on an appoinment ?
Replies: 1
Views: 11808

Re: How to check which tables on the database are being used on an appoinment ?

Hello there, I've being digging around a little bit with open dental for a while, I work with the bitrix24 crm as well, and I've being asked to find a way when an appointment is filled on the crm, it has to be reflected as well on the schedule of open dental. Can anyone tell me which tables are bei...
by justine
Thu Jun 13, 2024 3:10 pm
Forum: API
Topic: Referrals API Update
Replies: 4
Views: 10255

Re: Referrals API Update

Hello graham_mueller, The referrals GET feature requests have been completed. Referrals GET (single) has been added and referrals GET (multiple) has been enhanced with several optional filters. These enhancements are available in version 24.1.34. Please see https://www.opendental.com/site/apireferra...
by justine
Tue Jun 04, 2024 8:29 am
Forum: API
Topic: API to Get, Post Task Notes
Replies: 1
Views: 6781

Re: API to Get, Post Task Notes

SriramChellappan wrote:
Tue Jun 04, 2024 3:42 am
I see APIs for Tasks, however I don't see any APIs for tasknotes.
Good morning SriramChellappan,

You are correct, we currently do not have a taskNotes endpoint.
by justine
Tue May 28, 2024 11:18 am
Forum: API
Topic: Updated the Claim.CustomTracking column after ClaimTrackings POST API completed
Replies: 4
Views: 12118

Re: Updated the Claim.CustomTracking column after ClaimTrackings POST API completed

ajaykodam wrote:
Mon May 20, 2024 10:10 pm
Hi Team,

Can you please confirm when this change will be ready and in which version?

Thanks,
API feature requests are completed in the order they are received. We will update this tread when complete and which version it is available in.
by justine
Tue May 28, 2024 11:17 am
Forum: API
Topic: API Recalls
Replies: 4
Views: 15516

Re: API Recalls

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", "...
by justine
Thu May 16, 2024 3:08 pm
Forum: API
Topic: Intial versus replacement reason
Replies: 3
Views: 7472

Re: Intial versus replacement reason

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? I apologize for the misunderstanding. Using POST/PUT to set/update Prosthesis and DateOriginalProsth fields is on our development list. We will upd...
by justine
Thu May 16, 2024 11:31 am
Forum: API
Topic: Request webhook for blockout slots
Replies: 10
Views: 17716

Re: Request webhook for blockout slots

Smilelink wrote:
Thu May 16, 2024 11:17 am
Is there any update regarding this ?
Feature requests are completed in the order they are received. We will reply to this thread when your feature request is complete.

Thanks!
by justine
Thu May 16, 2024 11:20 am
Forum: API
Topic: Intial versus replacement reason
Replies: 3
Views: 7472

Re: Intial versus replacement reason

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)? Good morni...
by justine
Fri May 03, 2024 4:01 pm
Forum: API
Topic: Computer heartbeat timezone
Replies: 1
Views: 4763

Re: Computer heartbeat timezone

Can someone confirm what timezone the heartbeat is in? Is it the server's local time? UTC? Something else? https://www.opendental.com/site/apicomputers.html Thanks! Good afternoon saskia, The computer.LastHeartBeat value is derived from the computer that is currently using Open Dental. See Computer...
by justine
Fri May 03, 2024 3:41 pm
Forum: API
Topic: Posting a statement to the account ledger
Replies: 13
Views: 27667

Re: Posting a statement to the account ledger

saskia wrote:
Fri May 03, 2024 8:23 am
Any update? Thanks!
API features are handled in a first in, first out fashion. We are still working through our queue. Unfortunately, we experienced a bit of a backlog, as we received dozens of API related requests. Good news though, this request is next in line.

Thanks!
by justine
Fri May 03, 2024 3:34 pm
Forum: API
Topic: DownloadSftp not working via API / Can't view API logs
Replies: 1
Views: 4530

Re: DownloadSftp not working via API / Can't view API logs

Hi, I have been testing API connections with our developer Opendental instance but unfortunately, I cannot get the "Documents POST DownloadSftp" to work as expected. The request is successful but no files get uploaded to the SFTP server. I have looked at our sandbox instance and do not see the API ...
by justine
Tue Apr 16, 2024 3:02 pm
Forum: API
Topic: API Request | GET/POST/PUT/DELETE LAB CASES
Replies: 5
Views: 13256

Re: API Request | GET/POST/PUT/DELETE LAB CASES

- GET lab case. If possible, include laboratory description and Provider Abbr - POST lab case. With ability to optionally include aptnum and plannedaptnum - PUT lab case. With ability to update aptnum and plannedaptnum - DELETE lab case. Good afternoon rinse-dental, Labcases are somewhat complex an...
by justine
Tue Apr 02, 2024 3:51 pm
Forum: API
Topic: Pharmacy GET & POST
Replies: 3
Views: 5428

Re: Pharmacy GET & POST

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. I think what you're asking for is the ability to interface with DoseSpot via Open Dental API. This is not possible sin...
by justine
Tue Apr 02, 2024 2:57 pm
Forum: API
Topic: Missing [Delete] /Documents
Replies: 4
Views: 11118

Re: Missing [Delete] /Documents

<r><QUOTE author="graham_mueller" post_id="36522" time="1712018373" user_id="15239"><s>[quote=graham_mueller post_id=36522 time=1712018373 user_id=15239]</s> With regard to "break," I just meant delete. Apparently this language is only used in the API for appointments, and perhaps has a different co...
by justine
Sat Mar 30, 2024 1:46 pm
Forum: API
Topic: Pharmacy GET & POST
Replies: 3
Views: 5428

Re: Pharmacy GET & POST

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, Good afternoon beacondental, There is currently no way to GET, PUT, POST, or DELETE p...
by justine
Sat Mar 30, 2024 1:39 pm
Forum: API
Topic: Custom logtext for audit trails
Replies: 3
Views: 6038

Re: Custom logtext for audit trails

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? Good morning beacondental, No, it is not possible to change the logtext on Audit Trails within Open Dental or via the API. Thanks! Is it possible to ...
by justine
Sat Mar 30, 2024 12:16 pm
Forum: API
Topic: Missing [Delete] /Documents
Replies: 4
Views: 11118

Re: Missing [Delete] /Documents

It appears the documents api does not support updating, "breaking," or deleting documents. Am I missing an option for this? Could this be added otherwise? I'm also unable to do so via the ShortQuery API, I hadn't realized this was readonly. Hello graham_mueller, Could you please elaborate on what "...
by justine
Thu Mar 28, 2024 12:51 pm
Forum: API
Topic: Insurance card information- API to store
Replies: 2
Views: 6721

Re: Insurance card information- API to store

Hello as the name suggested I am a novice with OD. Here is a question. Currently the front desk is storing the insurance card information keying the information into OD. I would like to see if there is a way to store this information automatically. The idea is to CALL an OD API to store the informa...
by justine
Thu Mar 21, 2024 9:20 am
Forum: API
Topic: Name and version don't match
Replies: 1
Views: 4243

Re: Name and version don't match

A client added in the API key, but when I go into my portal, the name and version doesn't match. The key is correct so I'm scratching my head as to what is happening and whether I should be concerned. The practice name on my portal shows as Relaxation Dental and the version as 23.1.36.0. The client...
by justine
Wed Mar 20, 2024 10:00 am
Forum: API
Topic: Need help for Benefits PUT API
Replies: 1
Views: 3894

Re: Need help for Benefits PUT API

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 ob...
by justine
Wed Mar 20, 2024 9:44 am
Forum: API
Topic: Database connection issue
Replies: 1
Views: 4294

Re: Database connection issue

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 h...
by justine
Mon Mar 18, 2024 10:29 am
Forum: API
Topic: Custom logtext for audit trails
Replies: 3
Views: 6038

Re: Custom logtext for audit trails

beacondental wrote:
Mon Mar 18, 2024 9:59 am
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?
Good morning beacondental,

No, it is not possible to change the logtext on Audit Trails within Open Dental or via the API.

Thanks!
by justine
Mon Mar 18, 2024 9:44 am
Forum: API
Topic: API Availability Check?
Replies: 6
Views: 7049

Re: API Availability Check?

Thanks for that fast reply, I think I understand. The public demo credentials are meant to be a means by which I can determine if I have my API implementation set up correctly it sounds like. In this case, I'm more looking for a way to be sure I have connectivity with a specific office to eliminate...
by justine
Mon Mar 18, 2024 9:19 am
Forum: API
Topic: Request webhook for blockout slots
Replies: 10
Views: 17716

Re: Request webhook for blockout slots

Smilelink wrote:
Sun Mar 17, 2024 5:40 am
Hi Justine,

we should have a runner to get update on this, I meant a webhook which send the updates to our endpoint
Good morning Smilelink,

We can add the ability to create schedule subscriptions.

We will reply to this thread once the request is complete.

Thanks!
by justine
Mon Mar 18, 2024 9:01 am
Forum: API
Topic: API Availability Check?
Replies: 6
Views: 7049

Re: API Availability Check?

Thanks justine, How do those public demo credentials work? What request should we send to the API using those credentials? This won't give us a valid indication as to whether we'd be successful using the API normally would it? Since something could be wrong related to our generated customer key? Fo...
by justine
Fri Mar 15, 2024 2:51 pm
Forum: API
Topic: Updated the Claim.CustomTracking column after ClaimTrackings POST API completed
Replies: 4
Views: 12118

Re: Updated the Claim.CustomTracking column after ClaimTrackings POST API completed

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 ...
by justine
Thu Mar 14, 2024 4:44 pm
Forum: API
Topic: API Availability Check?
Replies: 6
Views: 7049

Re: API Availability Check?

We would like to be able to keep our users informed of the current connectivity status of our application to the Open Dental API. For example, if someone removes the customer API key from Open Dental or just hasn't added it yet or if something is down on the PMS machine or even if the Open Dental A...
by justine
Wed Mar 13, 2024 1:49 pm
Forum: API
Topic: Generating keys via API
Replies: 2
Views: 4346

Re: Generating keys via API

Let me know if I'm overlooking this somewhere, but I would love to be able to generate new keys via the API so I can simplify the process of onboarding my clients. Good afternoon saskia, The Developer Portal is secure, requiring a username and password. We would have to add this entirely new layer ...
by justine
Tue Mar 12, 2024 2:46 pm
Forum: API
Topic: Request webhook for blockout slots
Replies: 10
Views: 17716

Re: Request webhook for blockout slots

Hello, Is there anyway we can know if a block slot has been added or deleted without calling the Schedule API at a specific time? Hello Smilelink, You can use the Schedules GET endpoint without a date parameter, but it is not recommended. You should also use the SchedType parameter, and use the Blo...
by justine
Tue Mar 05, 2024 7:34 am
Forum: API
Topic: ECONNRESET when attempting PUT ShortQuery with Offset
Replies: 4
Views: 5613

Re: ECONNRESET when attempting PUT ShortQuery with Offset

Good morning graham_mueller,

I apologize for the timeout misunderstanding. I'm glad you found a solution and shared it on the forums.

Thanks!
by justine
Mon Mar 04, 2024 2:51 pm
Forum: API
Topic: ECONNRESET when attempting PUT ShortQuery with Offset
Replies: 4
Views: 5613

Re: ECONNRESET when attempting PUT ShortQuery with Offset

I started to try to loop through result sets today, because one query is getting a set of appointments with length > 100. When I make a second request with Offset=100, the OD API server seems to be killing my connection each time. I'm hitting [PUT] https://api.opendental.com/api/v1/queries/ShortQue...
by justine
Tue Feb 27, 2024 5:50 pm
Forum: API
Topic: Adjustment API
Replies: 4
Views: 11864

Re: Adjustment API

jasoncartercs wrote:
Tue Feb 27, 2024 5:30 pm
My question was not clear. The secUserNumEntry is not a part of the Adjustment endpoint. Is there a way to add it?
Ahh, I understand. I have added returning secUserNumEntry to the adjustments GET response to the API development list.

Thanks!
by justine
Tue Feb 27, 2024 5:17 pm
Forum: API
Topic: Request webhook for blockout slots
Replies: 10
Views: 17716

Re: Request webhook for blockout slots

Thanks for the reply, is there any estimate on when can we expect it ? Also can we get a event hook for Patient delete blockslot Update o delete provider Update o delete operatory Update o delete We will reply to this thread once the request is complete. A patient will have a patientStatus of 'Dele...
by justine
Tue Feb 27, 2024 5:09 pm
Forum: API
Topic: Adjustment API
Replies: 4
Views: 11864

Re: Adjustment API

jasoncartercs wrote:
Tue Feb 27, 2024 1:02 pm
Is it possible to add the user who enters the adjustment as a property in the API?

This would be useful for any kind of adjustment or payment on an account.
We do not allow setting secUserNumEntry via the API. secUserNumEntry will always be 0 when an endpoint is inserted via API.

Thanks!
by justine
Tue Feb 27, 2024 4:49 pm
Forum: API
Topic: Tasks API - PUT with TaskStatus
Replies: 4
Views: 10176

Re: Tasks API - PUT with TaskStatus

My client needs to mark tasks done via the API. Is TaskStatus a supported field for PUT requests to Tasks? I don't see it included in the Tasks API spec . If this is not supported, does anyone have a query handy that can be used via the Query API to update a task's TaskStatus only? Thanks so much! ...
by justine
Tue Feb 20, 2024 8:20 pm
Forum: API
Topic: "Duration" of X and / setting
Replies: 3
Views: 6406

Re: "Duration" of X and / setting

In the desktop client, you can specify whether the system displays in 5/10/15 minute intervals. Is this setting exposed via the API? I'm not sure what name to search, and I haven't been able to find something that seems appropriately named. ETA: Specifically, in the Open Dental desktop application,...
by justine
Mon Feb 19, 2024 3:18 pm
Forum: API
Topic: Request webhook for blockout slots
Replies: 10
Views: 17716

Re: Request webhook for blockout slots

Please add schedule events so there would be a webhook sending changes for the blockout timeslot changes data Hello Smilelink, We can add schedules to the API Events watch table. I have added researching this to our API development list. However, you can currently get this information from GET sche...
by justine
Fri Feb 16, 2024 1:52 pm
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 19
Views: 30228

Re: **URGENT BENEFITS ISSUE**

Awesome thanks! CodeGroups will always be the same across all clinics, unlike covcats, right? for example FMX/PANO will always be CodeGroupNum 2, right? Good afternoon omar22, CodeGroups (Frequency Limitations) can be configured however the practice wants. So, while it may be likely that CodeGroupN...
by justine
Fri Feb 16, 2024 9:38 am
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 19
Views: 30228

Re: **URGENT BENEFITS ISSUE**

omar22 wrote:
Fri Feb 16, 2024 7:25 am
Hey sorry to bother you again, but it appears version 23.2.62 is still unavailable for my offices to update to. Do you have an ETA to when this version will be available?
Good morning omar22,

23.2.62 has been released.

Thanks!
by justine
Wed Feb 14, 2024 8:35 am
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 19
Views: 30228

Re: **URGENT BENEFITS ISSUE**

Is there a way to POST frequency in CodeGroups? I can't find any documentation on the API specification or anything to implement this new change. Benefits were enhanced in version 23.2.62. -GET no longer requires a PlanNum or PatPlanNum. -GET now returns CodeGroupNum value. -POST now supports creat...
by justine
Wed Feb 14, 2024 8:01 am
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 19
Views: 30228

Re: **URGENT BENEFITS ISSUE**

I tried using the POST /benefits with CodeGroupNum and it doesn't work (my demo versionis 23.3.32.0). Please see payload: { "PlanNum": 74, "CovCatNum": 0, "Percent":-1, "MonetaryAmt":-1, "BenefitType":"Limitations", "QuantityQualifier":"Months", "Quantity":12, "CodeGroupNum": 2, "CoverageLevel": "N...
by justine
Tue Feb 13, 2024 3:16 pm
Forum: API
Topic: Open Dental 23.2 Benefit API does not have CodeGroup
Replies: 4
Views: 6197

Re: Open Dental 23.2 Benefit API does not have CodeGroup

In latest update of Open Dental, it has broken functionality of Frequency as the screen is updated with introduction of something called "CodeGroup". if the application has the functionality, why the API does not support it? Benefits were enhanced in version 23.2.62. -GET no longer requires a PlanN...
by justine
Tue Feb 13, 2024 3:11 pm
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 19
Views: 30228

Re: **URGENT BENEFITS ISSUE**

Is there a way to POST frequency in CodeGroups? I can't find any documentation on the API specification or anything to implement this new change. Benefits were enhanced in version 23.2.62. -GET no longer requires a PlanNum or PatPlanNum. -GET now returns CodeGroupNum value. -POST now supports creat...
by justine
Thu Feb 08, 2024 8:42 am
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 19
Views: 30228

Re: **URGENT BENEFITS ISSUE**

omar22 wrote:
Thu Feb 08, 2024 6:32 am
Is there a way to POST frequency in CodeGroups? I can't find any documentation on the API specification or anything to implement this new change.
Unfortunately no, there is not. CodeGroups GET is currently in development. I have added CodeGroups PUT/POST to the API development list.

Thanks!
by justine
Wed Feb 07, 2024 1:35 pm
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 19
Views: 30228

Re: **URGENT BENEFITS ISSUE**

Good afternoon omar22, Frequency Limitations implementation changed in v23.2 and now use CodeGroups. 23.1 23.2 23.3 To address this: Enhancing the Benefits endpoints to include CodeGroupNum, is on the top of our development list. Implementing CodeGroups GET is on the top of our development list. I w...
by justine
Wed Jan 31, 2024 10:51 am
Forum: API
Topic: API Events Question
Replies: 20
Views: 22147

Re: API Events Question

API Service in OD Cloud ("Cloud API") exists for API developers that have designed applications that rely on the API Service. If a 3rd party OD API developer designed an application and wanted to support an Open Dental Cloud customer, their application works. Ah, OK, that makes sense. All of our co...
by justine
Wed Jan 31, 2024 10:19 am
Forum: API
Topic: API Events Question
Replies: 20
Views: 22147

Re: API Events Question

OK, I've re-read that API documentation and have a better understanding. Remote API is the API that we are using now found at https://api.opendental.com/api/v1 I have a few questions about Cloud API. 1. Since Cloud API connects directly to the API Service running on the Open Dental Cloud VM, what i...
by justine
Tue Jan 30, 2024 4:02 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 22147

Re: API Events Question

OK, so there's the Local API, the API Service and the Cloud API. We're using the Cloud API whenever we hit api.opendental.com/api . It is hosted by Open Dental. The Local API is one that is hosted by an instance of Open Dental whenever it is open and is available on any workstation or server where ...
by justine
Tue Jan 30, 2024 3:06 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 22147

Re: API Events Question

Great, thank you as well justine. We will be very careful to craft queries that don't put too much load on the practice's servers and build in a mechanism to rachet up or down the frequency of requests on a per-practice basis so practices with lower-end hardware can be given more breathing room if ...
by justine
Tue Jan 30, 2024 2:01 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 22147

Re: API Events Question

Thank you for your reply justine I understand, we wouldn't want to do that many queries but it's important for me to understand our throughput allowances so I can make sure whatever we design doesn't run afoul of any limits Open Dental has set as we expand. Here's what I'm thinking at the moment, I...
by justine
Mon Jan 29, 2024 1:55 pm
Forum: API
Topic: Posting a statement to the account ledger
Replies: 13
Views: 27667

Re: Posting a statement to the account ledger

saskia wrote:
Thu Jan 25, 2024 4:50 pm
We take care of the statements, we just want to be able to let OpenDental know that a statement was made/sent. THanks!
Good afternoon saskia,

I have added this to our development list. We will reply to this post with additional questions and/or when the request is complete.

Thanks!
by justine
Mon Jan 29, 2024 11:36 am
Forum: API
Topic: API Events Question
Replies: 20
Views: 22147

Re: API Events Question

I remember someone mentioning to us in an email at some point that the hard limit for requests to the Open Dental API is 1 request per second per customer API Key averaged across the day, so essentially 86,400 requests per day per customer API Key. Is that correct? So, if we want to check every 5 s...
by justine
Thu Jan 25, 2024 2:56 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 22147

Re: API Events Question

The AppointmentDeleted Event relies on the HistAppointment table. If you'd like to see the lifespan of any appointment, take a look at HistAppointments GET. Awesome, thank you. Incidentally, is there any way to quickly see with a query when a claim has been deleted? We have several tables we'd like...
by justine
Thu Jan 25, 2024 1:33 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 22147

Re: API Events Question

You are correct, this is essentially how it functions. However, AppointmentsDeleted will return data when an appointment has been deleted. Is that done as an event pushed from the software? I don't see a way looking at the appointment table to know if or when it was deleted unless DateTimeDismissed...
by justine
Thu Jan 25, 2024 12:59 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 22147

Re: API Events Question

For the API Events functionality, specifically Database Events, in the Open Dental API, it says that "Open Dental and the API Service generate these events by polling the database at the frequency you specify." My question is, does it do this by checking a timestamp or other date field in the table...
by justine
Sat Jan 20, 2024 10:54 am
Forum: API
Topic: Open Dental 23.2 Benefit API does not have CodeGroup
Replies: 4
Views: 6197

Re: Open Dental 23.2 Benefit API does not have CodeGroup

In latest update of Open Dental, it has broken functionality of Frequency as the screen is updated with introduction of something called "CodeGroup". if the application has the functionality, why the API does not support it? Good morning vgajeradental, We have added the following to our development...
by justine
Wed Dec 27, 2023 10:23 am
Forum: API
Topic: Appointment Slots (proposal for API)
Replies: 9
Views: 13242

Re: Appointment Slots (proposal for API)

I am rewriting my online booking system from the ground up. The current version reads data from appointment and schedule and scheduleOp to build a day and then block out slots that have appointments or blockouts. For security I am switching everything to use the open dental API....I am not sure if ...
by justine
Thu Dec 14, 2023 9:58 am
Forum: API
Topic: Daterange support for ProcedureLogs GET
Replies: 5
Views: 6351

Re: Daterange support for ProcedureLogs GET

Hi I hope procedurelog.DateTStamp will gives us the procedures from the start date to till now. Please correct me if im wrong. What we wanted is the procedure logs between two date range Regards Sendhil Good morning Sendhil, You are correct that procedurelogs OD API parameter DateTStamp will return...
by justine
Wed Dec 13, 2023 2:01 pm
Forum: API
Topic: Daterange support for ProcedureLogs GET
Replies: 5
Views: 6351

Re: Daterange support for ProcedureLogs GET

Hi API developers, Can you add Date range support in ProcedureLogs GET (multiple)? For example GET /procedurelogs?startDateTStamp=2020-07-30 08:00:00&endDateTStamp=2020-08-30 08:00:00 This will be useful in the scenario where we want to process the data in batches for period of six months. Regards ...
by justine
Wed Dec 13, 2023 1:52 pm
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 54381

Re: TreatPlans POST

PBECKER wrote:
Wed Dec 13, 2023 11:17 am
any update on the last API method?
PBECKER,

Signing a TreatPlan via OD API is complex. We are in the process of researching exactly the best way to implement this for all OD API developers and Open Dental itself. We will update this thread soon.

Thanks!
by justine
Sat Dec 09, 2023 10:44 am
Forum: API
Topic: API for web forms
Replies: 6
Views: 10010

Re: API for web forms

The Sheets endpoint now returns sheet.IsWebform. This enhancement is available in version 23.3.14.
by justine
Mon Dec 04, 2023 2:25 pm
Forum: API
Topic: Getting several documents for a patient at a time
Replies: 2
Views: 4344

Re: Getting several documents for a patient at a time

We have a use case where we want to perform some AI image processing on x-rays to create and attach additional metadata to an image. We have been looking at the API for pulling a patient's documents and have a few questions. Here is the API in question: Documents POST DownloadSftp (https://www.open...
by justine
Mon Nov 20, 2023 12:40 pm
Forum: API
Topic: patient field defs
Replies: 4
Views: 7650

Re: patient field defs

saskia wrote:
Mon Nov 20, 2023 12:15 pm
Thanks! Once added, will we be able to post data to those created patfielddefs or is that a separate request?
Yes. I have added patfieldDefs POST and PUT to our development list. For additional information, please see patFields POST.

Thanks!
by justine
Mon Nov 20, 2023 11:59 am
Forum: API
Topic: patient field defs
Replies: 4
Views: 7650

Re: patient field defs

Any chance someone can point me in the right direction of API documentation on patient field defs? I'm looking at creating them via API and then populating data. Is this possible? I couldn't see anything under definitions, is it somewhere else or not supported in the API? Thanks. It is currently no...
by justine
Thu Nov 16, 2023 11:28 am
Forum: API
Topic: Benefit API Issue
Replies: 7
Views: 9905

Re: Benefit API Issue

CovCats GET is complete and is available the version 23.3.8.

Please see CovCats for more information.

Thanks!
by justine
Thu Oct 19, 2023 10:46 am
Forum: API
Topic: REQUEST: PUT refattaches
Replies: 2
Views: 5415

Re: REQUEST: PUT refattaches

Primary Use Case: User updates ReToStatus However, it would be helpful to update all the fields on the record: RefDate DateProcCompleted Transition Of Care RefNum ReferralType ProvNum Note And... while we're at it, DELETE refattaches but less of a priority Good morning rinse-dental, I have added re...
by justine
Wed Oct 18, 2023 9:48 am
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 18437

Re: Request benefits in family module

Please do add GET etrans, GET etransmessagetext, and GET insverifies to your development list. Good morning beacondental, Etranss GET is complete and is available in version 23.2.7. EtransMessageText GET is complete and is available in version 23.2.11. Insverifies GET is complete and is available i...
by justine
Thu Oct 12, 2023 2:41 pm
Forum: API
Topic: Bulk update comm log
Replies: 7
Views: 9186

Re: Bulk update comm log

We're seeing requests timeout and have been assuming that's OD throttling us - is this not the case? From what I can see in the documentation, it's 1 request per second - what happens when we go over that? We want to make sure the data we're trying to write back gets written back and we don't have ...
by justine
Thu Oct 12, 2023 2:00 pm
Forum: API
Topic: Bulk update comm log
Replies: 7
Views: 9186

Re: Bulk update comm log

I feared that was the case. We'll have to build in our own delay to ensure we don't get throttled when we're trying to post hundreds of comm logs when we do a batch send. A real bummer, this is definitely an API where being able to bulk update would be very useful and reduce load for both sides. Pl...
by justine
Mon Oct 09, 2023 11:10 am
Forum: API
Topic: Posting payments for dynamic payment plans
Replies: 16
Views: 16619

Re: Posting payments for dynamic payment plans

Hey - checking in to see where in the pipeline these requests might be? I've got some related enhancement requests around the regular patient payment plans that were submitted around the same time - I suspect they may have all been lumped together? Thanks! Good morning Saskia, Our API team processe...
by justine
Mon Oct 02, 2023 3:12 pm
Forum: API
Topic: POST DiscountPlanSub defect
Replies: 4
Views: 6577

Re: POST DiscountPlanSub defect

rinse-dental wrote:
Tue Sep 26, 2023 7:36 pm
Thanks!
Hello rinse-dental,

We addressed an issue where procedurelog.DiscountPlanAmt may not have been updated when a discountplansub POST/PUT had been called. This fix is available in version 23.1.53 and newer.

Thanks!
by justine
Mon Sep 25, 2023 10:05 am
Forum: API
Topic: POST DiscountPlanSub defect
Replies: 4
Views: 6577

Re: POST DiscountPlanSub defect

If posting a discount plan via the API, the Open Dental client does not appear to incorporate the discounts when calculating apt estimates/totals. More specifically, the procedurelog table does not update the DiscountPlanAmt field. EDIT: This appears to be an issue when you do not set the optional ...
by justine
Mon Sep 18, 2023 1:07 pm
Forum: API
Topic: Add OrthoRemainM to Claim PUT API
Replies: 4
Views: 8033

Re: Add OrthoRemainM to Claim PUT API

Good afternoon ajaykodam,

OrthoRemainM has been added to Claims PUT and is available in version 23.2.18.

Thanks!
by justine
Wed Sep 06, 2023 9:46 am
Forum: API
Topic: Program Link Triggered E-Mail for Next appointment using n8n
Replies: 10
Views: 16860

Re: Program Link Triggered E-Mail for Next appointment using n8n

You can create a Program Link to place a button in the UI, like pictured above. Our manual has a lot of details for setup and implementation. I would recommend referencing Program Links for general information and Custom Bridges for creating your own program link. Are there lists of the "many patie...
by justine
Thu Aug 31, 2023 2:35 pm
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 12491

Re: Looking for ideas on eliminating data synchronization feedback loop

You're suggesting I compare SecDateTEdit to a date we have in our own system, right? With the ShortQuery suggestion, you're still only talking about looking at SecDateTEdit and the security log, right? Since those are the only two relevant pieces of data in this scenario? Correct. Run an additional...
by justine
Thu Aug 31, 2023 10:41 am
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 12491

Re: Looking for ideas on eliminating data synchronization feedback loop

OK thank you Do you think it would be reasonable or possible to implement a feature whereby when a record in OD is updated, it's recorded by whom and when so that in the future we'd be able to do a simple query and know whether the record we're querying was updated by our user or by another user? I...
by justine
Thu Aug 31, 2023 10:02 am
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 12491

Re: Looking for ideas on eliminating data synchronization feedback loop

Hi again Justine, Can you tell me what this call is returning in terms of time scope? Is it showing everything the current user has ever done through the API for the permission type specified? Also, since this only returns data about usage for the current user there wouldn't be any way for me to kn...
by justine
Wed Aug 30, 2023 2:27 pm
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 12491

Re: Looking for ideas on eliminating data synchronization feedback loop

I'm wondering if my developer API key needs to be modified to have permissions to access the securitylogs resource because I've triple checked my request and it looks good, but the OD API is telling me that the resource doesn't exist. Do I need to make a request to have my API key updated for this?...
by justine
Wed Aug 30, 2023 12:15 pm
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 12491

Re: Looking for ideas on eliminating data synchronization feedback loop

We are doing this because one requirement from our client is that a user must be able to add a note even if the eConnector is down for some reason. If the eConnector is down we will write the note back to OD as soon as it is back online, but in the meantime the user sees the note because it is stor...
by justine
Thu Jul 13, 2023 3:04 pm
Forum: API
Topic: Confirmation status
Replies: 6
Views: 10683

Re: Confirmation status

Good afternoon beacondental.

HistAppointments GET is available in version 23.1.30.
by justine
Wed Jul 05, 2023 3:11 pm
Forum: API
Topic: Payments POST - set payType
Replies: 18
Views: 23490

Re: Payments POST - set payType

Awesome! Thank you! Do you know how long it typically takes for versions to go from beta to full release? I know I'm going to have clients who don't want to run a beta version so if there's any ballpark I can give them that would be great. Thanks! We attempt to release four minor versions per year,...
by justine
Wed Jul 05, 2023 12:28 pm
Forum: API
Topic: Prepayments for dynamic payment plans
Replies: 6
Views: 9881

Re: Prepayments for dynamic payment plans

saskia wrote:
Wed Jul 05, 2023 6:23 am
Is there a target release date for this? Thanks!
Good afternoon saskia,

This is currently in the final stages of development. We will update this thread when it is complete.

Thanks!
by justine
Wed Jul 05, 2023 12:26 pm
Forum: API
Topic: Payments POST - set payType
Replies: 18
Views: 23490

Re: Payments POST - set payType

Is there a target release date for this yet? Thanks. Good afternoon saskia, Payments POST PayType enhancement is available in version 23.1.27. If you are curious about API features, you can always check out the previous versions page . Every API feature or enhancement will be on the previous versio...
by justine
Mon Jul 03, 2023 3:02 pm
Forum: API
Topic: ProcNotes
Replies: 1
Views: 3071

Re: ProcNotes

I see a method to POST ProcNotes: https://www.opendental.com/site/apiprocnotes.html is there a method to GET them? ProcedureLogs GET doesnt have Good afternoon paulwilliamsdds, Currently, there is no ProcNotes GET, but we can add this to our development list, if you'd like. Also, ChartModules GET P...
by justine
Mon Jul 03, 2023 8:40 am
Forum: API
Topic: Confirmation status
Replies: 6
Views: 10683

Re: Confirmation status

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 Good morning beacondenta...
by justine
Fri Jun 30, 2023 7:13 am
Forum: API
Topic: API ProcTPs question
Replies: 10
Views: 13320

Re: API ProcTPs question

Were you able to research the feasibility/workflow of adding procedurecodes/procedurelogs POST? Not yet. API job requests are completed in the order they are received. There are dozens of requests ahead of this one. You have made 12 API feature requests. This one is the most recent, so the API team...
by justine
Tue Jun 27, 2023 9:48 am
Forum: API
Topic: API query error message
Replies: 4
Views: 7069

Re: API query error message

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...
by justine
Tue Jun 20, 2023 7:55 am
Forum: API
Topic: New API for Fam Aging Balance
Replies: 6
Views: 9203

Re: New API for Fam Aging Balance

kashgoyal wrote:
Tue Jun 20, 2023 12:11 am
Hi justine,

So "GET accountmodule/Aging honors that process" means when the Api is called aging will run and provide latest balance or it will not be run?

Thanks!
Yes, accountmodule/Aging runs aging.
by justine
Thu Jun 15, 2023 9:36 am
Forum: API
Topic: New API for Fam Aging Balance
Replies: 6
Views: 9203

Re: New API for Fam Aging Balance

Hi justine, Thanks for providing the aging balance Api endpoint. We can certainly use this endpoint if the api pertains that we would be able to get accurate and current numbers for the aging report at any given moment as Open Dental's documentation (https://www.opendental.com/manual/aging.html) st...
by justine
Tue Jun 13, 2023 3:49 pm
Forum: API
Topic: API FeeScheds Request
Replies: 8
Views: 12586

Re: API FeeScheds Request

Hello, I would like to request being able to POST new fee schedules and being able to add fees on a D-code level. Is there an existing method of achieving this? If not, I would like to request it please :) Thank you all so much! Omar Good afternoon omar22, We will look into adding the ability to PO...
by justine
Tue Jun 13, 2023 8:06 am
Forum: API
Topic: New API for Fam Aging Balance
Replies: 6
Views: 9203

Re: New API for Fam Aging Balance

Hi Team, We need a way to show the current family aging balance. We noticed that Open Dental stores this information in a table, but that table is only updated in certain cases. We would like to display that data to the user, but we would need a way to get what it would show if the calculation for ...
by justine
Mon Jun 12, 2023 8:59 am
Forum: API
Topic: API ProcTPs question
Replies: 10
Views: 13320

Re: API ProcTPs question

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. Good morning beacondental, For procedurelogs GET, we will add Prosthesis, DateOriginalProsth and IsDateProsthEst, to our developmen...
by justine
Wed Jun 07, 2023 12:39 pm
Forum: API
Topic: API ProcTPs question
Replies: 10
Views: 13320

Re: API ProcTPs question

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 Hello beacondental, Within Open Dental, Prosthesis Replacement is only visible if the procedure is not in Canada and...
by justine
Wed Jun 07, 2023 8:21 am
Forum: API
Topic: Income transfer manager
Replies: 5
Views: 9276

Re: Income transfer manager

beacondental wrote:
Tue Jun 06, 2023 7:51 pm
Is there a way to run the income transfer manager thru the API short query?
No, there is not.
by justine
Tue Jun 06, 2023 2:41 pm
Forum: API
Topic: Patient portal API
Replies: 3
Views: 7190

Re: Patient portal API

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. Hello beacondental, A patient's Patient Portal username is stored in the userweb table . You coul...
by justine
Tue Jun 06, 2023 9:07 am
Forum: API
Topic: Question on DiscountPlanSubs DELETE
Replies: 1
Views: 4622

Re: Question on DiscountPlanSubs DELETE

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. Using DiscountPlanSubs DELETE, is essentially the same as clicki...
by justine
Thu Jun 01, 2023 12:54 pm
Forum: API
Topic: TreatPlanAttaches GET
Replies: 7
Views: 11655

Re: TreatPlanAttaches GET

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 t...
by justine
Thu Jun 01, 2023 7:54 am
Forum: API
Topic: TreatPlanAttaches GET
Replies: 7
Views: 11655

Re: TreatPlanAttaches GET

PBECKER wrote:
Wed May 31, 2023 3:08 pm
for ProcedureLog GET we don't see insurance Estimate and Patient Estimate. Is it possible to get these two items added to ProcedureLog GET
No.

Insurance Estimate and Patient Estimate are not part of the procedurelog table.
by justine
Wed May 31, 2023 1:54 pm
Forum: API
Topic: TreatPlanAttaches GET
Replies: 7
Views: 11655

Re: TreatPlanAttaches GET

PBECKER wrote:
Wed May 31, 2023 1:49 pm
any way to update the existing TreatPlansAttaches GET to return all fields names instead of having to GET then compare with ProcedureLogs GET
TreatPlanAttaches GET does return all fields in the table.
by justine
Wed May 31, 2023 1:45 pm
Forum: API
Topic: TreatPlanAttaches GET
Replies: 7
Views: 11655

Re: TreatPlanAttaches GET

Is it possible to add the below fields to the api response for TreatPlanAttaches GET tooth Number Procedure Cost Insurance Estimate Patient Estimate Hello PBECKER, The TreatPlanAttach table has a FK to procedurelog.ProcNum. Using the procedurelog.ProcNum, you can look up the procedurelog. The proce...
by justine
Mon May 22, 2023 3:26 pm
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 18
Views: 35201

Re: How to retrieve Open Dental's calculated insurance and patient portions?

Thank you. Will this estimate consider date - similar to the Treatment Plan? For example, if a patient is not eligible for a cleaning until [recall date] and the appointment is booked after [recall date] - will the estimate be based on today, the date the estimate was created, or the scheduled appo...
by justine
Mon May 22, 2023 2:09 pm
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 18
Views: 35201

Re: How to retrieve Open Dental's calculated insurance and patient portions?

Is it possible to retrieve Open Dental's calculations for the following: Estimated patient portion as found in the appointment screen in Open Dental Treatment plan cost break down including Insurance portion, Patient portion, writeoff, etc. as found in the Treatment Plan screen If not, is it possib...
by justine
Wed May 17, 2023 9:38 am
Forum: API
Topic: Request for a PUT to update data via the DiscountPlanSubs API
Replies: 10
Views: 12844

Re: Request for a PUT to update data via the DiscountPlanSubs API

joebrown_subscribili wrote:
Thu Apr 13, 2023 3:14 pm
Not to be a pain, but do you possibly have an estimate for when this functionality might be available? Thank you.
DiscountPlanSubs DELETE is available in version 23.1.12 and later.

Thanks!
by justine
Tue May 16, 2023 11:27 am
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 18
Views: 35201

Re: How to retrieve Open Dental's calculated insurance and patient portions?

Is it possible to retrieve Open Dental's calculations for the following: Estimated patient portion as found in the appointment screen in Open Dental Treatment plan cost break down including Insurance portion, Patient portion, writeoff, etc. as found in the Treatment Plan screen If not, is it possib...
by justine
Mon May 15, 2023 9:24 am
Forum: API
Topic: Date Issue with API
Replies: 10
Views: 15023

Re: Date Issue with API

Hello, I found that when I try to add history in the ProcedureLogs API and put the date in the YYYY-MM-DD format, the date gets uploaded as the next day. This issue is also present when I try to search for patients using the GET and filter by DOB, it doesn't work, since the date I enter is a day ah...
by justine
Thu May 11, 2023 1:05 pm
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 18437

Re: Request benefits in family module

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...
by justine
Wed May 10, 2023 1:03 pm
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 18437

Re: Request benefits in family module

Please do add GET etrans, GET etransmessagetext, and GET insverifies to your development list. Great! We have added GET insverifies, GET etrans and GET etransmessagetext to our development list. New requests are completed in the order in which they are received. There are requests ahead of you. Com...
by justine
Wed May 10, 2023 12:09 pm
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 18437

Re: Request benefits in family module

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. Hello beacondental, You can get the results from the 271 response in the etransmessagetext table. While it is not possible to make an electronic benefits request...
by justine
Wed May 10, 2023 11:00 am
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 18437

Re: Request benefits in family module

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...