Search found 284 matches
- Wed May 07, 2025 3:51 pm
- Forum: API
- Topic: SubscriberID Disappears
- Replies: 1
- Views: 117
Re: SubscriberID Disappears
I have a client of mine that we use the Benefits API for, and hes complaining that somehow the SubscriberID disappears whenever we cmoplete any verifications. Do you know why this may be happening? Hello omar22, Can you elaborate a little bit on your API workflow (API calls, JSON body, OD version, ...
- Wed May 07, 2025 3:44 pm
- Forum: API
- Topic: Opendental API Performance Bottleneck Investigation - Global Server vs API Key Level
- Replies: 1
- Views: 92
Re: Opendental API Performance Bottleneck Investigation - Global Server vs API Key Level
Hello, We've been conducting performance testing on our integration with Opendental APIs and have identified significant latency issues (p95 latency of 35 seconds with 50 concurrent users). When we mocked these OD API calls in our test environment, performance improved dramatically to a p95 latency...
- Thu May 01, 2025 2:19 pm
- Forum: API
- Topic: POST ClaimProcs
- Replies: 1
- Views: 1102
Re: POST ClaimProcs
Hello opendentaluser123,opendentaluser123 wrote: ↑Wed Apr 30, 2025 3:40 pmHi, is there a way to POST claimProcs through the API today? See screenshot for the analogous action in the UI!
I have added researching the ability to POST a supplemental claimproc via the API.
Thanks!
- Thu May 01, 2025 11:15 am
- Forum: Main Forum
- Topic: ShortQuery 401 Unauthorized After Update to 24.4
- Replies: 1
- Views: 515
Re: ShortQuery 401 Unauthorized After Update to 24.4
Hi! I'm a vendor integrated w/ a practice that just updated their OpenDental server to 24.4. We're relying on the ShortQuery endpoint quite extensively - one of our queries started breaking w/ a 401 error recently and we can't seem to figure out why. The query is: SELECT PopupNum, PatNum, Descripti...
- Wed Apr 30, 2025 1:19 pm
- Forum: API
- Topic: Treatment plan scheduled?
- Replies: 1
- Views: 189
Re: Treatment plan scheduled?
I'm looking to see whether an active treatment plan has any of the associated procedures scheduled or completed. If I'm looking at the documentation, it looks like I'll have to make a couple of calls in order to do this: 1. Get the treatment plan id GET /treatplans 2. Get the procedures with the pl...
- Wed Apr 30, 2025 10:55 am
- Forum: API
- Topic: PatFields PUT - Date Format Concern
- Replies: 1
- Views: 330
Re: PatFields PUT - Date Format Concern
Good Day, I have an issue when updating date fields using PatFields PUT endpoint. The display format of the updated field on Open Dental changes from "dd/MM/yyyy" (eg. 03/04/2025) to "yyyy-MM-dd" (eg. 2025-03-04). change-1.PNG change-2.PNG Thank you. Good morning dr4com4lfoy, Sounds like Open Denta...
- Thu Apr 24, 2025 9:34 am
- Forum: API
- Topic: EOBAttaches POST Upload
- Replies: 1
- Views: 4040
Re: EOBAttaches POST Upload
Good morning dr4com4lfoy,dr4com4lfoy wrote: ↑Wed Apr 23, 2025 10:26 pmIs there a way we can upload EOBs without SFTP? Similar to the Documents POST Upload endpoint.
No, POST eobattaches/UploadSftp requires SFTP.
Thanks!
- Thu Apr 10, 2025 11:19 am
- Forum: API
- Topic: API Chart Ortho
- Replies: 3
- Views: 4934
Re: API Chart Ortho
Hello beacondental,
I have added orthocharts to the API development list.
Thanks!
- Thu Apr 10, 2025 11:18 am
- Forum: API
- Topic: Developer Portal Access
- Replies: 1
- Views: 1109
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...
- Wed Apr 09, 2025 3:25 pm
- Forum: API
- Topic: API Chart Ortho
- Replies: 3
- Views: 4934
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...
- Wed Apr 09, 2025 3:11 pm
- Forum: API
- Topic: Issue with Posting PreAuth Claim
- Replies: 8
- Views: 7132
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...
- Thu Apr 03, 2025 3:29 pm
- Forum: API
- Topic: EOB Delete
- Replies: 1
- Views: 1290
- 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: 1744
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 ...
- Tue Mar 25, 2025 9:10 am
- Forum: API
- Topic: Clarification on Provider and Clinic Relationship in Open Dental
- Replies: 3
- Views: 1879
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,...
- Mon Mar 24, 2025 10:56 am
- Forum: API
- Topic: Clarification on Provider and Clinic Relationship in Open Dental
- Replies: 3
- Views: 1879
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 ...
- Fri Mar 21, 2025 8:45 am
- Forum: API
- Topic: API Request | subscriptions.WatchTable == 'Schedule'
- Replies: 4
- Views: 5587
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...
- Thu Mar 20, 2025 2:59 pm
- Forum: API
- Topic: API Request | subscriptions.WatchTable == 'Schedule'
- Replies: 4
- Views: 5587
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...
- Mon Mar 17, 2025 12:19 pm
- Forum: API
- Topic: Request: Allow ProcedureLogs PUT/POST to use ProcStatus "R" for referred
- Replies: 7
- Views: 147097
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...
- Wed Mar 12, 2025 8:27 am
- Forum: API
- Topic: Best Way to Retrieve Deleted Patients via API
- Replies: 3
- Views: 15310
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 =...
- Sat Mar 08, 2025 4:25 pm
- Forum: API
- Topic: Request to Filter by ProcedureLog in /accountmodules endpoint
- Replies: 1
- Views: 1927
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...
- Sat Mar 08, 2025 3:56 pm
- Forum: API
- Topic: API Request: Addition of UserName Field in ClaimTrackings POST/PUT APIs
- Replies: 1
- Views: 1972
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 ...
- 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: 2254
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 ...
- Tue Mar 04, 2025 2:12 pm
- Forum: API
- Topic: EOBAttaches POST/ SFTP Upload
- Replies: 6
- Views: 3912
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...
- Mon Feb 24, 2025 9:43 am
- Forum: API
- Topic: UiEventType list?
- Replies: 2
- Views: 4771
Re: UiEventType list?
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...
- Mon Feb 24, 2025 9:32 am
- Forum: API
- Topic: Updating Operatories Based on Provider Availability & Scheduling Behavior
- Replies: 3
- Views: 3873
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...
- Mon Feb 24, 2025 9:19 am
- Forum: API
- Topic: Posting pay splits
- Replies: 1
- Views: 3246
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,...
- Fri Feb 21, 2025 3:30 pm
- Forum: Main Forum
- Topic: EOB question
- Replies: 1
- Views: 2173
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...
- Fri Feb 21, 2025 9:21 am
- Forum: API
- Topic: EOBAttaches POST/ SFTP Upload
- Replies: 6
- Views: 3912
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...
- Fri Feb 21, 2025 8:21 am
- Forum: API
- Topic: Best Way to Retrieve Deleted Patients via API
- Replies: 3
- Views: 15310
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...
- Thu Feb 20, 2025 9:16 am
- Forum: API
- Topic: Patient search improvement
- Replies: 5
- Views: 5993
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...
- Thu Feb 13, 2025 1:59 pm
- Forum: API
- Topic: API Request - ScheduleDeleted Subscription/Event
- Replies: 1
- Views: 3589
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...
- Thu Feb 13, 2025 10:57 am
- Forum: API
- Topic: EOBAttachesNum
- Replies: 1
- Views: 3365
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...
- Thu Feb 13, 2025 10:42 am
- Forum: API
- Topic: Patient search improvement
- Replies: 5
- Views: 5993
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...
- Mon Feb 03, 2025 12:09 pm
- Forum: API
- Topic: API Request DELETE treatplans
- Replies: 2
- Views: 4743
Re: API Request DELETE treatplans
Good afternoon rinse-dental,
I have added the ability to delete a treatplan by PK to our development list.
Thanks!
- Thu Jan 30, 2025 12:44 pm
- Forum: API
- Topic: Documents/DownloadSftp API
- Replies: 4
- Views: 3515
Re: Documents/DownloadSftp API
Hello aearl23,
POST documents DownloadSftp documentation clearly states that SftpUsername and SftpPassword fields are required.
Thanks!
- Thu Jan 30, 2025 12:29 pm
- Forum: API
- Topic: Documents/DownloadSftp API
- Replies: 4
- Views: 3515
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...
- Tue Jan 28, 2025 3:09 pm
- Forum: API
- Topic: API Request -- Documents Import?
- Replies: 2
- Views: 2595
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...
- Wed Jan 22, 2025 12:19 pm
- Forum: API
- Topic: API Request -- InsPlans
- Replies: 2
- Views: 19147
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...
- Tue Jan 21, 2025 11:16 am
- Forum: API
- Topic: API Request | ProcedureLogs GET (multiple) by ProcStatus, ProcCode
- Replies: 1
- Views: 2883
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...
- Tue Jan 21, 2025 9:15 am
- Forum: API
- Topic: Is there an api endpoint for daily production and income
- Replies: 1
- Views: 3197
Re: Is there an api endpoint for daily production and income
Hello AndyJordan,
Please see Reports FinanceCharges or run a custom production query using Queries ShortQuery.
Thanks!
- Mon Jan 20, 2025 11:11 am
- Forum: API
- Topic: Can't search for "Carole"
- Replies: 8
- Views: 19583
Re: Can't search for "Carole"
Thanks for the heads up, this ShortQuery endpoint enhancement is coming up next. I have added 'John Oslow' to the job/unit test requirements.graham_mueller wrote: ↑Mon Jan 20, 2025 11:04 amAn additional random word check that's failing-When searching for, eg, John Oslow.Code: Select all
Query cannot contain "SLOW".
Thanks!
- Mon Jan 20, 2025 10:43 am
- Forum: API
- Topic: pop-up -- disable or update?
- Replies: 2
- Views: 3791
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": ...
- Mon Jan 20, 2025 10:31 am
- Forum: API
- Topic: Cannot "Complete" procedures (bug?)
- Replies: 2
- Views: 3379
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...
- Mon Dec 30, 2024 11:01 am
- Forum: API
- Topic: MedicaidID on Patient POST and PUT?
- Replies: 4
- Views: 5013
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...
- Mon Dec 30, 2024 9:47 am
- Forum: API
- Topic: Golden age dental care API request
- Replies: 8
- Views: 11615
Re: Golden age dental care API request
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!
- Mon Dec 30, 2024 9:43 am
- Forum: API
- Topic: MedicaidID on Patient POST and PUT?
- Replies: 4
- Views: 5013
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....
- Mon Dec 30, 2024 9:33 am
- Forum: API
- Topic: Get Simple for schedules
- Replies: 2
- Views: 4303
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...
- Fri Dec 27, 2024 1:39 pm
- Forum: API
- Topic: BlueBook Selection
- Replies: 2
- Views: 3821
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...
- Mon Dec 23, 2024 10:39 am
- Forum: API
- Topic: Request: [POST] Audit Trail
- Replies: 10
- Views: 25988
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...
- Mon Dec 23, 2024 10:28 am
- Forum: API
- Topic: Golden age dental care API request
- Replies: 8
- Views: 11615
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...
- Wed Dec 11, 2024 9:21 am
- Forum: API
- Topic: Golden age dental care API request
- Replies: 8
- Views: 11615
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...
- Wed Dec 11, 2024 9:15 am
- Forum: API
- Topic: How to fetch Blockout types from OD
- Replies: 1
- Views: 3576
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...
- Mon Dec 09, 2024 9:43 am
- Forum: API
- Topic: Statement generation for patient
- Replies: 9
- Views: 23865
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), ...
- Sat Dec 07, 2024 2:30 pm
- Forum: API
- Topic: Statement generation for patient
- Replies: 9
- Views: 23865
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 ...
- Tue Dec 03, 2024 11:40 am
- Forum: API
- Topic: Deleted patient
- Replies: 4
- Views: 5994
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...
- Tue Dec 03, 2024 9:56 am
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 35903
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...
- Tue Dec 03, 2024 8:56 am
- Forum: API
- Topic: Method to Retrieve OD Version
- Replies: 2
- Views: 4195
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 ...
- Fri Nov 08, 2024 3:37 pm
- Forum: API
- Topic: Question | ProcTPs and 'Estimate as of'
- Replies: 4
- Views: 11006
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...
- Wed Nov 06, 2024 2:54 pm
- Forum: API
- Topic: API Event/Subscription - Tooth initial table support
- Replies: 10
- Views: 18012
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...
- Wed Nov 06, 2024 2:39 pm
- Forum: API
- Topic: CodeGroup AgeLimit Issue
- Replies: 2
- Views: 5401
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...
- Wed Nov 06, 2024 9:59 am
- Forum: API
- Topic: PayPlans POST NumberOfPayments
- Replies: 4
- Views: 6690
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...
- Mon Nov 04, 2024 9:47 am
- Forum: API
- Topic: API Event/Subscription - Tooth initial table support
- Replies: 10
- Views: 18012
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...
- Fri Nov 01, 2024 3:53 pm
- Forum: API
- Topic: Question | ProcTPs and 'Estimate as of'
- Replies: 4
- Views: 11006
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 ...
- Fri Nov 01, 2024 3:46 pm
- Forum: API
- Topic: Tasks API feature requests
- Replies: 6
- Views: 11407
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...
- Fri Nov 01, 2024 3:27 pm
- Forum: API
- Topic: Put for the oduser table
- Replies: 13
- Views: 22157
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...
- Fri Oct 25, 2024 3:21 pm
- Forum: API
- Topic: API Request | ProcedureLogs GET (multiple) - search by PlannedAptNum
- Replies: 4
- Views: 10503
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...
- Fri Oct 25, 2024 3:07 pm
- Forum: API
- Topic: PUT API for ProcTPs
- Replies: 4
- Views: 11456
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...
- Fri Oct 25, 2024 3:05 pm
- Forum: API
- Topic: Put for the oduser table
- Replies: 13
- Views: 22157
- Fri Oct 25, 2024 3:00 pm
- Forum: API
- Topic: Getting patient's last verified eligibility
- Replies: 4
- Views: 12707
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...
- Wed Oct 23, 2024 2:16 pm
- Forum: API
- Topic: Put for the oduser table
- Replies: 13
- Views: 22157
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...
- Wed Oct 23, 2024 2:15 pm
- Forum: API
- Topic: ODUSER Create/put update request
- Replies: 2
- Views: 8094
Re: ODUSER Create/put update request
Good afternoon rdillman,
I have added the ability to set userod.IsPasswordResetRequired to the API development list.
Thanks!
- Wed Oct 23, 2024 10:11 am
- Forum: API
- Topic: Fetching UCR Fee Schedule using API
- Replies: 2
- Views: 8039
Re: Fetching UCR Fee Schedule using API
Good morning abhishekcs028,abhishekcs028 wrote: ↑Tue Oct 22, 2024 10:14 amHi,
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
I believe the resource you are after is FeeScheds GET. See Fee Schedules for more information.
Thanks!
- 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: 9355
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...
- 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: 9355
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...
- Fri Oct 11, 2024 12:57 pm
- Forum: API
- Topic: Put for the oduser table
- Replies: 13
- Views: 22157
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...
- Fri Oct 11, 2024 12:51 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 35903
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...
- 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: 9355
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...
- Fri Oct 11, 2024 9:41 am
- Forum: API
- Topic: PUT API for ProcTPs
- Replies: 4
- Views: 11456
Re: PUT API for ProcTPs
Hello beacondental,beacondental wrote: ↑Thu Oct 10, 2024 3:27 amHi 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.
ProcTPs PUT has been added to our development list.
Thanks!
- Mon Oct 07, 2024 9:53 am
- Forum: API
- Topic: payments API: No procNums in Payments response
- Replies: 1
- Views: 6521
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 ...
- Tue Sep 17, 2024 10:01 am
- Forum: API
- Topic: Updating Orthodontic Maximum Not Reflecting in OpenDental UI
- Replies: 1
- Views: 7195
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...
- Tue Sep 17, 2024 9:38 am
- Forum: API
- Topic: API for Uploading Patient Eligibility Verification PDF
- Replies: 1
- Views: 6907
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...
- Wed Sep 11, 2024 7:52 am
- Forum: API
- Topic: Error in procedurelog API
- Replies: 1
- Views: 10890
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, ...
- Fri Sep 06, 2024 12:30 pm
- Forum: API
- Topic: Patient portion owed with appointment
- Replies: 1
- Views: 12649
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 ...
- Thu Aug 29, 2024 7:30 am
- Forum: API
- Topic: Planned Procedure Status
- Replies: 9
- Views: 24979
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 ...
- Wed Aug 28, 2024 11:15 am
- Forum: API
- Topic: API Request | Referrals GET - Add contact information
- Replies: 2
- Views: 15435
Re: API Request | Referrals GET - Add contact information
Good morning rinse-dental,rinse-dental wrote: ↑Wed Aug 28, 2024 11:03 amPlease add address, telephone and email information to the Referrals GET (single and multiple) API. Thank you.
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!
- Sat Aug 24, 2024 1:52 pm
- Forum: API
- Topic: Request: [POST] Audit Trail
- Replies: 10
- Views: 25988
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. ...
- Sat Aug 24, 2024 1:51 pm
- Forum: API
- Topic: Billing Estimate Endpoints
- Replies: 8
- Views: 23054
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...
- Thu Aug 22, 2024 8:59 am
- Forum: API
- Topic: Billing Estimate Endpoints
- Replies: 8
- Views: 23054
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...
- Tue Aug 20, 2024 11:26 am
- Forum: API
- Topic: Posting a statement to the account ledger
- Replies: 13
- Views: 28273
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...
- Mon Aug 19, 2024 3:09 pm
- Forum: API
- Topic: Posting a statement to the account ledger
- Replies: 13
- Views: 28273
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 ...
- Wed Aug 14, 2024 12:03 pm
- Forum: API
- Topic: Status URL
- Replies: 4
- Views: 10069
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...
- Wed Aug 14, 2024 11:52 am
- Forum: API
- Topic: Status URL
- Replies: 4
- Views: 10069
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 ...
- Mon Aug 12, 2024 9:20 am
- Forum: API
- Topic: Request: Allow ProcedureLogs PUT/POST to use ProcStatus "R" for referred
- Replies: 7
- Views: 147097
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...
- Fri Jun 28, 2024 8:12 am
- Forum: API
- Topic: Request: [POST] Audit Trail
- Replies: 10
- Views: 25988
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...
- Fri Jun 28, 2024 7:37 am
- Forum: API
- Topic: Request: [POST] Audit Trail
- Replies: 10
- Views: 25988
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...
- Tue Jun 25, 2024 2:21 pm
- Forum: API
- Topic: Adjustment API
- Replies: 4
- Views: 12112
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!
SecUserNumEntry, DateEntry, and SecDateTEdit has been added to the adjustments endpoint. This enhancement is available in Open Dental version 24.1.44.
Thanks!
- Tue Jun 25, 2024 1:53 pm
- Forum: API
- Topic: Appointment Summary View
- Replies: 7
- Views: 17138
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 ...
- 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: 12442
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...
- Thu Jun 13, 2024 3:10 pm
- Forum: API
- Topic: Referrals API Update
- Replies: 4
- Views: 10405
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...
- Tue Jun 04, 2024 8:29 am
- Forum: API
- Topic: API to Get, Post Task Notes
- Replies: 1
- Views: 6938
Re: API to Get, Post Task Notes
Good morning SriramChellappan,SriramChellappan wrote: ↑Tue Jun 04, 2024 3:42 amI see APIs for Tasks, however I don't see any APIs for tasknotes.
You are correct, we currently do not have a taskNotes endpoint.
- Tue May 28, 2024 11:18 am
- Forum: API
- Topic: Updated the Claim.CustomTracking column after ClaimTrackings POST API completed
- Replies: 4
- Views: 12330
- Tue May 28, 2024 11:17 am
- Forum: API
- Topic: API Recalls
- Replies: 4
- Views: 15709
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", "...
- Thu May 16, 2024 3:08 pm
- Forum: API
- Topic: Intial versus replacement reason
- Replies: 3
- Views: 7619
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...
- Thu May 16, 2024 11:31 am
- Forum: API
- Topic: Request webhook for blockout slots
- Replies: 10
- Views: 18131
- Thu May 16, 2024 11:20 am
- Forum: API
- Topic: Intial versus replacement reason
- Replies: 3
- Views: 7619
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...
- Fri May 03, 2024 4:01 pm
- Forum: API
- Topic: Computer heartbeat timezone
- Replies: 1
- Views: 4854
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...
- Fri May 03, 2024 3:41 pm
- Forum: API
- Topic: Posting a statement to the account ledger
- Replies: 13
- Views: 28273
Re: Posting a statement to the account ledger
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!
- Fri May 03, 2024 3:34 pm
- Forum: API
- Topic: DownloadSftp not working via API / Can't view API logs
- Replies: 1
- Views: 4618
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 ...
- Tue Apr 16, 2024 3:02 pm
- Forum: API
- Topic: API Request | GET/POST/PUT/DELETE LAB CASES
- Replies: 5
- Views: 13983
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...
- Tue Apr 02, 2024 3:51 pm
- Forum: API
- Topic: Pharmacy GET & POST
- Replies: 3
- Views: 5580
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...
- Tue Apr 02, 2024 2:57 pm
- Forum: API
- Topic: Missing [Delete] /Documents
- Replies: 4
- Views: 11282
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...
- Sat Mar 30, 2024 1:46 pm
- Forum: API
- Topic: Pharmacy GET & POST
- Replies: 3
- Views: 5580
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...
- Sat Mar 30, 2024 1:39 pm
- Forum: API
- Topic: Custom logtext for audit trails
- Replies: 3
- Views: 6245
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 ...
- Sat Mar 30, 2024 12:16 pm
- Forum: API
- Topic: Missing [Delete] /Documents
- Replies: 4
- Views: 11282
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 "...
- Thu Mar 28, 2024 12:51 pm
- Forum: API
- Topic: Insurance card information- API to store
- Replies: 2
- Views: 6827
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...
- Thu Mar 21, 2024 9:20 am
- Forum: API
- Topic: Name and version don't match
- Replies: 1
- Views: 4342
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...
- Wed Mar 20, 2024 10:00 am
- Forum: API
- Topic: Need help for Benefits PUT API
- Replies: 1
- Views: 4006
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...
- Wed Mar 20, 2024 9:44 am
- Forum: API
- Topic: Database connection issue
- Replies: 1
- Views: 4405
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...
- Mon Mar 18, 2024 10:29 am
- Forum: API
- Topic: Custom logtext for audit trails
- Replies: 3
- Views: 6245
Re: Custom logtext for audit trails
Good morning beacondental,beacondental wrote: ↑Mon Mar 18, 2024 9:59 amHi 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?
No, it is not possible to change the logtext on Audit Trails within Open Dental or via the API.
Thanks!
- Mon Mar 18, 2024 9:44 am
- Forum: API
- Topic: API Availability Check?
- Replies: 6
- Views: 7251
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...
- Mon Mar 18, 2024 9:19 am
- Forum: API
- Topic: Request webhook for blockout slots
- Replies: 10
- Views: 18131
Re: Request webhook for blockout slots
Good morning Smilelink,
We can add the ability to create schedule subscriptions.
We will reply to this thread once the request is complete.
Thanks!
- Mon Mar 18, 2024 9:01 am
- Forum: API
- Topic: API Availability Check?
- Replies: 6
- Views: 7251
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...
- Fri Mar 15, 2024 2:51 pm
- Forum: API
- Topic: Updated the Claim.CustomTracking column after ClaimTrackings POST API completed
- Replies: 4
- Views: 12330
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 ...
- Thu Mar 14, 2024 4:44 pm
- Forum: API
- Topic: API Availability Check?
- Replies: 6
- Views: 7251
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...
- Wed Mar 13, 2024 1:49 pm
- Forum: API
- Topic: Generating keys via API
- Replies: 2
- Views: 4464
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 ...
- Tue Mar 12, 2024 2:46 pm
- Forum: API
- Topic: Request webhook for blockout slots
- Replies: 10
- Views: 18131
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...
- Tue Mar 05, 2024 7:34 am
- Forum: API
- Topic: ECONNRESET when attempting PUT ShortQuery with Offset
- Replies: 4
- Views: 5776
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!
I apologize for the timeout misunderstanding. I'm glad you found a solution and shared it on the forums.
Thanks!
- Mon Mar 04, 2024 2:51 pm
- Forum: API
- Topic: ECONNRESET when attempting PUT ShortQuery with Offset
- Replies: 4
- Views: 5776
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...
- Tue Feb 27, 2024 5:50 pm
- Forum: API
- Topic: Adjustment API
- Replies: 4
- Views: 12112
Re: Adjustment API
Ahh, I understand. I have added returning secUserNumEntry to the adjustments GET response to the API development list.jasoncartercs wrote: ↑Tue Feb 27, 2024 5:30 pmMy question was not clear. The secUserNumEntry is not a part of the Adjustment endpoint. Is there a way to add it?
Thanks!
- Tue Feb 27, 2024 5:17 pm
- Forum: API
- Topic: Request webhook for blockout slots
- Replies: 10
- Views: 18131
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...
- Tue Feb 27, 2024 5:09 pm
- Forum: API
- Topic: Adjustment API
- Replies: 4
- Views: 12112
Re: Adjustment API
We do not allow setting secUserNumEntry via the API. secUserNumEntry will always be 0 when an endpoint is inserted via API.jasoncartercs wrote: ↑Tue Feb 27, 2024 1:02 pmIs 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.
Thanks!
- Tue Feb 27, 2024 4:49 pm
- Forum: API
- Topic: Tasks API - PUT with TaskStatus
- Replies: 4
- Views: 10316
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! ...
- Tue Feb 20, 2024 8:20 pm
- Forum: API
- Topic: "Duration" of X and / setting
- Replies: 3
- Views: 6557
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,...
- Mon Feb 19, 2024 3:18 pm
- Forum: API
- Topic: Request webhook for blockout slots
- Replies: 10
- Views: 18131
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...
- Fri Feb 16, 2024 1:52 pm
- Forum: API
- Topic: **URGENT BENEFITS ISSUE**
- Replies: 19
- Views: 32035
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...
- Fri Feb 16, 2024 9:38 am
- Forum: API
- Topic: **URGENT BENEFITS ISSUE**
- Replies: 19
- Views: 32035
- Wed Feb 14, 2024 8:35 am
- Forum: API
- Topic: **URGENT BENEFITS ISSUE**
- Replies: 19
- Views: 32035
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...
- Wed Feb 14, 2024 8:01 am
- Forum: API
- Topic: **URGENT BENEFITS ISSUE**
- Replies: 19
- Views: 32035
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...
- Tue Feb 13, 2024 3:16 pm
- Forum: API
- Topic: Open Dental 23.2 Benefit API does not have CodeGroup
- Replies: 4
- Views: 6380
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...
- Tue Feb 13, 2024 3:11 pm
- Forum: API
- Topic: **URGENT BENEFITS ISSUE**
- Replies: 19
- Views: 32035
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...
- Thu Feb 08, 2024 8:42 am
- Forum: API
- Topic: **URGENT BENEFITS ISSUE**
- Replies: 19
- Views: 32035
Re: **URGENT BENEFITS ISSUE**
Unfortunately no, there is not. CodeGroups GET is currently in development. I have added CodeGroups PUT/POST to the API development list.
Thanks!
- Wed Feb 07, 2024 1:35 pm
- Forum: API
- Topic: **URGENT BENEFITS ISSUE**
- Replies: 19
- Views: 32035
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...
- Wed Jan 31, 2024 10:51 am
- Forum: API
- Topic: API Events Question
- Replies: 20
- Views: 22847
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...
- Wed Jan 31, 2024 10:19 am
- Forum: API
- Topic: API Events Question
- Replies: 20
- Views: 22847
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...
- Tue Jan 30, 2024 4:02 pm
- Forum: API
- Topic: API Events Question
- Replies: 20
- Views: 22847
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 ...
- Tue Jan 30, 2024 3:06 pm
- Forum: API
- Topic: API Events Question
- Replies: 20
- Views: 22847
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 ...
- Tue Jan 30, 2024 2:01 pm
- Forum: API
- Topic: API Events Question
- Replies: 20
- Views: 22847
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...
- Mon Jan 29, 2024 1:55 pm
- Forum: API
- Topic: Posting a statement to the account ledger
- Replies: 13
- Views: 28273
Re: Posting a statement to the account ledger
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!
- Mon Jan 29, 2024 11:36 am
- Forum: API
- Topic: API Events Question
- Replies: 20
- Views: 22847
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...
- Thu Jan 25, 2024 2:56 pm
- Forum: API
- Topic: API Events Question
- Replies: 20
- Views: 22847
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...
- Thu Jan 25, 2024 1:33 pm
- Forum: API
- Topic: API Events Question
- Replies: 20
- Views: 22847
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...
- Thu Jan 25, 2024 12:59 pm
- Forum: API
- Topic: API Events Question
- Replies: 20
- Views: 22847
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...
- Sat Jan 20, 2024 10:54 am
- Forum: API
- Topic: Open Dental 23.2 Benefit API does not have CodeGroup
- Replies: 4
- Views: 6380
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...
- Wed Dec 27, 2023 10:23 am
- Forum: API
- Topic: Appointment Slots (proposal for API)
- Replies: 9
- Views: 13526
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 ...
- Thu Dec 14, 2023 9:58 am
- Forum: API
- Topic: Daterange support for ProcedureLogs GET
- Replies: 5
- Views: 6537
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...
- Wed Dec 13, 2023 2:01 pm
- Forum: API
- Topic: Daterange support for ProcedureLogs GET
- Replies: 5
- Views: 6537
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 ...
- Wed Dec 13, 2023 1:52 pm
- Forum: API
- Topic: TreatPlans POST
- Replies: 36
- Views: 55848
- Sat Dec 09, 2023 10:44 am
- Forum: API
- Topic: API for web forms
- Replies: 6
- Views: 10267
Re: API for web forms
The Sheets endpoint now returns sheet.IsWebform. This enhancement is available in version 23.3.14.
- Mon Dec 04, 2023 2:25 pm
- Forum: API
- Topic: Getting several documents for a patient at a time
- Replies: 2
- Views: 4444
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...
- Mon Nov 20, 2023 12:40 pm
- Forum: API
- Topic: patient field defs
- Replies: 4
- Views: 7859
Re: patient field defs
Yes. I have added patfieldDefs POST and PUT to our development list. For additional information, please see patFields POST.
Thanks!
- Mon Nov 20, 2023 11:59 am
- Forum: API
- Topic: patient field defs
- Replies: 4
- Views: 7859
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...
- Thu Nov 16, 2023 11:28 am
- Forum: API
- Topic: Benefit API Issue
- Replies: 7
- Views: 10230
Re: Benefit API Issue
CovCats GET is complete and is available the version 23.3.8.
Please see CovCats for more information.
Thanks!
Please see CovCats for more information.
Thanks!
- Thu Oct 19, 2023 10:46 am
- Forum: API
- Topic: REQUEST: PUT refattaches
- Replies: 2
- Views: 5529
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...
- Wed Oct 18, 2023 9:48 am
- Forum: API
- Topic: Request benefits in family module
- Replies: 13
- Views: 18761
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...
- Thu Oct 12, 2023 2:41 pm
- Forum: API
- Topic: Bulk update comm log
- Replies: 7
- Views: 9416
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 ...
- Thu Oct 12, 2023 2:00 pm
- Forum: API
- Topic: Bulk update comm log
- Replies: 7
- Views: 9416
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...
- Mon Oct 09, 2023 11:10 am
- Forum: API
- Topic: Posting payments for dynamic payment plans
- Replies: 16
- Views: 17015
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...
- Mon Oct 02, 2023 3:12 pm
- Forum: API
- Topic: POST DiscountPlanSub defect
- Replies: 4
- Views: 6800
Re: POST DiscountPlanSub defect
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!
- Mon Sep 25, 2023 10:05 am
- Forum: API
- Topic: POST DiscountPlanSub defect
- Replies: 4
- Views: 6800
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 ...
- Mon Sep 18, 2023 1:07 pm
- Forum: API
- Topic: Add OrthoRemainM to Claim PUT API
- Replies: 4
- Views: 8177
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!
OrthoRemainM has been added to Claims PUT and is available in version 23.2.18.
Thanks!
- Wed Sep 06, 2023 9:46 am
- Forum: API
- Topic: Program Link Triggered E-Mail for Next appointment using n8n
- Replies: 10
- Views: 17138
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...
- Thu Aug 31, 2023 2:35 pm
- Forum: API
- Topic: Looking for ideas on eliminating data synchronization feedback loop
- Replies: 11
- Views: 12838
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...
- Thu Aug 31, 2023 10:41 am
- Forum: API
- Topic: Looking for ideas on eliminating data synchronization feedback loop
- Replies: 11
- Views: 12838
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...
- Thu Aug 31, 2023 10:02 am
- Forum: API
- Topic: Looking for ideas on eliminating data synchronization feedback loop
- Replies: 11
- Views: 12838
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...
- Wed Aug 30, 2023 2:27 pm
- Forum: API
- Topic: Looking for ideas on eliminating data synchronization feedback loop
- Replies: 11
- Views: 12838
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?...
- Wed Aug 30, 2023 12:15 pm
- Forum: API
- Topic: Looking for ideas on eliminating data synchronization feedback loop
- Replies: 11
- Views: 12838
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...
- Thu Jul 13, 2023 3:04 pm
- Forum: API
- Topic: Confirmation status
- Replies: 6
- Views: 10901
- Wed Jul 05, 2023 3:11 pm
- Forum: API
- Topic: Payments POST - set payType
- Replies: 18
- Views: 23944
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,...
- Wed Jul 05, 2023 12:28 pm
- Forum: API
- Topic: Prepayments for dynamic payment plans
- Replies: 6
- Views: 10147
- Wed Jul 05, 2023 12:26 pm
- Forum: API
- Topic: Payments POST - set payType
- Replies: 18
- Views: 23944
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...
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...
- Mon Jul 03, 2023 8:40 am
- Forum: API
- Topic: Confirmation status
- Replies: 6
- Views: 10901
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...
- Fri Jun 30, 2023 7:13 am
- Forum: API
- Topic: API ProcTPs question
- Replies: 10
- Views: 13607
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...
- Tue Jun 27, 2023 9:48 am
- Forum: API
- Topic: API query error message
- Replies: 4
- Views: 7234
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...
- Tue Jun 20, 2023 7:55 am
- Forum: API
- Topic: New API for Fam Aging Balance
- Replies: 6
- Views: 9510
- Thu Jun 15, 2023 9:36 am
- Forum: API
- Topic: New API for Fam Aging Balance
- Replies: 6
- Views: 9510
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...
- Tue Jun 13, 2023 3:49 pm
- Forum: API
- Topic: API FeeScheds Request
- Replies: 8
- Views: 12860
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...
- Tue Jun 13, 2023 8:06 am
- Forum: API
- Topic: New API for Fam Aging Balance
- Replies: 6
- Views: 9510
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 ...
- Mon Jun 12, 2023 8:59 am
- Forum: API
- Topic: API ProcTPs question
- Replies: 10
- Views: 13607
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...
- Wed Jun 07, 2023 12:39 pm
- Forum: API
- Topic: API ProcTPs question
- Replies: 10
- Views: 13607
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...
- Wed Jun 07, 2023 8:21 am
- Forum: API
- Topic: Income transfer manager
- Replies: 5
- Views: 9485
Re: Income transfer manager
No, there is not.beacondental wrote: ↑Tue Jun 06, 2023 7:51 pmIs there a way to run the income transfer manager thru the API short query?
- Tue Jun 06, 2023 2:41 pm
- Forum: API
- Topic: Patient portal API
- Replies: 3
- Views: 7354
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...
- Tue Jun 06, 2023 9:07 am
- Forum: API
- Topic: Question on DiscountPlanSubs DELETE
- Replies: 1
- Views: 4734
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...
- Thu Jun 01, 2023 12:54 pm
- Forum: API
- Topic: TreatPlanAttaches GET
- Replies: 7
- Views: 11982
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...
- Thu Jun 01, 2023 7:54 am
- Forum: API
- Topic: TreatPlanAttaches GET
- Replies: 7
- Views: 11982
- Wed May 31, 2023 1:54 pm
- Forum: API
- Topic: TreatPlanAttaches GET
- Replies: 7
- Views: 11982
Re: TreatPlanAttaches GET
- Wed May 31, 2023 1:45 pm
- Forum: API
- Topic: TreatPlanAttaches GET
- Replies: 7
- Views: 11982
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...
- Mon May 22, 2023 3:26 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 35903
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...
- Mon May 22, 2023 2:09 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 18
- Views: 35903
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...