Good morning,
Open Dental does not produce any logs for ApiEvents. However, you can look at the DateTimeStart value of your subscription to see if it was processed correctly. This time will not update if the software was unable to successfully connect to you webhook site.
Search found 489 matches
- Thu May 16, 2024 8:22 am
- Forum: API
- Topic: API Events - Webhooks with append, still an issue?
- Replies: 7
- Views: 152
- Mon May 13, 2024 10:57 am
- Forum: API
- Topic: API Events - Webhooks with append, still an issue?
- Replies: 7
- Views: 152
Re: API Events - Webhooks with append, still an issue?
I was able to successfully use a trailing '/' character for the Patient table subscription as well. Please share any information you are able to find in your search, or if any other questions come up.
- Mon May 13, 2024 10:42 am
- Forum: API
- Topic: API Events - Webhooks with append, still an issue?
- Replies: 7
- Views: 152
Re: API Events - Webhooks with append, still an issue?
I was unable to duplicate the issue with the steps provided. Base Case: I updated a test dental office to the latest beta (24.1.28). I created a webhook.site url I made a subscription with this URL (no trailing '/') for the Appointment table. I made changes to an appointment via the UI and via a rem...
- Mon May 13, 2024 8:10 am
- Forum: API
- Topic: API Events - Webhooks with append, still an issue?
- Replies: 7
- Views: 152
Re: API Events - Webhooks with append, still an issue?
Good morning,
There have not been any changes to ApiEvent Url formatting/sending logic since the change you linked (22.3). Can you please describe the symptoms you are observing?
There have not been any changes to ApiEvent Url formatting/sending logic since the change you linked (22.3). Can you please describe the symptoms you are observing?
- Wed May 08, 2024 1:38 pm
- Forum: API
- Topic: API Request | InsPlans GET by PlanNum
- Replies: 2
- Views: 142
Re: API Request | InsPlans GET by PlanNum
Good afternoon, Proposed addition: GET /inssubs/11 -- return specific plan GET /inssubs?CarrierNum=25&PlanType=p&IsHidden=false&Offset=100b -- return multiple plans I assume there is a typo and you want us to add ins plans GET functionality. We can add a GET (single) endpoint and add optional Carrie...
- Wed May 01, 2024 11:29 am
- Forum: Main Forum
- Topic: Delete Procedure Code
- Replies: 4
- Views: 529
Re: Delete Procedure Code
It sounds like you created a second code with "0210". From our Procedure Codes manual page: Note: Once created, a code can't be changed or deleted. Instead move it to an obsolete category. Moving it the an obsolete category will not prevent you from charting it, however, if you type in "0210" specif...
- Mon Apr 29, 2024 8:02 am
- Forum: API
- Topic: API Events | PatFields Events do not fire when PatFieldValue is cleared
- Replies: 2
- Views: 1228
Re: API Events | PatFields Events do not fire when PatFieldValue is cleared
Entering an empty string value for a PatField in the Open Dental program results in the deletion of that row. Subscriptions work by querying the database for items in the table (eg patfields) that have changed since the last batch of events are sent. Specifically for the patfield table, the query gr...
- Wed Apr 24, 2024 10:22 am
- Forum: Main Forum
- Topic: Subsciber ID in Xray Mounts
- Replies: 4
- Views: 4164
Re: Subsciber ID in Xray Mounts
This request is complete. It is available starting in versions 23.3.53 and 24.1.24.
- Tue Apr 23, 2024 8:31 am
- Forum: API
- Topic: Need help in getting Subscriber's Birthdate
- Replies: 2
- Views: 1056
Re: Need help in getting Subscriber's Birthdate
Good morning, In your example JSON, the FeildType value is "StaticText". From our Sheet Field Types Manual Page : Static Text: Text information such as labels and large paragraphs. Also includes fields that can be inserted as static text so that resulting text is specific to the patient (e.g., patie...
- Wed Apr 10, 2024 12:02 pm
- Forum: API
- Topic: Some eConnectors may be unavailable
- Replies: 1
- Views: 581
Re: Some eConnectors may be unavailable
All eConnectors should be functioning properly at this time.
- Wed Apr 10, 2024 9:44 am
- Forum: API
- Topic: Some eConnectors may be unavailable
- Replies: 1
- Views: 581
Some eConnectors may be unavailable
We are aware of an issue impacting some customer's eConnectors. Applications utilizing the Local and Service API should not be impacted. I will update this thread once the issue is resolved. Also see announcement on our main page https://www.opendental.com/index.html.
- Tue Apr 09, 2024 8:28 am
- Forum: API
- Topic: POST Query API - SFTP Intermittent Connectivity Issue
- Replies: 4
- Views: 692
Re: POST Query API - SFTP Intermittent Connectivity Issue
Good morning, If you are using the Remote Mode of the API (i.e. using the eConnector), you can see common troubleshooting steps here . That page also contains the location of the eConnector's log files, which could indicate an issue. The analogous logs for the Service Mode of the API are found in th...
- Mon Apr 08, 2024 11:20 am
- Forum: API
- Topic: POST Query API - SFTP Intermittent Connectivity Issue
- Replies: 4
- Views: 692
Re: POST Query API - SFTP Intermittent Connectivity Issue
Good morning, I assume the SftpAddress is functioning properly if the other ~30 dental offices are able to successfully utilize it. Manually connecting from the Dental Office server (wherever the eConnector/APIService is installed) to the SftpAddress is the perfect first step. I have not experienced...
- Thu Feb 15, 2024 9:08 am
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 13
- Views: 5741
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 ...
- Tue Feb 13, 2024 3:29 pm
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 13
- Views: 5741
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...
- Tue Feb 13, 2024 1:18 pm
- Forum: API
- Topic: **URGENT BENEFITS ISSUE**
- Replies: 18
- Views: 2911
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...
- Fri Feb 09, 2024 11:38 am
- Forum: API
- Topic: How to retrieve Open Dental's calculated insurance and patient portions?
- Replies: 13
- Views: 5741
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...
- Tue Feb 06, 2024 7:37 am
- Forum: API
- Topic: Fam Urgent Fin Note:
- Replies: 1
- Views: 1192
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.
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.
- Mon Jan 29, 2024 3:36 pm
- Forum: API
- Topic: Documents POST Upload - Profile Photo
- Replies: 4
- Views: 1406
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...
- Mon Jan 29, 2024 8:11 am
- Forum: API
- Topic: Issues making any requests
- Replies: 2
- Views: 1290
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...
- Thu Jan 25, 2024 2:08 pm
- Forum: API
- Topic: Posting a statement to the account ledger
- Replies: 6
- Views: 2335
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.
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.
- Wed Jan 24, 2024 12:00 pm
- Forum: API
- Topic: API Queries POST architecture question
- Replies: 1
- Views: 1263
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.
- Mon Jan 22, 2024 8:51 am
- Forum: API
- Topic: Appointment Slots (proposal for API)
- Replies: 9
- Views: 3837
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...
- Fri Jan 19, 2024 1:40 pm
- Forum: API
- Topic: Appointment Slots (proposal for API)
- Replies: 9
- Views: 3837
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...
- Wed Jan 10, 2024 3:10 pm
- Forum: API
- Topic: Subscription issues
- Replies: 1
- Views: 1580
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.
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.
- Wed Jan 10, 2024 2:16 pm
- Forum: API
- Topic: Dynamic payment plans amount discrepency
- Replies: 3
- Views: 2068
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...
- Wed Jan 10, 2024 9:40 am
- Forum: API
- Topic: TreatPlans POST
- Replies: 36
- Views: 10158
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...
- Wed Jan 10, 2024 9:31 am
- Forum: API
- Topic: Dynamic payment plans amount discrepency
- Replies: 3
- Views: 2068
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...
- Wed Jan 10, 2024 8:41 am
- Forum: API
- Topic: API Request/Help - Time Cards
- Replies: 6
- Views: 2924
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...
- Wed Jan 10, 2024 8:34 am
- Forum: API
- Topic: New API feature requests
- Replies: 2
- Views: 3000
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...
- Tue Jan 09, 2024 11:28 am
- Forum: API
- Topic: API FeeScheds Request
- Replies: 8
- Views: 4814
- Mon Jan 08, 2024 10:11 am
- Forum: Main Forum
- Topic: Duplicate records in the PerioMeasure table.
- Replies: 2
- Views: 2429
Re: Duplicate records in the PerioMeasure table.
We recommend you contact support for help with this issue.
- Fri Jan 05, 2024 9:03 am
- Forum: API
- Topic: Appointment Summary View
- Replies: 5
- Views: 2845
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...
- Tue Jan 02, 2024 10:35 am
- Forum: API
- Topic: Issue with Claims API
- Replies: 1
- Views: 1500
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...
- Tue Dec 26, 2023 8:43 am
- Forum: Main Forum
- Topic: Plugin Forum Posts Deleted
- Replies: 1
- Views: 3875
Re: Plugin Forum Posts Deleted
Good morning,
Posts previously in the "Plug-ins" category have been moved to the "Main Forum" and "Developers" categories.
Posts previously in the "Plug-ins" category have been moved to the "Main Forum" and "Developers" categories.
- Fri Dec 15, 2023 8:20 am
- Forum: Main Forum
- Topic: dreaded duplicate entry key primary
- Replies: 2
- Views: 2850
Re: dreaded duplicate entry key primary
I recommend calling support for help on this issue.
- Mon Dec 11, 2023 12:48 pm
- Forum: API
- Topic: Appointment Summary View
- Replies: 5
- Views: 2845
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...
- Fri Dec 08, 2023 3:38 pm
- Forum: API
- Topic: Local API Service Authorization
- Replies: 3
- Views: 1860
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.
- Fri Dec 08, 2023 9:27 am
- Forum: API
- Topic: New API feature requests
- Replies: 2
- Views: 3000
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.
- Fri Dec 08, 2023 8:15 am
- Forum: API
- Topic: Local API Service Authorization
- Replies: 3
- Views: 1860
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...
- Wed Dec 06, 2023 9:07 am
- Forum: API
- Topic: Appointment Summary View
- Replies: 5
- Views: 2845
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....
- Tue Dec 05, 2023 10:05 am
- Forum: API
- Topic: Open Dental Events API
- Replies: 6
- Views: 2198
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...
- Mon Dec 04, 2023 3:35 pm
- Forum: API
- Topic: Open Dental Events API
- Replies: 6
- Views: 2198
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...
- Mon Dec 04, 2023 2:57 pm
- Forum: API
- Topic: Open Dental Events API
- Replies: 6
- Views: 2198
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...
- Mon Dec 04, 2023 8:23 am
- Forum: Main Forum
- Topic: Windows 11 support
- Replies: 1
- Views: 2916
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.
- Mon Dec 04, 2023 8:19 am
- Forum: API
- Topic: Issue with planType field
- Replies: 1
- Views: 1491
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: .....
- Fri Dec 01, 2023 10:29 am
- Forum: API
- Topic: New API feature requests
- Replies: 2
- Views: 3000
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...
- Tue Nov 28, 2023 1:59 pm
- Forum: API
- Topic: API Request/Help - Time Cards
- Replies: 6
- Views: 2924
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.
- Tue Nov 28, 2023 1:33 pm
- Forum: API
- Topic: API Request/Help - Time Cards
- Replies: 6
- Views: 2924
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 ...
- 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: 1725
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...
- Tue Nov 21, 2023 3:30 pm
- Forum: API
- Topic: API For Client Keys?
- Replies: 4
- Views: 1750
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?
- Tue Nov 21, 2023 3:17 pm
- Forum: API
- Topic: API For Client Keys?
- Replies: 4
- Views: 1750
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...
- Tue Nov 21, 2023 10:57 am
- Forum: API
- Topic: New API Request for all patients aging balance
- Replies: 6
- Views: 2548
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...
- 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: 1725
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=...
- Thu Nov 16, 2023 10:45 am
- Forum: Main Forum
- Topic: Add Hook for the Plugin
- Replies: 9
- Views: 4655
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).
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).
- Tue Nov 14, 2023 1:55 pm
- Forum: API
- Topic: Appointments PUT Confirm (add value)
- Replies: 1
- Views: 1343
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...
- Fri Nov 10, 2023 2:46 pm
- Forum: API
- Topic: Deprecation of PayPlans POST
- Replies: 12
- Views: 5203
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...
- Thu Nov 09, 2023 9:11 am
- Forum: API
- Topic: New API Request for all patients aging balance
- Replies: 6
- Views: 2548
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 ...
- Wed Nov 01, 2023 3:12 pm
- Forum: API
- Topic: Deprecation of PayPlans POST
- Replies: 12
- Views: 5203
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...
- Wed Nov 01, 2023 8:12 am
- Forum: API
- Topic: New API Request for all patients aging balance
- Replies: 6
- Views: 2548
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 ...
- Tue Oct 31, 2023 10:07 am
- Forum: Main Forum
- Topic: Add Hook for the Plugin
- Replies: 9
- Views: 4655
Re: Add Hook for the Plugin
I have added this to our list and will update this thread once it is complete. Thank you.
- Fri Oct 27, 2023 11:51 am
- Forum: API
- Topic: Deprecation of PayPlans POST
- Replies: 12
- Views: 5203
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...
- Fri Oct 27, 2023 8:07 am
- Forum: Developers
- Topic: Calculating Max Remaning w/ Insurance Benefit Adjustments
- Replies: 1
- Views: 3330
Re: Calculating Max Remaning w/ Insurance Benefit Adjustments
Please see my reply on your cross-post of this question in "Advanced Topics".
- Fri Oct 27, 2023 8:05 am
- Forum: Advanced Topics
- Topic: Calculating Max Remaining using SQL and/or APIs... ???
- Replies: 2
- Views: 2915
- Wed Oct 25, 2023 2:05 pm
- Forum: API
- Topic: Deprecation of PayPlans POST
- Replies: 12
- Views: 5203
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?
- Fri Oct 20, 2023 7:28 am
- Forum: API
- Topic: POST Query Timeout Issue
- Replies: 6
- Views: 3055
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...
- Thu Oct 19, 2023 1:44 pm
- Forum: API
- Topic: Bulk update comm log
- Replies: 7
- Views: 2076
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...
- Thu Oct 19, 2023 1:34 pm
- Forum: API
- Topic: SubstitutionLinks Question
- Replies: 1
- Views: 1322
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.
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...
Re: API Needs
- Thu Oct 12, 2023 11:24 am
- Forum: API
- Topic: POST Query Timeout Issue
- Replies: 6
- Views: 3055
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...
- Tue Oct 10, 2023 2:17 pm
- Forum: API
- Topic: What is the best approach/mechanism for reporting API outages?
- Replies: 7
- Views: 1928
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.
- Tue Oct 10, 2023 8:18 am
- Forum: API
- Topic: What is the best approach/mechanism for reporting API outages?
- Replies: 7
- Views: 1928
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...
- Mon Oct 02, 2023 2:59 pm
- Forum: API
- Topic: TreatPlanAttaches
- Replies: 6
- Views: 2027
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...
- Mon Oct 02, 2023 1:03 pm
- Forum: API
- Topic: TreatPlanAttaches
- Replies: 6
- Views: 2027
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.
Once complete, all new API methods require the dental office to update to use the new feature.
- Mon Oct 02, 2023 9:16 am
- Forum: API
- Topic: TreatPlanAttaches
- Replies: 6
- Views: 2027
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...
- Wed Sep 20, 2023 7:49 am
- Forum: API
- Topic: Appointments POST (create) does not update/set Recall schedule dates
- Replies: 7
- Views: 2785
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.
This feature request is actively in development and will completed rather shortly.
- Tue Sep 19, 2023 8:34 am
- Forum: API
- Topic: API Update request for commlog POST
- Replies: 4
- Views: 1956
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.
- Mon Sep 18, 2023 10:09 am
- Forum: API
- Topic: TreatPlans POST
- Replies: 36
- Views: 10158
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 ...
- Tue Sep 12, 2023 3:01 pm
- Forum: API
- Topic: Benefit API Issue
- Replies: 7
- Views: 2505
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...
- Tue Sep 12, 2023 1:49 pm
- Forum: API
- Topic: Benefit API Issue
- Replies: 7
- Views: 2505
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?
- Thu Sep 07, 2023 8:04 am
- Forum: API
- Topic: Bad request
- Replies: 1
- Views: 1208
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 ...
- Wed Sep 06, 2023 9:41 pm
- Forum: API
- Topic: TreatPlans POST
- Replies: 36
- Views: 10158
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.
- Thu Aug 31, 2023 11:51 am
- Forum: API
- Topic: Detailed aging balance
- Replies: 4
- Views: 1535
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...
- Tue Aug 29, 2023 1:35 pm
- Forum: API
- Topic: Detailed aging balance
- Replies: 4
- Views: 1535
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 ...
- Tue Aug 29, 2023 8:37 am
- Forum: Main Forum
- Topic: 23.2 beta period length?
- Replies: 6
- Views: 4353
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.
- Fri Aug 25, 2023 9:23 am
- Forum: API
- Topic: PayPlans POST enhancement requests
- Replies: 4
- Views: 1917
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.
- Mon Aug 14, 2023 6:58 pm
- Forum: API
- Topic: Scheduled API Server Maintenance (8/14/2023)
- Replies: 1
- Views: 5521
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.
- Mon Aug 14, 2023 1:30 pm
- Forum: API
- Topic: Scheduled API Server Maintenance (8/14/2023)
- Replies: 1
- Views: 5521
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...
- Wed Aug 09, 2023 1:30 pm
- Forum: API
- Topic: Recent Feature Requests
- Replies: 3
- Views: 1847
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 ...
- Wed Aug 02, 2023 8:48 pm
- Forum: API
- Topic: API Issues
- Replies: 5
- Views: 1857
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...
- Tue Aug 01, 2023 2:38 pm
- Forum: API
- Topic: Recent Feature Requests
- Replies: 3
- Views: 1847
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...
- Mon Jul 31, 2023 1:15 pm
- Forum: API
- Topic: TreatPlans POST
- Replies: 36
- Views: 10158
Re: TreatPlans POST
Good afternoon Pedro,
No update on this feature request yet, development will start on it soon.
No update on this feature request yet, development will start on it soon.
- Fri Jul 28, 2023 7:46 am
- Forum: API
- Topic: Payment POST question
- Replies: 10
- Views: 3366
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?
The API does not currently have a Payments PUT method. Which fields would you want to update for a payment?
- Fri Jul 21, 2023 8:12 am
- Forum: API
- Topic: Recent Feature Requests
- Replies: 3
- Views: 1847
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.
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.
- Wed Jul 19, 2023 8:22 am
- Forum: API
- Topic: OpenDental API Version
- Replies: 2
- Views: 1295
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...
- Tue Jul 18, 2023 8:23 am
- Forum: API
- Topic: Completed codes update questions
- Replies: 8
- Views: 3251
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...
- Mon Jul 17, 2023 12:56 pm
- Forum: API
- Topic: Date Issue with API
- Replies: 10
- Views: 4589
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...
- Fri Jul 14, 2023 8:11 am
- Forum: API
- Topic: Recent Feature Requests
- Replies: 3
- Views: 1847
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...
- Tue Jul 11, 2023 11:38 am
- Forum: API
- Topic: Appointment Cost
- Replies: 1
- Views: 1276
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:
Are you referring to the "Est. Patient Portion" value in the Appointment Edit window?
From our manual: Appointment Edit - Patient Info Grid:
- Tue Jul 11, 2023 11:16 am
- Forum: API
- Topic: New API for Notes functionality
- Replies: 8
- Views: 4643
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 ...
- Tue Jul 11, 2023 10:31 am
- Forum: API
- Topic: TreatPlans POST
- Replies: 36
- Views: 10158
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.
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.
- Tue Jul 11, 2023 8:41 am
- Forum: API
- Topic: TreatPlans POST
- Replies: 36
- Views: 10158
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 ...
- Tue Jul 11, 2023 8:25 am
- Forum: API
- Topic: Not getting all commlogs in GET API
- Replies: 2
- Views: 1468
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...
- Thu Jul 06, 2023 2:57 pm
- Forum: API
- Topic: API for web forms
- Replies: 6
- Views: 3068
Re: API for web forms
Yes, we can add IsWebForm to Sheets GET. I have added this to our development list.
- Thu Jul 06, 2023 2:51 pm
- Forum: API
- Topic: API for web forms
- Replies: 6
- Views: 3068
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.
- Thu Jul 06, 2023 2:34 pm
- Forum: API
- Topic: API for web forms
- Replies: 6
- Views: 3068
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?
- Fri Jun 30, 2023 8:15 am
- Forum: API
- Topic: Some Data We Can Not Found in Query #43132
- Replies: 5
- Views: 3291
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.
- Fri Jun 30, 2023 8:08 am
- Forum: API
- Topic: Some Data We Can Not Found in Query #43132
- Replies: 5
- Views: 3291
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.
- Thu Jun 29, 2023 1:32 pm
- Forum: API
- Topic: TreatPlans POST
- Replies: 36
- Views: 10158
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.
- Thu Jun 29, 2023 12:06 pm
- Forum: API
- Topic: TreatPlans POST
- Replies: 36
- Views: 10158
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...
- Thu Jun 29, 2023 11:45 am
- Forum: API
- Topic: TreatPlans POST
- Replies: 36
- Views: 10158
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.
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.
- Mon Jun 26, 2023 9:47 am
- Forum: API
- Topic: API query error message
- Replies: 4
- Views: 2066
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.
I was able to run this query with the Public Demo dental office credentials without issue.
- Wed Jun 21, 2023 9:17 am
- Forum: Main Forum
- Topic: Seeking help to get data
- Replies: 1
- Views: 2944
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.
- Thu Jun 15, 2023 8:52 am
- Forum: API
- Topic: Some Data We Can Not Found in Query #43132
- Replies: 5
- Views: 3291
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.
- Thu Jun 15, 2023 8:23 am
- Forum: API
- Topic: Claim create
- Replies: 9
- Views: 4452
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.
The API will not support interactions with DXC (or any other third party) integrations that exist in Open Dental.
- Tue Jun 13, 2023 8:27 am
- Forum: API
- Topic: API Query timeout
- Replies: 7
- Views: 3923
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...
- Tue Jun 13, 2023 7:56 am
- Forum: API
- Topic: API Query timeout
- Replies: 7
- Views: 3923
Re: API Query 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.beacondental wrote: ↑Tue Jun 13, 2023 7:30 amWe have tried both ways for query that has 1800 lines of code and it gets timeout.
- Tue Jun 06, 2023 11:08 am
- Forum: API
- Topic: Patient portal API
- Replies: 3
- Views: 3182
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?
- Thu Jun 01, 2023 7:52 am
- Forum: API
- Topic: Add OrthoRemainM to Claim PUT API
- Replies: 4
- Views: 3735
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.
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.
- Wed May 31, 2023 12:43 pm
- Forum: API
- Topic: Payments POST - set payType
- Replies: 18
- Views: 5650
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.
- Wed May 31, 2023 9:58 am
- Forum: API
- Topic: API Query timeout
- Replies: 7
- Views: 3923
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...
- Tue May 30, 2023 8:07 am
- Forum: API
- Topic: API Query timeout
- Replies: 7
- Views: 3923
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...
- Mon May 22, 2023 12:53 pm
- Forum: API
- Topic: EOB attachments
- Replies: 7
- Views: 4538
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 ...
- Mon May 22, 2023 11:46 am
- Forum: API
- Topic: EOB attachments
- Replies: 7
- Views: 4538
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?
Do you need to also download the EOB files, or just get the file information?
- Mon May 22, 2023 8:40 am
- Forum: API
- Topic: Outstanding insurance claims
- Replies: 1
- Views: 2723
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...
- Wed May 17, 2023 10:14 am
- Forum: API
- Topic: Date Issue with API
- Replies: 10
- Views: 4589
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 ...
- Wed May 17, 2023 8:57 am
- Forum: API
- Topic: Request benefits in family module
- Replies: 13
- Views: 5778
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...
- Wed May 17, 2023 8:37 am
- Forum: API
- Topic: Date Issue with API
- Replies: 10
- Views: 4589
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...
- Tue May 16, 2023 2:59 pm
- Forum: API
- Topic: Request benefits in family module
- Replies: 13
- Views: 5778
Re: Request benefits in family module
You probably want to use our ClaimProcs PUT InsAdjust method.
- Tue May 16, 2023 2:44 pm
- Forum: API
- Topic: New API for Notes functionality
- Replies: 8
- Views: 4643
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...
- Tue May 16, 2023 1:56 pm
- Forum: API
- Topic: Income transfer manager
- Replies: 5
- Views: 3535
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...
- Tue May 16, 2023 1:21 pm
- Forum: API
- Topic: Appointments GET Slots
- Replies: 7
- Views: 4656
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...
- Tue May 16, 2023 12:22 pm
- Forum: API
- Topic: API Security permission
- Replies: 4
- Views: 3816
Re: API Security permission
We have added UserGroups GET and UserGroupAttaches GET to our development list.
- Tue May 16, 2023 8:19 am
- Forum: API
- Topic: API Security permission
- Replies: 4
- Views: 3816
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...
- Mon May 15, 2023 11:29 am
- Forum: API
- Topic: Post Patient Photo
- Replies: 1
- Views: 2644
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...
- Mon May 15, 2023 8:10 am
- Forum: API
- Topic: Income transfer manager
- Replies: 5
- Views: 3535
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.
- Mon May 15, 2023 7:56 am
- Forum: API
- Topic: Do not bill
- Replies: 4
- Views: 3245
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.
- Mon May 15, 2023 7:50 am
- Forum: API
- Topic: Do not bill
- Replies: 4
- Views: 3245
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.
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.
- Mon May 15, 2023 7:25 am
- Forum: API
- Topic: Poayment post question
- Replies: 1
- Views: 2591
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...
- Fri May 12, 2023 12:25 pm
- Forum: API
- Topic: New API Request
- Replies: 16
- Views: 5793
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 ...
- Fri May 12, 2023 8:02 am
- Forum: API
- Topic: Claim create
- Replies: 9
- Views: 4452
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 ...
- Tue May 09, 2023 3:40 pm
- Forum: API
- Topic: Program links
- Replies: 3
- Views: 3101
- Mon May 08, 2023 1:22 pm
- Forum: API
- Topic: Database maintenance
- Replies: 1
- Views: 3026
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.
- Mon May 08, 2023 10:08 am
- Forum: API
- Topic: Claim create
- Replies: 9
- Views: 4452
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.
- Mon May 08, 2023 10:00 am
- Forum: API
- Topic: Confirmation status
- Replies: 6
- Views: 4307
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?
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?
- Mon May 08, 2023 9:49 am
- Forum: API
- Topic: API: Searching patient with apostrophe in name throws error
- Replies: 2
- Views: 2766
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...
- Tue May 02, 2023 2:43 pm
- Forum: API
- Topic: Quick API Question
- Replies: 2
- Views: 3262
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 ...
- Mon Apr 24, 2023 2:32 pm
- Forum: API
- Topic: Supporting Clinics as a Third Party Software Provider
- Replies: 7
- Views: 4531
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...
- Wed Apr 19, 2023 11:50 am
- Forum: API
- Topic: Database Integrity
- Replies: 6
- Views: 9089
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...
- Mon Apr 17, 2023 3:12 pm
- Forum: API
- Topic: Supporting Clinics as a Third Party Software Provider
- Replies: 7
- Views: 4531
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 ...
- Mon Apr 17, 2023 11:54 am
- Forum: API
- Topic: Supporting Clinics as a Third Party Software Provider
- Replies: 7
- Views: 4531
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:
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
- Thu Apr 13, 2023 3:32 pm
- Forum: API
- Topic: Request for a PUT to update data via the DiscountPlanSubs API
- Replies: 10
- Views: 4582
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.
- Thu Apr 13, 2023 9:17 am
- Forum: API
- Topic: Supporting Clinics as a Third Party Software Provider
- Replies: 7
- Views: 4531
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...
- Wed Apr 12, 2023 2:22 pm
- Forum: API
- Topic: Prepayments for dynamic payment plans
- Replies: 6
- Views: 3844
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.
- Tue Apr 11, 2023 11:43 am
- Forum: API
- Topic: New API Request for multiple ProcedureLogs PUT (update)
- Replies: 1
- Views: 3158
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 ...
- Tue Apr 11, 2023 11:24 am
- Forum: API
- Topic: Payments POST - set payType
- Replies: 18
- Views: 5650
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...
- Mon Apr 10, 2023 7:12 am
- Forum: API
- Topic: New API Request for Patient Ledger
- Replies: 2
- Views: 3145
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...
- Fri Apr 07, 2023 9:48 am
- Forum: API
- Topic: Patients GET Add Zip
- Replies: 3
- Views: 3352
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.
- Wed Apr 05, 2023 4:01 pm
- Forum: API
- Topic: New API Request
- Replies: 16
- Views: 5793
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.
- Tue Apr 04, 2023 2:21 pm
- Forum: API
- Topic: Payments POST - set payType
- Replies: 18
- Views: 5650
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...
- Tue Apr 04, 2023 9:27 am
- Forum: API
- Topic: Payments POST - set payType
- Replies: 18
- Views: 5650
Re: Payments POST - set payType
The PayType is decided by the dental office when they enable the API:
You can see which PayType they have selected by using Preferences GET to retrieve the ApiPaymentType preference.
You can see which PayType they have selected by using Preferences GET to retrieve the ApiPaymentType preference.
- Tue Apr 04, 2023 6:38 am
- Forum: API
- Topic: Request for a PUT to update data via the DiscountPlanSubs API
- Replies: 10
- Views: 4582
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...
- Mon Apr 03, 2023 3:27 pm
- Forum: API
- Topic: Testing certain functionality
- Replies: 3
- Views: 2944
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...
- Mon Apr 03, 2023 2:57 pm
- Forum: API
- Topic: New API Request
- Replies: 16
- Views: 5793
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". ...
- Wed Mar 29, 2023 8:06 am
- Forum: API
- Topic: Customer API Key
- Replies: 8
- Views: 6733
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...
- Mon Mar 27, 2023 1:53 pm
- Forum: API
- Topic: Appointments POST (create) > PatientFirstVisitDdate not populating
- Replies: 7
- Views: 4076
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...
- Mon Mar 27, 2023 7:58 am
- Forum: API
- Topic: What version is reaured for subscription/events/watch tables?
- Replies: 1
- Views: 1689
Re: What version is reaured for subscription/events/watch tables?
Good morning,
From our documentation:
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.
- Wed Mar 22, 2023 11:02 am
- Forum: API
- Topic: API not found. Requesting new APIs
- Replies: 57
- Views: 184417
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 ...
- Fri Mar 17, 2023 12:35 pm
- Forum: API
- Topic: API not found. Requesting new APIs
- Replies: 57
- Views: 184417
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.
- Fri Mar 17, 2023 10:01 am
- Forum: API
- Topic: Multiple location offices
- Replies: 1
- Views: 1604
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...
- Thu Mar 16, 2023 8:13 am
- Forum: API
- Topic: API not found. Requesting new APIs
- Replies: 57
- Views: 184417
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...
- Wed Mar 15, 2023 2:49 pm
- Forum: API
- Topic: Appointments POST (create) > PatientFirstVisitDdate not populating
- Replies: 7
- Views: 4076
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...
- Wed Mar 08, 2023 12:20 pm
- Forum: API
- Topic: Use OpenDental credentials to log into website?
- Replies: 3
- Views: 1694
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.)...
- Tue Mar 07, 2023 4:19 pm
- Forum: API
- Topic: Appointments GET Slots
- Replies: 7
- Views: 4656
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...
- Tue Mar 07, 2023 8:34 am
- Forum: API
- Topic: API not found. Requesting new APIs
- Replies: 57
- Views: 184417
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...
- Mon Mar 06, 2023 9:09 am
- Forum: API
- Topic: Patients GET Add Zip
- Replies: 3
- Views: 3352
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.
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.
- Thu Feb 23, 2023 3:25 pm
- Forum: API
- Topic: Urgent API Issue
- Replies: 3
- Views: 1683
Re: Urgent API Issue
Please see my private message reply.
- Thu Feb 23, 2023 2:32 pm
- Forum: API
- Topic: Urgent API Issue
- Replies: 3
- Views: 1683
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.
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.
- Wed Feb 22, 2023 12:54 pm
- Forum: API
- Topic: API not found. Requesting new APIs
- Replies: 57
- Views: 184417
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...
- Tue Feb 21, 2023 8:12 am
- Forum: API
- Topic: Benefits API req
- Replies: 19
- Views: 4863
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.
This feature request is in the final stages of development and nearly finished. I will update this thread soon.
- Mon Feb 20, 2023 1:18 pm
- Forum: API
- Topic: API not found. Requesting new APIs
- Replies: 57
- Views: 184417
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.
@Omar22, Yes. Use InsSubs POST to subscribe a patient to an existing InsPlan.
- Mon Feb 20, 2023 11:13 am
- Forum: API
- Topic: Regular slots API ignoring blockouts
- Replies: 2
- Views: 1309
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 ...
- Fri Feb 17, 2023 8:37 am
- Forum: API
- Topic: Email and text functions via API
- Replies: 5
- Views: 1783
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 ...
- Thu Feb 16, 2023 3:11 pm
- Forum: API
- Topic: Email and text functions via API
- Replies: 5
- Views: 1783
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 .
- Thu Feb 16, 2023 9:15 am
- Forum: API
- Topic: API not found. Requesting new APIs
- Replies: 57
- Views: 184417
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.
- Mon Feb 13, 2023 11:09 am
- Forum: API
- Topic: Error on medicationPats api
- Replies: 3
- Views: 1550
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?
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?
- Fri Feb 10, 2023 9:04 am
- Forum: API
- Topic: ProcedureLogs Date Range
- Replies: 1
- Views: 1112
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...
- Fri Feb 10, 2023 8:14 am
- Forum: API
- Topic: procCode in procedurelogs
- Replies: 8
- Views: 2848
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...
- Wed Feb 08, 2023 8:38 am
- Forum: API
- Topic: HTTPS for OpenDental local API
- Replies: 1
- Views: 1162
Re: HTTPS for OpenDental local API
This is something we can look into. Could you please describe your use case requiring SSL handshakes?
- Mon Feb 06, 2023 8:43 am
- Forum: API
- Topic: getting Reports thru the API
- Replies: 1
- Views: 1241
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...
- Mon Feb 06, 2023 8:02 am
- Forum: API
- Topic: procCode in procedurelogs
- Replies: 8
- Views: 2848
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.
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.
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...
- Tue Jan 31, 2023 8:52 am
- Forum: API
- Topic: API not found. Requesting new APIs
- Replies: 57
- Views: 184417
Re: API not found. Requesting new APIs
Good morning,
Unfortunately we are unable to release new features beyond our beta version.
Unfortunately we are unable to release new features beyond our beta version.
- Wed Jan 25, 2023 11:10 am
- Forum: API
- Topic: API PUT request -SQLcommand issue
- Replies: 1
- Views: 1124
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 ...
- Wed Jan 25, 2023 10:45 am
- Forum: API
- Topic: API not found. Requesting new APIs
- Replies: 57
- Views: 184417
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 ...
- Tue Jan 24, 2023 9:07 am
- Forum: API
- Topic: Payments POST - Change PayType
- Replies: 1
- Views: 1256
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...
- Thu Jan 19, 2023 2:08 pm
- Forum: API
- Topic: Treatment Plans
- Replies: 5
- Views: 1961
Re: Treatment Plans
There are six feature requests in line in front of this, so I would estimate a couple weeks from now.
- Thu Jan 19, 2023 10:23 am
- Forum: API
- Topic: API Guide - The API Service
- Replies: 0
- Views: 8671
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...
- Wed Jan 18, 2023 9:07 am
- Forum: API
- Topic: API not found. Requesting new APIs
- Replies: 57
- Views: 184417
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...