Search found 476 matches

by SLeon
Thu Feb 15, 2024 9:08 am
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 13
Views: 4054

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

I would recommend checking out our Query Examples page to see if an existing one will work for you. There is insurance Used, Pending, and Remaining data returned in #1243, for example. You can also follow the instructions and link at the top of that page to request Open Dental's Query Team to write ...
by SLeon
Tue Feb 13, 2024 3:29 pm
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 13
Views: 4054

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.Mo...
by SLeon
Tue Feb 13, 2024 1:18 pm
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 18
Views: 1207

Re: **URGENT BENEFITS ISSUE**

Can you also add a DELETE function? What would be the ETA on these? Thank you Benefits DELETE already exists and has been available since version 22.4. The enhancement to Benefits to support CodeGroups just finished development today. You can expect it and the documentation to be released shortly i...
by SLeon
Fri Feb 09, 2024 11:38 am
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 13
Views: 4054

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

Good morning, Because calculating estimates is expensive computationally, Open Dental very intentionally only performs this logic when needed. This is why, as you said, it is described in our manual as a 'feature': "Estimated patient portion for attached procedures. (patient portion = gross producti...
by SLeon
Tue Feb 06, 2024 7:37 am
Forum: API
Topic: Fam Urgent Fin Note:
Replies: 1
Views: 302

Re: Fam Urgent Fin Note:

Moving your API question to the API forum.

The Fam Urgent Fin Note is stored in the FamFinUrgNote field of the patient table on the family's guarantor. You can use the Patients GET (single) endpoint on the guarantor to obtain this information and Patients PUT to edit it.
by SLeon
Mon Jan 29, 2024 3:36 pm
Forum: API
Topic: Documents POST Upload - Profile Photo
Replies: 4
Views: 542

Re: Documents POST Upload - Profile Photo

Good afternoon Becker, As DerekR mentioned, the requirement for an Open Dental user to click an object after using the Documents POST Upload endpoint is not a bug. It is described in our documentation here: "The customer never sees this text, but when they later click on the document, the file is cr...
by SLeon
Mon Jan 29, 2024 8:11 am
Forum: API
Topic: Issues making any requests
Replies: 2
Views: 507

Re: Issues making any requests

Good morning, Are you trying to use the Local or the Service mode of the API? Your URL uses port 30223, which would indcate the API Service, but you also mention running Open Dental as admin, which is necessary only for the Local mode. I would first recommend reading ang following the troubleshootin...
by SLeon
Thu Jan 25, 2024 2:08 pm
Forum: API
Topic: Posting a statement to the account ledger
Replies: 3
Views: 1084

Re: Posting a statement to the account ledger

Good afternoon,

Could you please clarify if you would like to make statements via the API or if you are wanting to mark a statement made in Open Dental as "Sent" via the API? We do not have an endpoint for either in the API currently.
by SLeon
Wed Jan 24, 2024 12:00 pm
Forum: API
Topic: API Queries POST architecture question
Replies: 1
Views: 415

Re: API Queries POST architecture question

Yes. The machine where the OpenDentalEConnector.exe is installed and running will connect to your Sftp site. The eConnector is safe and all data transferred over its channel (to and from) is secure. More information on its encryption can be found in our manual.
by SLeon
Mon Jan 22, 2024 8:51 am
Forum: API
Topic: Appointment Slots (proposal for API)
Replies: 9
Views: 2618

Re: Appointment Slots (proposal for API)

Good morning, I understand that you are not seeing the results you expect when using Appointment GET Slots. I am the engineer who wrote this method, and am happy to clear up any issues. You are also welcome to email us at the email address found in the Developer Portal (click Contact Us). The latter...
by SLeon
Fri Jan 19, 2024 1:40 pm
Forum: API
Topic: Appointment Slots (proposal for API)
Replies: 9
Views: 2618

Re: Appointment Slots (proposal for API)

Good afternoon, The Appointments GET Slots endpoint was released in the very first version of the API (21.1). As mentioned in its documentation, it is meant for dental offices for simple scheduling setups and works almost identically to the standard appointment search found within Open Dental. My ex...
by SLeon
Wed Jan 10, 2024 3:10 pm
Forum: API
Topic: Subscription issues
Replies: 1
Views: 750

Re: Subscription issues

Good afternoon,

Please try the troubleshooting steps found in our API Guide - Subscriptions and Events in the "Unable to see an event on your webhook service" section.

Let us know if you continue to have issues.
by SLeon
Wed Jan 10, 2024 2:16 pm
Forum: API
Topic: Dynamic payment plans amount discrepency
Replies: 3
Views: 937

Re: Dynamic payment plans amount discrepency

Thank you very much for this information. You are specifying a "principalAmount" value in your payload. You cannot set this value in the PayPlans POST Dynamic endpoint in the API. You also cannot specify a total loan amount for DPPs in Open Dental. Quoting our web manual , with additional underlinin...
by SLeon
Wed Jan 10, 2024 9:40 am
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 8062

Re: TreatPlans POST

Good morning, Yes, you can delete proccodes from a treatment plan (called ProcTPs in our schema) using the ProcTPs DELETE endpoint. This was completed in November and is available in versions 23.3.10 and later. One of the feature requests, ProcTPs DELETE, has been completed. This method allows you t...
by SLeon
Wed Jan 10, 2024 9:31 am
Forum: API
Topic: Dynamic payment plans amount discrepency
Replies: 3
Views: 937

Re: Dynamic payment plans amount discrepency

Could you please elaborate on the following points for us to be able to answer your question? pricing on the procedure for what the patient owes is incorrect Are these created in OD or via the API? Are these Completed procedures? How is the "what the patient owes" incorrect and how are you making th...
by SLeon
Wed Jan 10, 2024 8:41 am
Forum: API
Topic: API Request/Help - Time Cards
Replies: 6
Views: 1937

Re: API Request/Help - Time Cards

Good morning, We have completed the first part of your Feature Request. Employees GET has been added with GET (single) and GET (multiple) endpoints. This is available in our latest beta, version 23.3.22. Development on ClockEvents GET will start soon, and we will update this thread once it is comple...
by SLeon
Wed Jan 10, 2024 8:34 am
Forum: API
Topic: New API feature requests
Replies: 2
Views: 2127

Re: New API feature requests

We have completed the above feature requests. 1-6. Already complete. 7-8. InsPlans GET - CopayFeeSched is now present in the return object. This field can now also be set in the PUT and POST method. This functionality is available in version 23.3.17 and later. 9. ProcedureLogs GET (multiple) - Clini...
by SLeon
Tue Jan 09, 2024 11:28 am
Forum: API
Topic: API FeeScheds Request
Replies: 8
Views: 4012

Re: API FeeScheds Request

You can set the fee amount for a specific procedure/fee schedule using the Fees POST and PUT endpoints.
by SLeon
Mon Jan 08, 2024 10:11 am
Forum: Main Forum
Topic: Duplicate records in the PerioMeasure table.
Replies: 2
Views: 1005

Re: Duplicate records in the PerioMeasure table.

We recommend you contact support for help with this issue.
by SLeon
Fri Jan 05, 2024 9:03 am
Forum: API
Topic: Appointment Summary View
Replies: 5
Views: 2185

Re: Appointment Summary View

Good morning, There is no field corresponding to "planned priority" in the appointments table, so we cannot add the field to the Appointments GET (single/multiple) endpoints. This information is in the PlannedAppt table, so I have added this GET to our development list. There is no corresponding fie...
by SLeon
Tue Jan 02, 2024 10:35 am
Forum: API
Topic: Issue with Claims API
Replies: 1
Views: 983

Re: Issue with Claims API

I move this topic from the Main Forum to the API forums. The message, "ProcNum(s) ... are invalid for this patient." will occur when the procNums you supply are not valid for the PatNum you supplied. Are the corresponding procedures for the correct patient? Also, note the casing for "PatNum" and "Cl...
by SLeon
Tue Dec 26, 2023 8:43 am
Forum: Main Forum
Topic: Plugin Forum Posts Deleted
Replies: 1
Views: 2475

Re: Plugin Forum Posts Deleted

Good morning,

Posts previously in the "Plug-ins" category have been moved to the "Main Forum" and "Developers" categories.
by SLeon
Fri Dec 15, 2023 8:20 am
Forum: Main Forum
Topic: dreaded duplicate entry key primary
Replies: 2
Views: 1508

Re: dreaded duplicate entry key primary

I recommend calling support for help on this issue.
by SLeon
Mon Dec 11, 2023 12:48 pm
Forum: API
Topic: Appointment Summary View
Replies: 5
Views: 2185

Re: Appointment Summary View

I am still unable to run your query (I replaced the aptnum in both this and the previous one) so I do appreciate you sharing the return payload. Our API methods are analogous to either SQL queries to a single table (Appointments GET) or a report shown in Open Dental's UI (AccountModules GET ServiceD...
by SLeon
Fri Dec 08, 2023 3:38 pm
Forum: API
Topic: Local API Service Authorization
Replies: 3
Views: 1674

Re: Local API Service Authorization

Your 'Authorization' header in Local/Service API Modes will be the same as the 'Authorization" header you already use in your Remote API requests.
by SLeon
Fri Dec 08, 2023 9:27 am
Forum: API
Topic: New API feature requests
Replies: 2
Views: 2127

Re: New API feature requests

We have completed another feature request from the above list. 1-6. Already complete. 7. Currently in development. 8. Currently in development. 9. ProcedureLogs GET now has an optional ClinicNum parameter. This new functionality is available starting in version 23.3.13. 10. Currently in development.
by SLeon
Fri Dec 08, 2023 8:15 am
Forum: API
Topic: Local API Service Authorization
Replies: 3
Views: 1674

Re: Local API Service Authorization

Good morning, First, please see our documentation on the Local API and API Service. There is also a getting started guide on the API Service specifically. The Remote, Local, and Service modes of the API all use the same set of credentials for a dental office, there is no additional "registration" re...
by SLeon
Wed Dec 06, 2023 9:07 am
Forum: API
Topic: Appointment Summary View
Replies: 5
Views: 2185

Re: Appointment Summary View

Good morning, These are great questions and thank you for supplying the queries you are using. Get Patient Visits I ran your Patient Visits query in a local environment and the results are extremely similar to the output of the Appointments GET (multiple) endpoint with the optional PatNum parameter....
by SLeon
Tue Dec 05, 2023 10:05 am
Forum: API
Topic: Open Dental Events API
Replies: 6
Views: 1930

Re: Open Dental Events API

I do understand your concern, that keeping patient balance information up to date is computationally expensive. It is for this very reason that Open Dental does not run the aging logic each time a balance-impacting change is made. As you mention, doing so would be very complex. This is why most deve...
by SLeon
Mon Dec 04, 2023 3:35 pm
Forum: API
Topic: Open Dental Events API
Replies: 6
Views: 1930

Re: Open Dental Events API

Would creating a way for you to subscribe to the procedurelog table be helpful? An event would trigger whenever a change was made to the table, be it from a dental office user or the API, and you would receive the webhook on your site with that row in the database. Your logic could then grab the pat...
by SLeon
Mon Dec 04, 2023 2:57 pm
Forum: API
Topic: Open Dental Events API
Replies: 6
Views: 1930

Re: Open Dental Events API

Good afternoon, These are great questions and concerns that I am happy to elaborate upon. ApiEvents In addition to viewing the documentation you linked, I would recommend reading API Guide – Subscriptions and Events . It contains an extended description of ApiEvents, how they can be used, and some e...
by SLeon
Mon Dec 04, 2023 8:23 am
Forum: Main Forum
Topic: Windows 11 support
Replies: 1
Views: 1657

Re: Windows 11 support

Yes, Open Dental can run on Windows 11. Please see our Computer Requirements manual page for a full list of supported operating systems.
by SLeon
Mon Dec 04, 2023 8:19 am
Forum: API
Topic: Issue with planType field
Replies: 1
Views: 1377

Re: Issue with planType field

I moved your API question to the API section of our forum. The FamilyModule GET Insurance method returns information similar to what is displayed in Insurance Section of Open Dental's Family Module . There is more information on plan types on its manual page here Also, from our API documentation: .....
by SLeon
Fri Dec 01, 2023 10:29 am
Forum: API
Topic: New API feature requests
Replies: 2
Views: 2127

New API feature requests

A few developers have recently emailed us with API feature requests. The API forums are the best place for these, so I am posting them here for visibility. 1. ScheduleOps GET - This new method was added in 23.2.27. 2. Appointments GET (multiple) - Add optional Op (operatory) parameter. This was comp...
by SLeon
Tue Nov 28, 2023 1:59 pm
Forum: API
Topic: API Request/Help - Time Cards
Replies: 6
Views: 1937

Re: API Request/Help - Time Cards

API feature requests are started in the order in which they are received. I would estimate these to be completed in 6-8 weeks, and we will update this thread with our progress. :)
by SLeon
Tue Nov 28, 2023 1:33 pm
Forum: API
Topic: API Request/Help - Time Cards
Replies: 6
Views: 1937

Re: API Request/Help - Time Cards

Good afternoon, Most of the data you are after is stored in the ClockEvent table. I would recommend referencing our schema here . We can add a ClockEvents GET endpoint to our development list. You will also need to obtain employee information from the Employee table, since the ClockEvent table only ...
by SLeon
Tue Nov 28, 2023 8:27 am
Forum: API
Topic: Data Mismatch between Definition Table Primary Key Value Defnums and Commlog Table for CommType
Replies: 3
Views: 1513

Re: Data Mismatch between Definition Table Primary Key Value Defnums and Commlog Table for CommType

Good morning, Thank you for that clarification. The commlog.CommType field was an Enumeration datatype and not a definition in Open Dental versions before 5.5.0. If the dental office was on an early version of Open Dental in the 2019-2020 time frame, that may explain the difference you are seeing. T...
by SLeon
Tue Nov 21, 2023 3:30 pm
Forum: API
Topic: API For Client Keys?
Replies: 4
Views: 1531

Re: API For Client Keys?

Would it be possible in that workflow to keep a list of unassigned API keys handy (internally) that your staff can distribute to the customer?
by SLeon
Tue Nov 21, 2023 3:17 pm
Forum: API
Topic: API For Client Keys?
Replies: 4
Views: 1531

Re: API For Client Keys?

Good afternoon, The version the dental office is on is stored in the preference table as "ProgramVersion". You can use Preferences GET or Queries PUT ShortQuery to obtain this value. It will be in the form of #.#.#.0 (eg 23.3.9.0). As far as generating keys, the current plan is to keep that to the D...
by SLeon
Tue Nov 21, 2023 10:57 am
Forum: API
Topic: New API Request for all patients aging balance
Replies: 6
Views: 2297

Re: New API Request for all patients aging balance

Good morning, The query ran in AccountModules GET Aging is large, complex, and takes longer to execute than most of our other endpoints for this reason. We limit this endpoint to a single patient for three reasons: Because this query takes longer to execute, calling it for multiple patients in a sin...
by SLeon
Tue Nov 21, 2023 9:51 am
Forum: API
Topic: Data Mismatch between Definition Table Primary Key Value Defnums and Commlog Table for CommType
Replies: 3
Views: 1513

Re: Data Mismatch between Definition Table Primary Key Value Defnums and Commlog Table for CommType

Good morning, There are antiquated records in the 'CommLog' table that contain 'commType' values that do not correspond to a 'CommLogType' (i.e., a definition entry with a 'Category' of 27). You are seeing old commlogs in the dental office's database that do not correspond to a CommLogType/Category=...
by SLeon
Thu Nov 16, 2023 10:45 am
Forum: Main Forum
Topic: Add Hook for the Plugin
Replies: 9
Views: 3151

Re: Add Hook for the Plugin

I have added these additional hooks to our list and we will update this thread once the is complete.

Note that the first of these four was completed in the original job. It was backported to 23.3.5, so the surrounding code will look different than your current version (22.4).
by SLeon
Tue Nov 14, 2023 1:55 pm
Forum: API
Topic: Appointments PUT Confirm (add value)
Replies: 1
Views: 1208

Re: Appointments PUT Confirm (add value)

Good afternoon, The "confirmVal" options are confined to the ones listed to the documentation as a result of how they are mapped for eConfirmations. Each one corresponds to a preference set by the Dental Office. PrefName.ApptEConfirmStatusSent - "Sent" PrefName.ApptEConfirmStatusAccepted - "Confirme...
by SLeon
Fri Nov 10, 2023 2:46 pm
Forum: API
Topic: Deprecation of PayPlans POST
Replies: 12
Views: 3991

Re: Deprecation of PayPlans POST

If we were to do everything via the API I think we'd first have to GET PatientBalances to get us a list of patients with balances, and then make another call (GET ServiceDateView) for each patient with a balance (often hundreds!). Or is there a more efficient way to get the data we're after? This d...
by SLeon
Thu Nov 09, 2023 9:11 am
Forum: API
Topic: New API Request for all patients aging balance
Replies: 6
Views: 2297

Re: New API Request for all patients aging balance

AccountModules GET Aging returns the same information found in the Aging grid at the top of the Account Module. From the Account Module page of our manual: ... Ins Est: Displays expected insurance payments for the entire family (estimated insurance payments + estimated write-offs). This number only ...
by SLeon
Wed Nov 01, 2023 3:12 pm
Forum: API
Topic: Deprecation of PayPlans POST
Replies: 12
Views: 3991

Re: Deprecation of PayPlans POST

... Is there any more information on the service date view? ... The API method AccountModules GET ServiceDateView is directly based on the Service Date View in Open Dental. You will see in the link's screenshot that all charges on the account are detailed and you can determine what has been paid. Y...
by SLeon
Wed Nov 01, 2023 8:12 am
Forum: API
Topic: New API Request for all patients aging balance
Replies: 6
Views: 2297

Re: New API Request for all patients aging balance

Good morning, Both of the API methods you mention calculate and update account balances before returning. If you want to get the aging data for a family you can either: Run AccountModules GET Aging for each member of the family. (Recommended) Run Reports GET Aging and parse out only the patients in ...
by SLeon
Tue Oct 31, 2023 10:07 am
Forum: Main Forum
Topic: Add Hook for the Plugin
Replies: 9
Views: 3151

Re: Add Hook for the Plugin

I have added this to our list and will update this thread once it is complete. Thank you.
by SLeon
Fri Oct 27, 2023 11:51 am
Forum: API
Topic: Deprecation of PayPlans POST
Replies: 12
Views: 3991

Re: Deprecation of PayPlans POST

Good morning, I would like to address both of your concerns on transitioning to Dynamic Payment Plans: ... Speed - they want to get the payment setup quickly and get the patient out the door ... You can set up a Dynamic Payment Plan very quickly with the procedures that were Completed and/or Treatme...
by SLeon
Fri Oct 27, 2023 8:07 am
Forum: Developers
Topic: Calculating Max Remaning w/ Insurance Benefit Adjustments
Replies: 1
Views: 1909

Re: Calculating Max Remaning w/ Insurance Benefit Adjustments

Please see my reply on your cross-post of this question in "Advanced Topics".
by SLeon
Fri Oct 27, 2023 8:05 am
Forum: Advanced Topics
Topic: Calculating Max Remaining using SQL and/or APIs... ???
Replies: 2
Views: 1437

Re: Calculating Max Remaining using SQL and/or APIs... ???

Good morning,

From our manual:
Individual Annual Max - (Ins Used + Pending) = Remaining
You can incorporate the adjustments to insurance benefits entered in this form via the ClaimProc table. They will have a claimproc.Status of "Adjustment".
by SLeon
Wed Oct 25, 2023 2:05 pm
Forum: API
Topic: Deprecation of PayPlans POST
Replies: 12
Views: 3991

Re: Deprecation of PayPlans POST

Dynamic Payment Plans must have some production associated with it to justify the total balance. You can attach Completed procedures, Treatment Planned procedures, and adjustments. What is the reason behind the dental office's practice of charging patients when no dental work has been done or planned?
by SLeon
Fri Oct 20, 2023 7:28 am
Forum: API
Topic: POST Query Timeout Issue
Replies: 6
Views: 2058

Re: POST Query Timeout Issue

Good morning, ... can it be used in a fire and forget style where we're not waiting on the query to run and the file to be uploaded thus making the timeout irrelevant? With some research this appears to be something we can do. We would add a parameter that you could choose to pass in for this behavi...
by SLeon
Thu Oct 19, 2023 1:44 pm
Forum: API
Topic: Bulk update comm log
Replies: 7
Views: 1817

Re: Bulk update comm log

Yes, you can send your API requests en masse and they will be processed, in the order in which they are received, and throttled on our end. Depending on how you design your application, you may implement synchronous or asynchronous calls to suit your needs. Your use case of "sending out" communicati...
by SLeon
Thu Oct 19, 2023 1:34 pm
Forum: API
Topic: SubstitutionLinks Question
Replies: 1
Views: 1189

Re: SubstitutionLinks Question

Yes, you would need to make one API call for each downgrade. You should only need to do this once, however, for each code. And that is assuming the dental office didn't set these up already.
by SLeon
Thu Oct 19, 2023 11:21 am
Forum: API
Topic: API Needs
Replies: 3
Views: 1448

Re: API Needs

Open Dental allows you to allocate an amount to a specific procedure via paysplit, not payment. The API will not support a PaySplits POST or PUT method. You can use Payments POST. This method allocates money on a FIFO basis. If you want to pay on a different basis, you can call Payments POST with th...
by SLeon
Thu Oct 19, 2023 10:25 am
Forum: API
Topic: API Needs
Replies: 3
Views: 1448

Re: API Needs

Good morning,
mardo wrote:
Thu Oct 19, 2023 10:06 am
1) Post a payment that is allocated to procedures
See Payments POST documentation.
mardo wrote:
Thu Oct 19, 2023 10:06 am
2) Post payments for insurance
See ClaimPayments POST documentation.
by SLeon
Thu Oct 12, 2023 11:24 am
Forum: API
Topic: POST Query Timeout Issue
Replies: 6
Views: 2058

Re: POST Query Timeout Issue

I want to make sure I understand your concern correctly. You are using the Queries POST Sftp endpoint and the request (query + document transfer) time is exceeding the server timeout. And your specific question is, "If my request times out, how do I know if the document was successfully created?" an...
by SLeon
Tue Oct 10, 2023 2:17 pm
Forum: API
Topic: What is the best approach/mechanism for reporting API outages?
Replies: 7
Views: 1626

Re: What is the best approach/mechanism for reporting API outages?

The best email addresses to use for API communications are those located in the API's Developer Portal website. Click 'Contact Us' at the top after logging in. The second of these addresses is only available to API account holders and routes directly to the API team for technical questions.
by SLeon
Tue Oct 10, 2023 8:18 am
Forum: API
Topic: What is the best approach/mechanism for reporting API outages?
Replies: 7
Views: 1626

Re: What is the best approach/mechanism for reporting API outages?

Disruptions in API availability can be reported here or via email. When submitted via email, we are able to gather additional information such as which customers are impacted, etc. This can help us pinpoint the source to be the dental office's network, eConnector, or API itself. We are investigating...
by SLeon
Mon Oct 02, 2023 2:59 pm
Forum: API
Topic: TreatPlanAttaches
Replies: 6
Views: 1782

Re: TreatPlanAttaches

1. Yes. The only way to remove items from a Saved Treatment Plan is by double-clicking the desired row and clicking the Delete button highlighted in this screenshot: TreatmentPlans_Save_ProcTPDelete.gif We will mimic this in ProcTPs DELETE. 2. This will take a few weeks to to develop and complete. 3...
by SLeon
Mon Oct 02, 2023 1:03 pm
Forum: API
Topic: TreatPlanAttaches
Replies: 6
Views: 1782

Re: TreatPlanAttaches

Yes, we can add ProcTPs DELETE to our development list. Please remember that this would delete the ProcTP entry and not delete the original procedure and not delete the procedure code.

Once complete, all new API methods require the dental office to update to use the new feature.
by SLeon
Mon Oct 02, 2023 9:16 am
Forum: API
Topic: TreatPlanAttaches
Replies: 6
Views: 1782

Re: TreatPlanAttaches

Good morning, From your other Treatment Plan forum thread: TreatPlanAttaches GET does not have any parameters. I believe you are referring to the TreatPlans GET that does allow the parameter's of "Active" and "Saved". However TreatPlans GET never returns any of the procedure cost details that you ar...
by SLeon
Wed Sep 20, 2023 7:49 am
Forum: API
Topic: Appointments POST (create) does not update/set Recall schedule dates
Replies: 7
Views: 2574

Re: Appointments POST (create) does not update/set Recall schedule dates

Good morning,

This feature request is actively in development and will completed rather shortly.
by SLeon
Tue Sep 19, 2023 8:34 am
Forum: API
Topic: API Update request for commlog POST
Replies: 4
Views: 1806

Re: API Update request for commlog POST

Yes, we have added this to our development list. Commlogs POST will return the same fields as in the GET method (including the CommlogNum). We will update this thread once complete.
by SLeon
Mon Sep 18, 2023 10:09 am
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 8062

Re: TreatPlans POST

Good morning, The "Presenter" in Open Dental is from the UserNumPresenter field in the TreatPlan table. This can only be set on Saved treatment plans . We will add this field to the API method being developed to create Saved treatment plans. Here is an update on our progress for your Treatment Plan ...
by SLeon
Tue Sep 12, 2023 3:01 pm
Forum: API
Topic: Benefit API Issue
Replies: 7
Views: 2243

Re: Benefit API Issue

Like the Definitions table, the CovCat table allows dental office to create customer Insurance Coverage categories. These will be unique to each dental office. We are in the process of developing CovCats GET for this purpose. In the meantime, you can use a Queries PUT ShortQuery request to see the l...
by SLeon
Tue Sep 12, 2023 1:49 pm
Forum: API
Topic: Benefit API Issue
Replies: 7
Views: 2243

Re: Benefit API Issue

We are looking into this now. Can you please elaborate on the error you are receiving? A payload of the API requests that are and are not working would also be helpful. When you query for the CovCatNum, are you only using those that have "IsHidden" values of "false" for your Benefits POST requests?
by SLeon
Thu Sep 07, 2023 8:04 am
Forum: API
Topic: Bad request
Replies: 1
Views: 1096

Re: Bad request

Good morning, The verbiage in the error message mentions the customer's version because it is, by far, the most common source of failure when this issue occurs. Did you check the version of the method you are trying to use and the version of the dental office? This will let you know if the customer ...
by SLeon
Wed Sep 06, 2023 9:41 pm
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 8062

Re: TreatPlans POST

Yes. The remaining feature requests are still on our development list. TreatPlanAttaches PUT and POST methods are in the final stages of development.
by SLeon
Thu Aug 31, 2023 11:51 am
Forum: API
Topic: Detailed aging balance
Replies: 4
Views: 1341

Re: Detailed aging balance

The API cannot run the mass Billing list logic performed in Open Dental. Our web manual indicates that the Billing/Finance Charges or Repeating Charges tools need to be ran prior to Billing. It is extremely database intensive the point that the OpenDentalService can be set to run this after hours, a...
by SLeon
Tue Aug 29, 2023 1:35 pm
Forum: API
Topic: Detailed aging balance
Replies: 4
Views: 1341

Re: Detailed aging balance

You can use the existing Reports GET Aging to get the aging data for all the patients. You could form a list of patnums from those patients with a balance, and then run each one through the AccountModules GET ServiceDateView. Because the AccountModules GET ServiceDateView queries so much data (from ...
by SLeon
Tue Aug 29, 2023 8:37 am
Forum: Main Forum
Topic: 23.2 beta period length?
Replies: 6
Views: 2870

Re: 23.2 beta period length?

Open Dental attempts to release four minor versions per year, but that is not guaranteed. I would estimate that version 23.2 will no longer be in beta in a couple months.
by SLeon
Fri Aug 25, 2023 9:23 am
Forum: API
Topic: PayPlans POST enhancement requests
Replies: 4
Views: 1746

Re: PayPlans POST enhancement requests

Yes, we will look into how we can update the response of PayPlans POST (create) to match PayPlans POST Dynamic and our current patterns, without introducing a breaking change.
by SLeon
Mon Aug 14, 2023 6:58 pm
Forum: API
Topic: Scheduled API Server Maintenance (8/14/2023)
Replies: 1
Views: 4653

Re: Scheduled API Server Maintenance

Maintenance was completed successfully at 18:53:26 PST. All modes of the API and the Developer Portal website are again available.
by SLeon
Mon Aug 14, 2023 1:30 pm
Forum: API
Topic: Scheduled API Server Maintenance (8/14/2023)
Replies: 1
Views: 4653

Scheduled API Server Maintenance (8/14/2023)

Open Dental will be performing scheduled maintenance on its API servers tonight at 18:00:00 PDT for approximately two hours. The Remote API and Developer Portal website will be unavailable during this time. Existing instances of the Local and Service API modes will be unaffected. We will update this...
by SLeon
Wed Aug 09, 2023 1:30 pm
Forum: API
Topic: Recent Feature Requests
Replies: 3
Views: 1653

Re: Recent Feature Requests

We have completed the last feature requests in this thread. 1-2. Previously completed. 3. SheetDefs GET is complete. This method returns a list of sheetdefs, which can be utilized in our Sheets POST method. This available now in version 23.2.5. 4. Previously completed. 5. ApiEvents now include when ...
by SLeon
Wed Aug 02, 2023 8:48 pm
Forum: API
Topic: API Issues
Replies: 5
Views: 1673

Re: API Issues

We apologize for the interruption of service from roughly 14:30 -20:30 PDT. Our internet provider experienced a severe outage in our region (cable cut) impacting Open Dental and thousands of others in our area. We have just come back online and the API is available. The Local and Service Modes of th...
by SLeon
Tue Aug 01, 2023 2:38 pm
Forum: API
Topic: Recent Feature Requests
Replies: 3
Views: 1653

Re: Recent Feature Requests

We have completed two of the above feature requests. 1-2. Previously completed. 3. In Development. 4. Previously completed. 5. In Development. 6. SecurityLogs GET is complete and is available in versions 23.1.33 and later. 7. The ToothNumbers enhancement to the Documents resource is complete and ava...
by SLeon
Mon Jul 31, 2023 1:15 pm
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 8062

Re: TreatPlans POST

Good afternoon Pedro,

No update on this feature request yet, development will start on it soon.
by SLeon
Fri Jul 28, 2023 7:46 am
Forum: API
Topic: Payment POST question
Replies: 10
Views: 3036

Re: Payment POST question

Good morning,

The API does not currently have a Payments PUT method. Which fields would you want to update for a payment?
by SLeon
Fri Jul 21, 2023 8:12 am
Forum: API
Topic: Recent Feature Requests
Replies: 3
Views: 1653

Re: Recent Feature Requests

We have complete one of the above feature requests.

1. Previously completed.
2. Sheets POST has been completed. It is available now in version 23.1.32.
3. In Development.
4. Previously completed.
5-8. In Development.
by SLeon
Wed Jul 19, 2023 8:22 am
Forum: API
Topic: OpenDental API Version
Replies: 2
Views: 1176

Re: OpenDental API Version

There are many way you could implement versioning in your software. A popular approach is to have a single version of your application up-to-date and scale its use by the dental office's version. Another is to maintain different versions of your software and distribute them to dental offices when th...
by SLeon
Tue Jul 18, 2023 8:23 am
Forum: API
Topic: Completed codes update questions
Replies: 8
Views: 3000

Re: Completed codes update questions

Good morning, We can add ProcedureLogs GET (Single) to our development list. It would return the single procedurelog associated with the specified procnum. However if your goal is to update an existing procedure you will only need the procnum, which it sounds like you already have. Can you please cl...
by SLeon
Mon Jul 17, 2023 12:56 pm
Forum: API
Topic: Date Issue with API
Replies: 10
Views: 4250

Re: Date Issue with API

Good afternoon Omar, ClaimProcs POST InsAdjust is next in our development list, and I expect it to be complete a couple weeks after development begins. There are a lot of API feature requests currently in the pipeline, thank you for your patience as we work through them. We will update this thread a...
by SLeon
Fri Jul 14, 2023 8:11 am
Forum: API
Topic: Recent Feature Requests
Replies: 3
Views: 1653

Recent Feature Requests

A couple developers have recently emailed us with API feature requests. The API forums are the best place for these, so I am posting them here for visibility. 1. Computers GET - This method will return the machine names of the workstations and devices that connect to Open Dental at the dental office...
by SLeon
Tue Jul 11, 2023 11:38 am
Forum: API
Topic: Appointment Cost
Replies: 1
Views: 1172

Re: Appointment Cost

Good morning Pedro,

Are you referring to the "Est. Patient Portion" value in the Appointment Edit window?

From our manual: Appointment Edit - Patient Info Grid:

AppointmentEdit_PatientInfo_EstPatPortion.gif
AppointmentEdit_PatientInfo_EstPatPortion.gif (30.77 KiB) Viewed 1154 times
by SLeon
Tue Jul 11, 2023 11:16 am
Forum: API
Topic: New API for Notes functionality
Replies: 8
Views: 4337

Re: New API for Notes functionality

Good morning, Both of your requests above are the next items in our development list. Both will likely start development in roughly a week and then completed within a couple weeks of that. I will update this thread as soon as the first item is completed, and include which version of Open Dental you ...
by SLeon
Tue Jul 11, 2023 10:31 am
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 8062

Re: TreatPlans POST

Re #3 - Save Treatment Plan:

I have added creating "Saved" treatment plans to your existing request. We will work on all of these in tandem to make sure they support your workflow. I will update this thread (soon) when I have more information for you on signatures.
by SLeon
Tue Jul 11, 2023 8:41 am
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 8062

Re: TreatPlans POST

Good morning Pedro, We are planning to provide API methods to support your entire workflow! 1. Create Treatment Plan - TreatPlans POST will allow you to do this. 2. Attach Procedure Codes to Treatment Plan . TreatPlanAttaches POST will allow you to do this for both "Active" and "Inactive" treatment ...
by SLeon
Tue Jul 11, 2023 8:25 am
Forum: API
Topic: Not getting all commlogs in GET API
Replies: 2
Views: 1335

Re: Not getting all commlogs in GET API

Good morning, The "Communications Log" grid in your second screenshot contains more than items in the commlog table. It also contains information for that patient from the emailmessage, formpat, and sheet tables. To get emails for a patient, you can use a query to select rows from that table using t...
by SLeon
Thu Jul 06, 2023 2:57 pm
Forum: API
Topic: API for web forms
Replies: 6
Views: 2805

Re: API for web forms

Yes, we can add IsWebForm to Sheets GET. I have added this to our development list.
by SLeon
Thu Jul 06, 2023 2:51 pm
Forum: API
Topic: API for web forms
Replies: 6
Views: 2805

Re: API for web forms

If by URL you are only referring to WebForms, then you can reference the IsWebForm field in the sheet table. You would use a query if you wanted to retrieve that field's information via the API.
by SLeon
Thu Jul 06, 2023 2:34 pm
Forum: API
Topic: API for web forms
Replies: 6
Views: 2805

Re: API for web forms

Once saved in the database, all sheets appear the same in our software. What is your use case for needing to know how the sheet originated?
by SLeon
Fri Jun 30, 2023 8:15 am
Forum: API
Topic: Some Data We Can Not Found in Query #43132
Replies: 5
Views: 3075

Re: Some Data We Can Not Found in Query #43132

I have added this to our development list. We will update this thread once it is completed.
by SLeon
Fri Jun 30, 2023 8:08 am
Forum: API
Topic: Some Data We Can Not Found in Query #43132
Replies: 5
Views: 3075

Re: Some Data We Can Not Found in Query #43132

"ReportableName" is a field in the Sheetfield table. We can add it to SheetFields GET, if you like.
by SLeon
Thu Jun 29, 2023 1:32 pm
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 8062

Re: TreatPlans POST

To clarify, I mean that there are roughly two dozen requests before these two (TreatPlans POST and TreatPlanAttaches POST) in line. Therefore we will start developing TreatPlans POST and TreatPlanAttaches POST after we've started/completed the other ~24 feature requests.
by SLeon
Thu Jun 29, 2023 12:06 pm
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 8062

Re: TreatPlans POST

API feature requests are started in the order in which they are received. We currently have roughly two dozen requests ahead of this one. I would estimate somewhere in the 6-8 week range. These two methods will be developed together and released at the same time to make sure you can fully utilize th...
by SLeon
Thu Jun 29, 2023 11:45 am
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 8062

Re: TreatPlans POST

Good morning,

We will add TreatPlans POST to our development list. The design will be to allow you to create an Active or Inactive treatment plan without procedures. Then, we will also develop TreatPlanAttaches POST so you can add the procedures to the above (or any other) treatment plan.
by SLeon
Mon Jun 26, 2023 9:47 am
Forum: API
Topic: API query error message
Replies: 4
Views: 1871

Re: API query error message

I would double check your syntax and variable naming. Did you try to run this query in the User Query window of Open Dental?

I was able to run this query with the Public Demo dental office credentials without issue.
by SLeon
Wed Jun 21, 2023 9:17 am
Forum: Main Forum
Topic: Seeking help to get data
Replies: 1
Views: 2795

Re: Seeking help to get data

Moving to our Main forum as this is a question pertaining to our database schema and not the API. You can also contact support for further help.
by SLeon
Thu Jun 15, 2023 8:52 am
Forum: API
Topic: Some Data We Can Not Found in Query #43132
Replies: 5
Views: 3075

Re: Some Data We Can Not Found in Query #43132

Here is a link to our entire database schema that you can use to learn more about Sheets, etc.
by SLeon
Thu Jun 15, 2023 8:23 am
Forum: API
Topic: Claim create
Replies: 9
Views: 4135

Re: Claim create

Claims POST is currently in development.

The API will not support interactions with DXC (or any other third party) integrations that exist in Open Dental.
by SLeon
Tue Jun 13, 2023 8:27 am
Forum: API
Topic: API Query timeout
Replies: 7
Views: 3575

Re: API Query timeout

It is not clear to me if by, "...run a sample run on the local work stations" you are talking about the User Query window within Open Dental OR the Local mode of the API. It sounds like you are doing #1 and it is taking over two minutes. Have you tried #2 (either the Service or Local mode of the API...
by SLeon
Tue Jun 13, 2023 7:56 am
Forum: API
Topic: API Query timeout
Replies: 7
Views: 3575

Re: API Query timeout

beacondental wrote:
Tue Jun 13, 2023 7:30 am
We have tried both ways for query that has 1800 lines of code and it gets timeout.
Are you saying that you tried the Local or Service mode of the API and got a timeout error? These run at the dental office level, not our API Servers, and therefore are not limited by the same timeout.
by SLeon
Tue Jun 06, 2023 11:08 am
Forum: API
Topic: Patient portal API
Replies: 3
Views: 3002

Re: Patient portal API

Can you please clarify, do you need to usernames of the patients or the username information for the dental office itself? What is your use case for the username?
by SLeon
Thu Jun 01, 2023 7:52 am
Forum: API
Topic: Add OrthoRemainM to Claim PUT API
Replies: 4
Views: 3472

Re: Add OrthoRemainM to Claim PUT API

Good morning,

Yes, we can add support for the OrthoRemainM field in Claims PUT. I have added this to our development list. I will update this thread once completed.
by SLeon
Wed May 31, 2023 12:43 pm
Forum: API
Topic: Payments POST - set payType
Replies: 18
Views: 5101

Re: Payments POST - set payType

This item is next on our development list. I would expect this to be completed in the next couple weeks.
by SLeon
Wed May 31, 2023 9:58 am
Forum: API
Topic: API Query timeout
Replies: 7
Views: 3575

Re: API Query timeout

Good morning, The Remote mode of the Open Dental API has a timeout of 60 seconds. This protects both the API and dental offices in several ways. You can either: 1. Modify your query to execute in the necessary time. You can break the query into a few smaller ones and compile the information afterwar...
by SLeon
Tue May 30, 2023 8:07 am
Forum: API
Topic: API Query timeout
Replies: 7
Views: 3575

Re: API Query timeout

Good morning, Which Queries method are you trying to use: Queries POST or Queries PUT ShortQuery? Is the query you are running via the API and in Open Dental identical and to the same database? How long does the query take to execute in Open Dental? Is the dental office using Middle Tier with a lowe...
by SLeon
Mon May 22, 2023 12:53 pm
Forum: API
Topic: EOB attachments
Replies: 7
Views: 4265

Re: EOB attachments

We have added downloading EOBs to our development list. As with downloading other files via the API, this new method will use an Sftp site hosted by the developer. See Documents POST DownloadSftp, Queries POST, and Sheets POST DownloadSftp for reference. The information in the eobattach table, such ...
by SLeon
Mon May 22, 2023 11:46 am
Forum: API
Topic: EOB attachments
Replies: 7
Views: 4265

Re: EOB attachments

We can create EOBAttaches GET that will get EOB attachment information by ClaimPaymentNum. This will get you the filename of the EOB you are after. I have added this to our development list.

Do you need to also download the EOB files, or just get the file information?
by SLeon
Mon May 22, 2023 8:40 am
Forum: API
Topic: Outstanding insurance claims
Replies: 1
Views: 2604

Re: Outstanding insurance claims

This feature has been requested previously and is already on our development list. Claim tracking information is stored in the claimtracking table and has FKs to definition and claim tables. The latter two already have GET methods, so we will add ClaimTracking GET, POST, and PUT. Please see this thr...
by SLeon
Wed May 17, 2023 10:14 am
Forum: API
Topic: Date Issue with API
Replies: 10
Views: 4250

Re: Date Issue with API

A member of our team was able to duplicate your described behavior. For us, it occurred when insurance has already paid the Annual Max (eg $1500) on received claim(s). Because ClaimProcs PUT InsAdjust is used to override all existing insurance pay amounts, passing in an InsUsed value of 163 conveys ...
by SLeon
Wed May 17, 2023 8:57 am
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 5348

Re: Request benefits in family module

ClaimProcs GET is an existing method. You can use the PatNum parameter to filter your results by a single patient. ClaimProcs PUT InsAdjust will create, modify, or delete insurance adjustment claimprocs depending on the situation. From our documentation, emphasis added: This adds or changes a claimp...
by SLeon
Wed May 17, 2023 8:37 am
Forum: API
Topic: Date Issue with API
Replies: 10
Views: 4250

Re: Date Issue with API

Good morning, We are investigating this issue and are not yet able to duplicate this behavior. Could you please confirm that "this sample patient had a maximum of 1500" means the patient's Insurance Plan has either an Individual or Family "Annual Max" value of $1500? Also, were there any other adjus...
by SLeon
Tue May 16, 2023 2:59 pm
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 5348

Re: Request benefits in family module

You probably want to use our ClaimProcs PUT InsAdjust method.
by SLeon
Tue May 16, 2023 2:44 pm
Forum: API
Topic: New API for Notes functionality
Replies: 8
Views: 4337

Re: New API for Notes functionality

Good afternoon, Thank you for describing your uses cases. We will add the following to our development list: Claim tracking information is stored in the claimtracking table and has FKs to definition and claim tables. The latter two already have GET methods, so we will add ClaimTracking GET, POST, an...
by SLeon
Tue May 16, 2023 1:56 pm
Forum: API
Topic: Income transfer manager
Replies: 5
Views: 3298

Re: Income transfer manager

Paysplits are complex, which is why our Payments POST method takes care of them automatically, and based on dental office preferences. Manually assigning paysplits (either en masse or individually ) is left to users at the dental office. The need to run the Income Transfer Manager should be rare reg...
by SLeon
Tue May 16, 2023 1:21 pm
Forum: API
Topic: Appointments GET Slots
Replies: 7
Views: 4387

Re: Appointments GET Slots

As you and the API documentation describe, the appointment search results in Open Dental and the Appointments GET Slots results are indeed different. A major reason for these differences is in the parameters required to run them. To use Open Dental's appointment search: An appointment must be on the...
by SLeon
Tue May 16, 2023 12:22 pm
Forum: API
Topic: API Security permission
Replies: 4
Views: 3592

Re: API Security permission

We have added UserGroups GET and UserGroupAttaches GET to our development list.
by SLeon
Tue May 16, 2023 8:19 am
Forum: API
Topic: API Security permission
Replies: 4
Views: 3592

Re: API Security permission

The API security permission page you are referring to are for API key permissions, not for Open Dental user permissions. The documentation on that page has been updated to further indicate this. Basic user information can already be obtained via Userods GET . The remaining user permission informatio...
by SLeon
Mon May 15, 2023 11:29 am
Forum: API
Topic: Post Patient Photo
Replies: 1
Views: 2508

Re: Post Patient Photo

Images are stored in the documents table, so you can use an existing Documents POST method to do this: First, determine what the definition.DefNum is for "Patient Pictures" by using Definitions GET for Category=18 (/definitions?Category=18). Then, use Documents POST Upload or UploadSftp to upload th...
by SLeon
Mon May 15, 2023 8:10 am
Forum: API
Topic: Income transfer manager
Replies: 5
Views: 3298

Re: Income transfer manager

No, there is not a way to run the Income Transfer Manager via the API. We expect dental offices to run this themselves.
by SLeon
Mon May 15, 2023 7:56 am
Forum: API
Topic: Do not bill
Replies: 4
Views: 3039

Re: Do not bill

API feature requests are started in the order in which they are received. There are over a dozen requests in line ahead of this one, so I would estimate roughly six weeks from now.
by SLeon
Mon May 15, 2023 7:50 am
Forum: API
Topic: Do not bill
Replies: 4
Views: 3039

Re: Do not bill

Good morning,

Yes, we can add the NoBillIns field to our ProcedureCodes GET, PUT, and POST methods. I have added this to our development list and we will update this thread when it is complete.
by SLeon
Mon May 15, 2023 7:25 am
Forum: API
Topic: Poayment post question
Replies: 1
Views: 2463

Re: Poayment post question

Good morning, Yes the "Mark as Processed" checkbox corresponds to the payment.ProcessStatus field. It appears in the payment form when a payment is made online (either "OnlinePending" or "OnlineProcessed"). Payments made in the office or through Payments POST have a ProcessStatus of "OfficeProcessed...
by SLeon
Fri May 12, 2023 12:25 pm
Forum: API
Topic: New API Request
Replies: 16
Views: 5331

Re: New API Request

Are you referring to attachments made in the DXC tab? I ask because web calls to a third party (Dental X Change) occur as part of the validation when attaching these items. We cannot add API methods that make web calls within them. Or are you referring to the other Attachment tabs, "NEA/Manual" and ...
by SLeon
Fri May 12, 2023 8:02 am
Forum: API
Topic: Claim create
Replies: 9
Views: 4135

Re: Claim create

Open Dental does not allow users to attach additional procedures to a claim after it is created. Therefore the API will not allow that with Claims PUT. Claims POST is currently under development. As stated in the request, we will allow API developers to attach procedures. I recommend looking at our ...
by SLeon
Tue May 09, 2023 3:40 pm
Forum: API
Topic: Program links
Replies: 3
Views: 2941

Re: Program links

Justine is referring to the customer's Open Dental database.

The three document storage options are listed here and the now deprecated database storage option further described here.
by SLeon
Mon May 08, 2023 1:22 pm
Forum: API
Topic: Database maintenance
Replies: 1
Views: 2914

Re: Database maintenance

No, there is not a way to do the Database Maintenance via the API. We expect dental offices to manage/run these themselves.
by SLeon
Mon May 08, 2023 10:08 am
Forum: API
Topic: Claim create
Replies: 9
Views: 4135

Re: Claim create

We will add PreAuth to the Claims POST method. Please see this thread for updates: http://opendentalsoft.com/forum/viewtop ... f=9&t=7993.
by SLeon
Mon May 08, 2023 10:00 am
Forum: API
Topic: Confirmation status
Replies: 6
Views: 4122

Re: Confirmation status

Good morning,

Can you please clarify? Are you wanting the full list of confirmation statuses the dental office uses or are you wanting to know what confirmation statuses a single appointment has had over time?
by SLeon
Mon May 08, 2023 9:49 am
Forum: API
Topic: API: Searching patient with apostrophe in name throws error
Replies: 2
Views: 2623

Re: API: Searching patient with apostrophe in name throws error

This issue is a product of the Patients GET (multiple) using the exact same query as the Patient Select query as in Open Dental. We will look into how we can fix this programmatically, but there are two ways you can get around this right now. 1. Escape the apostrophe with a '\' character. When encod...
by SLeon
Tue May 02, 2023 2:43 pm
Forum: API
Topic: Quick API Question
Replies: 2
Views: 3114

Re: Quick API Question

Good afternoon, You are correct that there are two ways to run custom queries via the API: Queries PUT ShortQuery - As you mentioned, limits results to 100 rows (or 1000 rows in Local and Service API modes) Queries POST - Does not limit the rows returned. However this does require you setup an SFTP ...
by SLeon
Mon Apr 24, 2023 2:32 pm
Forum: API
Topic: Supporting Clinics as a Third Party Software Provider
Replies: 7
Views: 4246

Re: Supporting Clinics as a Third Party Software Provider

No need to apologize. Claims and accounting in general are complex areas of our software and have a lot of moving pieces. Visualization can be helpful. Clinics also have a significant impact on how data is presented to the user and worth taking the time to understand fully. We are happy to answer an...
by SLeon
Wed Apr 19, 2023 11:50 am
Forum: API
Topic: Database Integrity
Replies: 6
Views: 8423

Re: Database Integrity

Currently, the Database Integrity behavior is simply a small warning triangle in the corner of the form. This only occurs when Open Dental determines that the object being viewed, such as an appointment, was created or modified outside our software. You can click this triangle to see more informatio...
by SLeon
Mon Apr 17, 2023 3:12 pm
Forum: API
Topic: Supporting Clinics as a Third Party Software Provider
Replies: 7
Views: 4246

Re: Supporting Clinics as a Third Party Software Provider

That is correct. Procedures must belong to the same patient to be attached to a claim. Procedures must have the same procedurelog.ClinicNum to be attached to a claim. There are other nuances for creating claims . We will document the ones relevant in our API documentation for the Claims POST method ...
by SLeon
Mon Apr 17, 2023 11:54 am
Forum: API
Topic: Supporting Clinics as a Third Party Software Provider
Replies: 7
Views: 4246

Re: Supporting Clinics as a Third Party Software Provider

I am happy to clarify this for you.

The procedures that can be attached to a patient's claim (and displayed in the Account Module grid) are a subset of:
  • Procedures for all patients
  • Procedures that are associated with production (not group notes)
  • Procedures that are not treatment planned
by SLeon
Thu Apr 13, 2023 3:32 pm
Forum: API
Topic: Request for a PUT to update data via the DiscountPlanSubs API
Replies: 10
Views: 4143

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

Development on API feature requests occurs in the order in which they are made. I would estimate that this will be completed in roughly three weeks.
by SLeon
Thu Apr 13, 2023 9:17 am
Forum: API
Topic: Supporting Clinics as a Third Party Software Provider
Replies: 7
Views: 4246

Re: Supporting Clinics as a Third Party Software Provider

Good morning, Is there a way when configuring the API in Open Dental to restrict API calls to just a specific clinic? When using the API do we have a way to specify the clinic for which we're making the request, for instance in the headers? You can currently refine your search to a specific clinic u...
by SLeon
Wed Apr 12, 2023 2:22 pm
Forum: API
Topic: Prepayments for dynamic payment plans
Replies: 6
Views: 3603

Re: Prepayments for dynamic payment plans

You are correct that this is not currently possible via the API. I recognize the need to pay on Payment Plans and we are looking into how we can provide that functionality. I'll update this thread soon.
by SLeon
Tue Apr 11, 2023 11:43 am
Forum: API
Topic: New API Request for multiple ProcedureLogs PUT (update)
Replies: 1
Views: 3038

Re: New API Request for multiple ProcedureLogs PUT (update)

Open Dental software does not allow for mass updates except in very specific situations (such as completing procedures on a completed appointment). The API behaves similarly. What is the use case that you are unable to call ProcedureLogs PUT for each procedure in your list? Doing this allows you to ...
by SLeon
Tue Apr 11, 2023 11:24 am
Forum: API
Topic: Payments POST - set payType
Replies: 18
Views: 5101

Re: Payments POST - set payType

I understand your use case and your desired workflow. After much discussion, we've decided to change the API Setup form to indicate to dental offices that the payment type they choose will be the default type used. We will then allow developers to set the PayType in Payments POST requests, identical...
by SLeon
Mon Apr 10, 2023 7:12 am
Forum: API
Topic: New API Request for Patient Ledger
Replies: 2
Views: 3017

Re: New API Request for Patient Ledger

Good morning, There two existing API methods available that should meet the needs of your described use case. 1. The AccountModules GET ServiceDateView method provides the same information as the Service Date View grid in Open Dental. This contains patient details for most of the tables you describe...
by SLeon
Fri Apr 07, 2023 9:48 am
Forum: API
Topic: Patients GET Add Zip
Replies: 3
Views: 3183

Re: Patients GET Add Zip

This feature request is complete. The list of patients returned by Patients GET (multiple) now include the Zip field. This is available in now in version 22.4.35.
by SLeon
Wed Apr 05, 2023 4:01 pm
Forum: API
Topic: New API Request
Replies: 16
Views: 5331

Re: New API Request

Yes, we will develop a way for you to delete procedures for this purpose. I will update this thread with more information on Claims POST as it nears completion.
by SLeon
Tue Apr 04, 2023 2:21 pm
Forum: API
Topic: Payments POST - set payType
Replies: 18
Views: 5101

Re: Payments POST - set payType

Good afternoon, It is the dental office that dictates how they want to categorize how payments are entered into their database, not the third party. Most dental offices will create a specific PaymentType definition just for third party usage, such as "FromAPI", and set that in the API Setup form abo...
by SLeon
Tue Apr 04, 2023 9:27 am
Forum: API
Topic: Payments POST - set payType
Replies: 18
Views: 5101

Re: Payments POST - set payType

The PayType is decided by the dental office when they enable the API:

PaymentType_Default.gif
PaymentType_Default.gif (65.86 KiB) Viewed 5088 times

You can see which PayType they have selected by using Preferences GET to retrieve the ApiPaymentType preference.
by SLeon
Tue Apr 04, 2023 6:38 am
Forum: API
Topic: Request for a PUT to update data via the DiscountPlanSubs API
Replies: 10
Views: 4143

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

Good morning, Yes, that is correct. A patient can only be subscribed to one discount plan at a time. If you only want to change the effective dates for the existing plan, you can use the existing DiscountPlanSubs PUT method. However, that does not address the case when you would like to subscribe th...
by SLeon
Mon Apr 03, 2023 3:27 pm
Forum: API
Topic: Testing certain functionality
Replies: 3
Views: 2783

Re: Testing certain functionality

Good afternoon, Yes, the credentials listed on the Setup page of our documentation has all API permissions available and has access to all API methods. I have just sent a request using those credentials to make sure. The first one I sent was with Postman (which can obfuscate its default header value...
by SLeon
Mon Apr 03, 2023 2:57 pm
Forum: API
Topic: New API Request
Replies: 16
Views: 5331

Re: New API Request

Good afternoon, Thank you for thoroughly describing your use case and concerns. As you mentioned, creating claims and attaching procedures is a common, yet complex, process. With anything we implement in the API, we also want to make sure we do not leave items in "a confusing state for the client". ...
by SLeon
Wed Mar 29, 2023 8:06 am
Forum: API
Topic: Customer API Key
Replies: 8
Views: 6271

Re: Customer API Key

Good morning. Yes it has been added! From our documentation : Occasionally, you may want to retrieve this information via a query. This will be rare, but can be accomplished with the following example: SELECT CustApiKey FROM apikey WHERE DevName='YourName'; This has been available since version 21.4...
by SLeon
Mon Mar 27, 2023 1:53 pm
Forum: API
Topic: Appointments POST (create) > PatientFirstVisitDdate not populating
Replies: 7
Views: 3656

Re: Appointments POST (create) > PatientFirstVisitDdate not populating

Good afternoon, We have added the setting of Patient.DateFirstVisit to the Appointments POST method. This will be available in our next beta version, 22.4.33. This enhancement follows the exact same behavior when setting this field in Open Dental, and includes the requirement that the appointment yo...
by SLeon
Mon Mar 27, 2023 7:58 am
Forum: API
Topic: What version is reaured for subscription/events/watch tables?
Replies: 1
Views: 1523

Re: What version is reaured for subscription/events/watch tables?

Good morning,

From our documentation:
  • Subscriptions GET/POST/PUT/DELETE were added in 22.1.
  • UI and Database Events were added in 22.1.
  • Watchtables Appointments and Patients were added in 22.1. PatFields was added in 22.4.8.
by SLeon
Wed Mar 22, 2023 11:02 am
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

... on the Open Dental UI, I am able to check off "Don't Substitute Codes". Is there a way to do this via the API? - i believe in the documentation it says this can be achieved by making the CodeSubstNone=1 in the insplan table... InsPlan.CodeSubstNone has been added to InsPlans GET, POST, and PUT ...
by SLeon
Fri Mar 17, 2023 12:35 pm
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

I estimate that 22.4 will be out of beta in roughly a month's time. The InsPlan.CodeSubstNone feature request is in the final stages of development and will be included.
by SLeon
Fri Mar 17, 2023 10:01 am
Forum: API
Topic: Multiple location offices
Replies: 1
Views: 1477

Re: Multiple location offices

Good morning, Open Dental refers to the multiple locations of a single database dental office as "Clinics". Many of our API methods have a ClinicNum filter you can use to refine the dataset to just one of these locations. Omitting this filter would return the data for every clinic. Use Clinics GET t...
by SLeon
Thu Mar 16, 2023 8:13 am
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

Hello there, these features are super helpful. Is it possible to add a Post(create) InsPlan? I only see Get and Put. The InsPlans POST method is complete and is available now in versions 22.4.24 and later. Thank you for adding the SubstitutionLink documentation! I would also like to request the DEL...
by SLeon
Wed Mar 15, 2023 2:49 pm
Forum: API
Topic: Appointments POST (create) > PatientFirstVisitDdate not populating
Replies: 7
Views: 3656

Re: Appointments POST (create) > PatientFirstVisitDdate not populating

Good afternoon Pedro, We are currently working to enhance the Appointments POST method to set the patient's DateFirstVisit field in the same scenarios as Open Dental. This will be completed in roughly 3 weeks. Developers may also find it useful to set this field directly in Patients PUT requests, so...
by SLeon
Wed Mar 08, 2023 12:20 pm
Forum: API
Topic: Use OpenDental credentials to log into website?
Replies: 3
Views: 1504

Re: Use OpenDental credentials to log into website?

Good morning, What is your use case needing to validate Open Dental usernames and passwords? Any application you create should have its own sign in credentials. You would want to do this so you were able to actually manage the credentials (reset password, forgotten passwords, sign in attempts, etc.)...
by SLeon
Tue Mar 07, 2023 4:19 pm
Forum: API
Topic: Appointments GET Slots
Replies: 7
Views: 4387

Re: Appointments GET Slots

Good afternoon, Dental offices can use Blockouts for a variety of purposes. Some are used exclusively to schedule on, such as high production procedures or training a new hygienist. Other times blockouts are used to indicate that no appointments can be scheduled, such as lunch or equipment maintenan...
by SLeon
Tue Mar 07, 2023 8:34 am
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

Good morning Omar, The form you are referring to inserts rows into the insplan, inssub, and patplan tables. To add a new insurance plan for a patient and "Create New Plan if Needed" via the API you will do the following: Use Patients POST to create a new patient. If you don't already have the data c...
by SLeon
Mon Mar 06, 2023 9:09 am
Forum: API
Topic: Patients GET Add Zip
Replies: 3
Views: 3183

Re: Patients GET Add Zip

Good Morning,

Yes, we can add Zip as of the fields return in Patients GET Multiple. I have added this to our development list and will update this thread upon its completion.
by SLeon
Thu Feb 23, 2023 3:25 pm
Forum: API
Topic: Urgent API Issue
Replies: 3
Views: 1518

Re: Urgent API Issue

Please see my private message reply.
by SLeon
Thu Feb 23, 2023 2:32 pm
Forum: API
Topic: Urgent API Issue
Replies: 3
Views: 1518

Re: Urgent API Issue

Good afternoon,

Are you experiencing this issue when calling other API methods? Which version is this dental office on? And are your other customers under your developer key able to make API requests?

I have private messaged you for more information on this specific dental office.
by SLeon
Wed Feb 22, 2023 12:54 pm
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

Good afternoon, By "relationship" are you referring to "Self", "Spouse", "Child", etc? If so, you will want to use our PatPlans resource and supply the Relationship field in your PatPlans POST/PUT request. Yes, we can add SubscNote to InsSubs POST/PUT methods. I have added this to our development li...
by SLeon
Tue Feb 21, 2023 8:12 am
Forum: API
Topic: Benefits API req
Replies: 19
Views: 4167

Re: Benefits API req

Good morning,

This feature request is in the final stages of development and nearly finished. I will update this thread soon.
by SLeon
Mon Feb 20, 2023 1:18 pm
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

InsPlan POST feature request is complete. It will be available in our next beta version.

@Omar22, Yes. Use InsSubs POST to subscribe a patient to an existing InsPlan.
by SLeon
Mon Feb 20, 2023 11:13 am
Forum: API
Topic: Regular slots API ignoring blockouts
Replies: 2
Views: 1165

Re: Regular slots API ignoring blockouts

Good morning, Using Appointments GET Slots alongside Schedules GET is the recommended way to find open appointment slots. The core reason for this is the many different ways dental offices utilize blockouts. There can be blockouts that do not impact scheduling, so we cannot exclusively exclude time ...
by SLeon
Fri Feb 17, 2023 8:37 am
Forum: API
Topic: Email and text functions via API
Replies: 5
Views: 1593

Re: Email and text functions via API

Could you please clarify what you mean? The linked post above explains that we could insert rows into the emailmessage table to show that your application sent an email. As far as texting, are you suggesting your application would send text messages but would require the office to pay for eServices ...
by SLeon
Thu Feb 16, 2023 3:11 pm
Forum: API
Topic: Email and text functions via API
Replies: 5
Views: 1593

Re: Email and text functions via API

Good afternoon, You can currently use the API to retrieve the patient contact information (email address, phone number for texting) via the Patients GET (single/multiple) or Patients GET Simple methods. Your application can then send the email or text message to the intended recipient. See this post .
by SLeon
Thu Feb 16, 2023 9:15 am
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

InsPlan POST is in the final stage of development. I will update this thread within the next day on its progress.
by SLeon
Mon Feb 13, 2023 11:09 am
Forum: API
Topic: Error on medicationPats api
Replies: 3
Views: 1387

Re: Error on medicationPats api

Good morning,

There is an extra '/' character in your url string, but that should not cause the issue. Do you receive this error when calling this method with other patients? Are you able to call other API endpoints with this key?
by SLeon
Fri Feb 10, 2023 9:04 am
Forum: API
Topic: ProcedureLogs Date Range
Replies: 1
Views: 1005

Re: ProcedureLogs Date Range

Good morning, Are you getting an error when you send this command with real data? You will want to put your SqlCommand in double quotes, not single as shown in your post. For example, using Queries PUT ShortQuery with the payload: { "SqlCommand": "SELECT PatNum,ProcDate,ProcFee,Surf,ToothNum,CodeNum...
by SLeon
Fri Feb 10, 2023 8:14 am
Forum: API
Topic: procCode in procedurelogs
Replies: 8
Views: 2474

Re: procCode in procedurelogs

Good morning Omar, Many of the tables in the Open Dental schema are oft-read yet infrequently changed. Both the patient and procedurecode tables fall into this category. Most developers will grab this information, cache it, and then only query the API to keep it up to date. For the patients table, y...
by SLeon
Wed Feb 08, 2023 8:38 am
Forum: API
Topic: HTTPS for OpenDental local API
Replies: 1
Views: 1052

Re: HTTPS for OpenDental local API

This is something we can look into. Could you please describe your use case requiring SSL handshakes?
by SLeon
Mon Feb 06, 2023 8:43 am
Forum: API
Topic: getting Reports thru the API
Replies: 1
Views: 1045

Re: getting Reports thru the API

Good morning, The API has a Reports resource which currently has two methods: Reports GET Aging and Reports GET FinanceCharges. They return data identically as two of the reports available within the Open Dental software. If there additional reports you are interested in, request them here and we ca...
by SLeon
Mon Feb 06, 2023 8:02 am
Forum: API
Topic: procCode in procedurelogs
Replies: 8
Views: 2474

Re: procCode in procedurelogs

Good morning,

Yes, there is a way you can get more than just the first 100 results. The Open Dental API utilizes paging, so you will need to use the Offset parameter to page through the ProcedureCode table. See the Pagination section in our documentation for more information.
by SLeon
Thu Feb 02, 2023 8:30 am
Forum: API
Topic: Payments
Replies: 7
Views: 2020

Re: Payments

Your second feature request to apply a payment to specific procedures has been completed. Payments POST will now accept an array of procNums, which can be obtained via ProcedureLogs GET, AccountModules GET ServiceDateView, or Queries PUT ShortQuery. This new functionality is available now in version...
by SLeon
Tue Jan 31, 2023 8:52 am
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

Good morning,

Unfortunately we are unable to release new features beyond our beta version.
by SLeon
Wed Jan 25, 2023 11:10 am
Forum: API
Topic: API PUT request -SQLcommand issue
Replies: 1
Views: 981

Re: API PUT request -SQLcommand issue

Good morning, Could you please clarify if You are looking for a specific patient whose last name is Brown and they are not in the returned list, but 100 other patients with LName Brown are? Or generally speaking, are you not getting any results with this query despite there being a patient matching ...
by SLeon
Wed Jan 25, 2023 10:45 am
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

Good morning, Insurance plans are stored in the InsPlan table and patients are linked/subscribed to them via the InsSub table. A row is deleted from the InsSub table when the patient drops an insurance plan, and a new one is inserted when they subscribe to another (as you mention). The SecDateEntry ...
by SLeon
Tue Jan 24, 2023 9:07 am
Forum: API
Topic: Payments POST - Change PayType
Replies: 1
Views: 1093

Re: Payments POST - Change PayType

Good morning, The contents of Definition table in Open Dental does not change often, so most developers cache this data. When their software launches, they will run Definitions GET and hold this data in memory to reference later. This eliminates the need to GET them before each Payments POST request...
by SLeon
Thu Jan 19, 2023 2:08 pm
Forum: API
Topic: Treatment Plans
Replies: 5
Views: 1753

Re: Treatment Plans

There are six feature requests in line in front of this, so I would estimate a couple weeks from now.
by SLeon
Thu Jan 19, 2023 10:23 am
Forum: API
Topic: API Guide - The API Service
Replies: 0
Views: 5829

API Guide - The API Service

The API Service is a lightweight instance of the Remote API that continuously runs on a machine at the dental office. It works by opening a specific port (30223) and listening for API requests made to this machine by any device on the network. The service is installed and started automatically for c...
by SLeon
Wed Jan 18, 2023 9:07 am
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

Good morning, Open Dental's version 22.4 is currently in beta. While dental offices are able to update to this version, most will stay on our newest non-beta ("stable") version, currently 22.3. Because 22.4 was just released a few weeks ago, you can expect it to be out of beta within the next few mo...
by SLeon
Mon Jan 16, 2023 8:55 am
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

Good morning,

Yes, we can add GET, PUT, and DELETE methods for SubstitutionLinks. This has been added to our development list.
by SLeon
Mon Jan 16, 2023 8:31 am
Forum: API
Topic: Difference between OD schedule and API slots
Replies: 3
Views: 1476

Re: Difference between OD schedule and API slots

Good morning, Thank you for clarifying that you have a single provider assigned to multiple operatories. In your screenshot above, the Restoration operatory has openings from 9-10a, 11a-1p, and 2-6p for whichever provider(s) scheduled there. But it does not show where else Provider #8 is scheduled t...
by SLeon
Thu Jan 12, 2023 1:04 pm
Forum: API
Topic: Difference between OD schedule and API slots
Replies: 3
Views: 1476

Re: Difference between OD schedule and API slots

Good afternoon, You are correct that the Appointments GET Slots returns slightly different information than the appointment search performed within the Open Dental software. This is for many reasons, one of which being that the latter searches for openings based on the current Appointment View. The ...
by SLeon
Thu Jan 12, 2023 10:07 am
Forum: API
Topic: Show Rate
Replies: 1
Views: 1218

Re: Show Rate

Good morning, An appointment that the patient showed up for will have an AptStatus of Complete. An appointment that they did not show up for will have an AptStatus of Broken. You can use Appointments GET (multiple) to retrieve this information. Use the "date" parameter to specify the particular date...
by SLeon
Thu Jan 12, 2023 9:08 am
Forum: Main Forum
Topic: Can ya use the power aPps mysql connector and gateway...
Replies: 1
Views: 3246

Re: Can ya use the power aPps mysql connector and gateway...

Good morning, In regards to you first question, Open Dental recommends developers use the API to interact with customer databases. From the Programming Resources page: Queries Simple read-only operations can be performed with queries. This is useful for reports. Any third party is welcome to query t...
by SLeon
Wed Jan 11, 2023 2:11 pm
Forum: API
Topic: InsVerifies GET
Replies: 9
Views: 2571

Re: InsVerifies GET

Good afternoon Pedro, The insurance information you are after is stored in the benefit table. Benefits GET can return this via the InsPlan or the PatPlan. It was made available roughly six weeks ago in version 22.3.27 (and later). The documentation can be found here https://www.opendental.com/site/a...
by SLeon
Wed Jan 11, 2023 10:21 am
Forum: API
Topic: Benefits API req
Replies: 19
Views: 4167

Re: Benefits API req

Good morning, 1. Benefits cannot be deleted by plan within the Open Dental program. The API follows this example. 2a. Yes we can add EO as a status in our ProcedureLogs POST/PUT methods. I have added this to our development list. 2b. Which ProcedureLogs methods are you using and what error message a...
by SLeon
Wed Jan 11, 2023 10:16 am
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

There are a few API requests in line before InsPlans POST. I would estimate that it will be implemented in roughly three weeks time.
by SLeon
Fri Jan 06, 2023 8:01 am
Forum: API
Topic: Subscription issue
Replies: 3
Views: 1490

Re: Subscription issue

Good morning Pedro, I am glad you enjoyed the latest API guide and am sorry you are still experiencing issues. Which troubleshooting steps have you tried? The first two bullet points from the guide resolve this for most customers. Ensure an instance of Open Dental (or the API Service) is running to ...
by SLeon
Thu Jan 05, 2023 10:25 am
Forum: API
Topic: Subscription issue
Replies: 3
Views: 1490

Re: Subscription issue

Good morning,

Just yesterday I posted an API Guide covering Subscriptions and Events here that you might find helpful. Have you already checked for the issues mentioned in the Troubleshooting section?
by SLeon
Thu Jan 05, 2023 10:15 am
Forum: API
Topic: Program Link Triggered E-Mail for Next appointment using n8n
Replies: 8
Views: 2384

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

Good morning,

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.
by SLeon
Wed Jan 04, 2023 1:11 pm
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177391

Re: API not found. Requesting new APIs

Yes we can add a POST method for the InsPlan resource for you to insert Insurance Plans. I have added this to our development list.
by SLeon
Wed Jan 04, 2023 9:57 am
Forum: API
Topic: API Guide – Subscriptions and Events
Replies: 0
Views: 6272

API Guide – Subscriptions and Events

ApiEvents are webhooks sent to a developer’s webhook site when certain changes occur in Open Dental. There are two types of ApiEvents: UiEvents occur when a user has taken a certain action on their workstation. For example, the PatientSelected event will fire whenever a new patient is selected with...