Search found 113 matches

by mandmdiet
Mon Mar 18, 2024 2:59 pm
Forum: API
Topic: API Availability Check?
Replies: 6
Views: 162

Re: API Availability Check?

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

Re: API Availability Check?

Thanks for that fast reply, I think I understand. The public demo credentials are meant to be a means by which I can determine if I have my API implementation set up correctly it sounds like. In this case, I'm more looking for a way to be sure I have connectivity with a specific office to eliminate ...
by mandmdiet
Mon Mar 18, 2024 8:35 am
Forum: API
Topic: API Availability Check?
Replies: 6
Views: 162

Re: API Availability Check?

Thanks justine, How do those public demo credentials work? What request should we send to the API using those credentials? This won't give us a valid indication as to whether we'd be successful using the API normally would it? Since something could be wrong related to our generated customer key? For...
by mandmdiet
Thu Mar 14, 2024 2:43 pm
Forum: API
Topic: API Availability Check?
Replies: 6
Views: 162

API Availability Check?

We would like to be able to keep our users informed of the current connectivity status of our application to the Open Dental API. For example, if someone removes the customer API key from Open Dental or just hasn't added it yet or if something is down on the PMS machine or even if the Open Dental AP...
by mandmdiet
Thu Feb 08, 2024 1:52 pm
Forum: API
Topic: Request For Table Indexes?
Replies: 6
Views: 605

Re: Request For Table Indexes?

Thanks Allends, yes I understand that not having visibility into our requirements makes this difficult. I apologize for that. One thing I want to mention is I was just beginning this thread to understand whether Open Dental accepts requests to add indexes to tables if we discover we need them, so th...
by mandmdiet
Wed Feb 07, 2024 6:56 am
Forum: API
Topic: Request For Table Indexes?
Replies: 6
Views: 605

Re: Request For Table Indexes?

I had a good conversation with justine about this over the last couple of weeks. The details of what we're doing is in there. https://www.opendentalsoft.com:8085/forum/viewtopic.php?f=9&t=8193 Here is a relevant tidbit to your question We have users who, when using our software, will see a list of c...
by mandmdiet
Tue Feb 06, 2024 2:00 pm
Forum: API
Topic: POST Query Timeout Issue
Replies: 6
Views: 2064

Re: POST Query Timeout Issue

This is great, we really appreciate this DerekR!
by mandmdiet
Tue Feb 06, 2024 1:56 pm
Forum: API
Topic: Request For Table Indexes?
Replies: 6
Views: 605

Re: Request For Table Indexes?

Thanks for the reply allends There are several tables in OD that we intend to poll on an interval. To save on number of requests to the OD Remote API, we want to poll those tables in a single UNION if possible. We don't know what kind of volume of data we'd expect to find in the wild, but we are wor...
by mandmdiet
Tue Feb 06, 2024 10:13 am
Forum: API
Topic: Request For Table Indexes?
Replies: 6
Views: 605

Request For Table Indexes?

Is it possible for us to make a request that OD add indexes to tables to help improve our ability to query data quickly? We're using the Remote API to to poll some tables for changes. We intend to do that using the TIMESTAMP fields we found in these tables, but some (or most?) of the tables don't ha...
by mandmdiet
Wed Jan 31, 2024 12:31 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 1475

Re: API Events Question

Great! Thank you!
by mandmdiet
Wed Jan 31, 2024 10:28 am
Forum: API
Topic: API Events Question
Replies: 20
Views: 1475

Re: API Events Question

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

Re: API Events Question

OK, I've re-read that API documentation and have a better understanding. Remote API is the API that we are using now found at https://api.opendental.com/api/v1 I have a few questions about Cloud API. 1. Since Cloud API connects directly to the API Service running on the Open Dental Cloud VM, what is...
by mandmdiet
Wed Jan 31, 2024 6:07 am
Forum: API
Topic: API Events Question
Replies: 20
Views: 1475

Re: API Events Question

OK, Thank you again justine.
by mandmdiet
Tue Jan 30, 2024 3:42 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 1475

Re: API Events Question

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

Re: API Events Question

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

Re: API Events Question

Thank you for your reply justine I understand, we wouldn't want to do that many queries but it's important for me to understand our throughput allowances so I can make sure whatever we design doesn't run afoul of any limits Open Dental has set as we expand. Here's what I'm thinking at the moment, I'...
by mandmdiet
Mon Jan 29, 2024 9:34 am
Forum: API
Topic: API Events Question
Replies: 20
Views: 1475

Re: API Events Question

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

Re: API Events Question

No, there is not. However, if you have a ClaimNum that was previously valid, but Claims GET is returning 'NotFound', it has likely been deleted. Additionally, if a claim was deleted via OD API, a securitylog was created. You could then use SecurityLogs GET with PermType=ClaimDelete, which would ret...
by mandmdiet
Thu Jan 25, 2024 2:30 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 1475

Re: API Events Question

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

Re: API Events Question

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

API Events Question

For the API Events functionality, specifically Database Events, in the Open Dental API, it says that "Open Dental and the API Service generate these events by polling the database at the frequency you specify." My question is, does it do this by checking a timestamp or other date field in the table ...
by mandmdiet
Wed Jan 24, 2024 11:37 am
Forum: API
Topic: API Queries POST architecture question
Replies: 1
Views: 416

API Queries POST architecture question

When we use the Queries POST API endpoint, which machine does the file transfer to our SFTP server? Does the eConnector machine connect directly to our SFTP server and upload the file? If yes to the above, are the credentials for our SFTP server that have been sent to the machine protected in some w...
by mandmdiet
Tue Jan 23, 2024 12:07 pm
Forum: Developers
Topic: Custom Software + Open Dental Cloud
Replies: 4
Views: 1017

Re: Custom Software + Open Dental Cloud

Thanks again jsalmon.
by mandmdiet
Fri Jan 19, 2024 8:38 am
Forum: Developers
Topic: Custom Software + Open Dental Cloud
Replies: 4
Views: 1017

Re: Custom Software + Open Dental Cloud

Thanks for the reply jsalmon, I'm just trying to get a bit more information to understand because I can't find a lot of information about this specific thing online. If a customer moves to OD cloud, is their database just moved to the cloud and are they able to connect to that from either the OD Win...
by mandmdiet
Tue Jan 09, 2024 1:43 pm
Forum: Developers
Topic: Custom Software + Open Dental Cloud
Replies: 4
Views: 1017

Custom Software + Open Dental Cloud

We have an application that users have been installing on their MySQL database server that connects to the database locally and reads data from the MySQL or Maria DB binlog (binlog is enabled ahead of time to make this possible). How would we support this application if a customer moves to Open Dent...
by mandmdiet
Tue Dec 05, 2023 1:09 pm
Forum: API
Topic: Open Dental Events API
Replies: 6
Views: 1935

Re: Open Dental Events API

OK, I assumed that the computations were done in the application code ... So the concern is with the queries that hit the database to perform this calculation ... I see. I think we're left with the only option being that we call that API whenever one of those tables changes and to optimize it so tha...
by mandmdiet
Tue Dec 05, 2023 6:56 am
Forum: API
Topic: Open Dental Events API
Replies: 6
Views: 1935

Re: Open Dental Events API

I think the thing that would really help us is if the balance in the patient table was updated whenever a patient's balance changes. That way we could monitor the patient table balance fields for changes. Our current solution has been to monitor the procedurelog table as well as a few others, then c...
by mandmdiet
Mon Dec 04, 2023 3:07 pm
Forum: API
Topic: Open Dental Events API
Replies: 6
Views: 1935

Re: Open Dental Events API

Thank you for your response. Yes, we considered triggering that balance update whenever the patient table changes, but the patient table doesn't change as often as the patient's balance would change. For example with the creation of a procedure. When you create a procedure with an associated amount ...
by mandmdiet
Mon Dec 04, 2023 2:31 pm
Forum: API
Topic: Getting several documents for a patient at a time
Replies: 2
Views: 1453

Re: Getting several documents for a patient at a time

I am totally fine with looping through a list of documents from the GET API and pulling them one at a time, what I was concerned about is if the API traffic would be unacceptable to Open Dental. So, if you guys are OK with us looping through customers, grabbing their document meta data and then usin...
by mandmdiet
Mon Dec 04, 2023 12:35 pm
Forum: API
Topic: Getting several documents for a patient at a time
Replies: 2
Views: 1453

Getting several documents for a patient at a time

We have a use case where we want to perform some AI image processing on x-rays to create and attach additional metadata to an image. We have been looking at the API for pulling a patient's documents and have a few questions. Here is the API in question: Documents POST DownloadSftp (https://www.opend...
by mandmdiet
Mon Dec 04, 2023 12:29 pm
Forum: API
Topic: Open Dental Events API
Replies: 6
Views: 1935

Open Dental Events API

I've been reading about the Events API from this page: https://www.opendental.com/site/apievents.html. I'm not getting a clear picture, though, on what types of events we can subscribe to. For example, is there an event that would tell us when a patient's balance changes? One issue we're having is t...
by mandmdiet
Tue Nov 21, 2023 3:54 pm
Forum: API
Topic: API For Client Keys?
Replies: 4
Views: 1531

Re: API For Client Keys?

Yes we can do that. One issue I see with that is that if we generate several ahead of time and put it on a list to use later and then someone logs into the Open Dental Developer Portal, sees an unused key, and uses it, then later the key on the list doesn't work for a new office setup. Still, we can...
by mandmdiet
Tue Nov 21, 2023 3:26 pm
Forum: API
Topic: API For Client Keys?
Replies: 4
Views: 1531

Re: API For Client Keys?

Could you please elaborate on "so that our users don't have to log in to the developer portal"? Sure, we have an internal IT staff that will be on-boarding new offices to our software. To do this, they log into an admin portal for our software and enter some information about the new office. Things...
by mandmdiet
Tue Nov 21, 2023 3:04 pm
Forum: API
Topic: API For Client Keys?
Replies: 4
Views: 1531

API For Client Keys?

We're looking at doing further integration with the Open Dental API regarding client keys. Here are the two things we would like to do with this additional integration: Read Key Metadata Currently, if we want to know what version of Open Dental a user is on, we check the developer portal and look up...
by mandmdiet
Tue Oct 24, 2023 9:08 am
Forum: API
Topic: POST Query Timeout Issue
Replies: 6
Views: 2064

Re: POST Query Timeout Issue

Wow, that's great news. Thank you SLeon!
by mandmdiet
Thu Oct 12, 2023 12:59 pm
Forum: API
Topic: POST Query Timeout Issue
Replies: 6
Views: 2064

Re: POST Query Timeout Issue

Sure, that sounds like a good place to start. Also wondering if, since the Queries POST endpoint isn't returning anything to me directly, 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?
by mandmdiet
Thu Oct 12, 2023 7:59 am
Forum: API
Topic: POST Query Timeout Issue
Replies: 6
Views: 2064

POST Query Timeout Issue

Hi all, We have a need to export a large amount of claim data from Open Dental. To accomplish this, we're using the Queries POST API endpoint. One problem we're having, is that, although the query executes under the timeout of 60 seconds, the API holds on to the request until the file upload to the ...
by mandmdiet
Thu Aug 31, 2023 1:41 pm
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 2121

Re: Looking for ideas on eliminating data synchronization feedback loop

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

Re: Looking for ideas on eliminating data synchronization feedback loop

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

Re: Looking for ideas on eliminating data synchronization feedback loop

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

Re: Looking for ideas on eliminating data synchronization feedback loop

Oh, I didn't think to look at the version. You're probably right if that's a fairly recent release. Thanks for your help again.
by mandmdiet
Wed Aug 30, 2023 2:22 pm
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 2121

Re: Looking for ideas on eliminating data synchronization feedback loop

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

Re: Looking for ideas on eliminating data synchronization feedback loop

Thank you for the thoughtful response. I wasn't aware of API Service before so I will look at that and I will also look at the securitylogs, depending on what data is available there they could be just what we need!
by mandmdiet
Wed Aug 30, 2023 8:59 am
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 2121

Looking for ideas on eliminating data synchronization feedback loop

I'm a developer working on an Open Dental integration. Two of the things our application does with the Open Dental API are: 1. Imports notes for a claim for viewing. and 2. Allows a user to create a new note. When a new note is created in OD for a claim our users are working to send, we import that ...
by mandmdiet
Thu Jul 20, 2023 9:47 am
Forum: Main Forum
Topic: Is it safe to always trust the aging data in the patient table?
Replies: 9
Views: 3876

Re: Is it safe to always trust the aging data in the patient table?

How did you perform step #2 and step #4? For step #2 I was on the patient chart and clicked on Procedure List, chose a procedure and clicked OK at the bottom. For Step #4 I was again on the patient chart and double-clicked the procedure in the grid that was created by step #2 and picked "Complete" ...
by mandmdiet
Wed Jul 19, 2023 1:13 pm
Forum: Main Forum
Topic: Is it safe to always trust the aging data in the patient table?
Replies: 9
Views: 3876

Re: Is it safe to always trust the aging data in the patient table?

Good afternoon gentlemen, I did some testing today to check a scenario that I was concerned about and found that the aging balance wasn't being updated in at least one common case. Here are the steps I took below in case you're interested. Checked the current balance for the patient in the patient t...
by mandmdiet
Wed Jul 19, 2023 10:36 am
Forum: API
Topic: New API Request
Replies: 16
Views: 5345

Re: New API Request

Thanks for the response DerekR.
by mandmdiet
Tue Jul 18, 2023 9:06 am
Forum: API
Topic: New API Request
Replies: 16
Views: 5345

Re: New API Request

Thanks for the update DerekR. Is there any news on the progress of the other feature requests?
by mandmdiet
Mon Jul 10, 2023 9:23 am
Forum: Main Forum
Topic: Is it safe to always trust the aging data in the patient table?
Replies: 9
Views: 3876

Re: Is it safe to always trust the aging data in the patient table?

We also need it to be accurate in order to display it, so I'm leaning toward thinking you can always trust it. That linked documentation says that it is recalculated just before the area in Open Dental where you display it is loaded, so that sounded like it wasn't being relied on to be correct and ...
by mandmdiet
Tue Jun 27, 2023 7:48 am
Forum: Advanced Topics
Topic: Is it safe to always trust the aging data in the patient table?
Replies: 1
Views: 2148

Is it safe to always trust the aging data in the patient table?

We have a requirement to display the current aging data for a patient to a user in a different window. We know we can get that aging data from the patient table, but from reading this documentation, it sounds like the aging data my not be updated every time something materially changes with the pati...
by mandmdiet
Wed May 24, 2023 12:49 pm
Forum: Advanced Topics
Topic: Two Instances of OD on Same Machine?
Replies: 0
Views: 4636

Two Instances of OD on Same Machine?

Is it possible to run two copies of Open Dental on the same machine? For our test environment we need to be able to test an instance of OD that has clinics enabled and one that does not. We currently run OD on an EC2 instance but would rather not bear the cost of running another EC2 instance if we c...
by mandmdiet
Tue May 02, 2023 2:57 pm
Forum: API
Topic: Quick API Question
Replies: 2
Views: 3116

Re: Quick API Question

SLeon, we can page with ShortQuery but some of our clients have very large databases and some of the tables could cause us to have to page dozens of times. Technically feasible and not an issue on our end but we wouldn't want to overwhelm the customer instance of Open Dental and we also have to plan...
by mandmdiet
Tue May 02, 2023 2:22 pm
Forum: API
Topic: Quick API Question
Replies: 2
Views: 3116

Quick API Question

For doing reads from Open Dental, we've been primarily using Queries PUT ShortQuery but we recently came across a use case where we will need a large amount of records from Open Dental and paging 100 records at a time would not be a workable solution. Given that, we were looking at implementing an S...
by mandmdiet
Tue May 02, 2023 9:02 am
Forum: API
Topic: API Request
Replies: 3
Views: 3312

Re: API Request

We appreciate it DerekR!
by mandmdiet
Thu Apr 27, 2023 7:16 am
Forum: API
Topic: API Request
Replies: 3
Views: 3312

API Request

Use Case A claim is imported into our software to be prepared for submission to the carrier A user of our software determines that one or more procedures on the claim should not be billed to the insurance The user removes the procedure from the claim in our application Our application uses the Open...
by mandmdiet
Mon Apr 24, 2023 2:16 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

Thanks SLeon, we definitely will experiment as well and I apologize for asking a question that may seem like it could be answered that way, I just felt like the Clinics functionality may be complex enough that we might miss something if we didn't also run questions passed you on this.
by mandmdiet
Mon Apr 17, 2023 1:36 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

OK, thank you so much. A few more simple questions then based on the documentation I found and what you've said. Can a claim have procedures from more than one patient? Can a claim have procedures from more than one clinic? I think the answer to both of these is no, but I find myself wanting to be e...
by mandmdiet
Mon Apr 17, 2023 10:21 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

Procedures are displayed in the main Account Module grid for the patient. These are the only procedures that can be selected to be added to a claim. This is true whether they were performed in ClinicA or ClinicB. The clinic that is selected in Open Dental does not affect the procedures in this list...
by mandmdiet
Wed Apr 12, 2023 1:21 pm
Forum: API
Topic: Supporting Clinics as a Third Party Software Provider
Replies: 7
Views: 4246

Supporting Clinics as a Third Party Software Provider

We have an application that we have been using in a few offices for the past 5 or 6 months. However, we have only integrated with offices that are not currently using Clinics. We now have a requirement to integrate our software with a new client that has several clinics and we're not sure exactly ho...
by mandmdiet
Mon Apr 10, 2023 6:03 am
Forum: API
Topic: New API Request
Replies: 16
Views: 5345

Re: New API Request

Awesome SLeon, thank you very much.
by mandmdiet
Tue Apr 04, 2023 10:15 am
Forum: API
Topic: New API Request
Replies: 16
Views: 5345

Re: New API Request

I have added Claims POST to our development list. This will allow you to create a claim (Primary, Secondary, etc.) for a patient with a list of specified procedures. We will implement this in such a way that the transaction model you describe is not necessary. Thanks SLeon and thank you, again, for...
by mandmdiet
Wed Mar 29, 2023 11:53 am
Forum: API
Topic: New API Request
Replies: 16
Views: 5345

New API Request

Use Case We import a claim ready to be sent to the carrier into our software. A user determines that one or more of the procedures on the claim need to be edited. The user indicates which fields on the procedure they would like to change. We use the Open Dental API to update the procedure. Request ...
by mandmdiet
Thu Feb 23, 2023 2:37 pm
Forum: API
Topic: Urgent API Issue
Replies: 3
Views: 1521

Re: Urgent API Issue

Thanks, all other clients are using our software without issue. This office is on version 22.2.55. They have used it successfully for weeks, regularly without issue until yesterday evening.

I will respond to your private message separately.

Thanks!
by mandmdiet
Thu Feb 23, 2023 2:09 pm
Forum: API
Topic: Urgent API Issue
Replies: 3
Views: 1521

Urgent API Issue

One of the offices using our software appears to be having an API outage. We're getting this error even just doing a basic ShortQuery request that was working fine yesterday. REQUEST PUT /api/v1/queries/ShortQuery HTTP/1.1 Authorization: ************************ Content-Type: application/json User-A...
by mandmdiet
Thu Jan 26, 2023 9:37 am
Forum: API
Topic: Deleting old API keys
Replies: 5
Views: 1584

Re: Deleting old API keys

Wow, that's great. Thanks SLeon.
by mandmdiet
Thu Jan 26, 2023 8:42 am
Forum: Advanced Topics
Topic: Excluding new claims created before Edit Claim form is dismissed
Replies: 0
Views: 4744

Excluding new claims created before Edit Claim form is dismissed

When the New Claim button is clicked, the claim is created immediately and the Edit Claim window appears. However, if the user clicks Cancel on the Edit Claim window, the claim is deleted. I'm trying to figure out a way I can ignore that new claim until the user has clicked the OK button on the Edit...
by mandmdiet
Tue Dec 20, 2022 9:06 am
Forum: API
Topic: Questions about API throttling and performance
Replies: 1
Views: 971

Questions about API throttling and performance

I'm looking for your help with some things on our mind about the future of our application and the interaction with the Open Dental API. We have a new application that makes use of the API that is currently in beta. During our testing there have been a few times where we have gotten timeouts when us...
by mandmdiet
Mon Nov 21, 2022 8:49 am
Forum: API
Topic: Deleting old API keys
Replies: 5
Views: 1584

Re: Deleting old API keys

We have about 2 dozen keys right now, but only 4 active. If the other 20 stopped showing up that would definitely help. The problem we are having now is that so many of these keys were created when we weren't even trying to create a key. It would still bug me that we had these disabled keys probably...
by mandmdiet
Mon Nov 21, 2022 7:27 am
Forum: API
Topic: Deleting old API keys
Replies: 5
Views: 1584

Deleting old API keys

Hello, We are finding it hard to manage our API keys because we accidentally created several keys that we associated with a test instance of Open Dental. We don't want to reuse these keys for our clients because we're worried that we might still have it associated to some other instance somewhere. I...
by mandmdiet
Thu Jul 14, 2022 3:26 pm
Forum: Advanced Topics
Topic: Creating tables and triggers in the Open Dental database
Replies: 4
Views: 4704

Re: Creating tables and triggers in the Open Dental database

Sounds good.

Thanks so much SLeon and adearmondsattler.
by mandmdiet
Wed Jul 13, 2022 2:20 pm
Forum: Advanced Topics
Topic: Creating tables and triggers in the Open Dental database
Replies: 4
Views: 4704

Re: Creating tables and triggers in the Open Dental database

Open Dental does not support third parties manipulating customers' databases. From the Plugins page you linked in your post: Plug-ins and raw external queries should never be used to insert information into the database. This includes triggers and the addition of new tables into the database. Devel...
by mandmdiet
Thu Jul 07, 2022 10:11 am
Forum: Advanced Topics
Topic: Creating tables and triggers in the Open Dental database
Replies: 4
Views: 4704

Creating tables and triggers in the Open Dental database

Where does Open Dental stand on 3rd parties adding tables and triggers in the Open Dental database? I have read in the documentation somewhere that it is no problem. Is that still the case?

https://opendental.com/manual/plugins.html
by mandmdiet
Thu Jun 30, 2022 3:50 pm
Forum: API
Topic: eConnector Services starts failing making several requests close together
Replies: 7
Views: 3046

Re: eConnector Services starts failing making several requests close together

Oh, that's wonderful. Then the throttling you're referring to is meant to protect the eConnector from being overwhelmed with requests? If that is the case then we don't have any concerns actually because we can effectively hand off all of our traffic to the Open Dental API and no matter the frequenc...
by mandmdiet
Wed Jun 29, 2022 3:39 pm
Forum: API
Topic: eConnector Services starts failing making several requests close together
Replies: 7
Views: 3046

Re: eConnector Services starts failing making several requests close together

I am concerned about overwhelming an Open Dental eConnector machine. In some cases the machine hardware might be old and there might not be a lot of available resources. In other cases they may have poor internet bandwidth or a cheap router. With the throttle rate you're talking about in your last p...
by mandmdiet
Thu Jun 02, 2022 9:34 am
Forum: API
Topic: eConnector Services starts failing making several requests close together
Replies: 7
Views: 3046

Re: eConnector Services starts failing making several requests close together

The API has been carefully designed to scale and handle an extremely high volume of traffic. At the dental office level, the eConnector is the only theoretical limitation on throughput. That being said, the eConnector is designed to handle such a high level of traffic that customers should never be...
by mandmdiet
Wed Jun 01, 2022 4:00 pm
Forum: API
Topic: eConnector Services starts failing making several requests close together
Replies: 7
Views: 3046

eConnector Services starts failing making several requests close together

Just wanted to make a quick inquiry about an issue we encountered in the eConnector Service where it started failing. Each request would return either a 400 Bad Request or a 504 Gateway Timeout. This occurred on a test box while we were doing new development. The machine didn't appear to be taxed on...
by mandmdiet
Wed Apr 27, 2022 9:11 am
Forum: Main Forum
Topic: Position (Marital Status) Has "Child" Option?
Replies: 1
Views: 1473

Position (Marital Status) Has "Child" Option?

We're looking through the Open Dental documentation to figure out how to know the marital status of a patient and it looks like the Position field in the database is where this value is kept. However, among the options for marital status is the option of "Child". Is this another way, along with "Sin...
by mandmdiet
Tue Apr 26, 2022 3:27 pm
Forum: Main Forum
Topic: Question About Clinic Pay To Address and Billing Address
Replies: 2
Views: 1718

Re: Question About Clinic Pay To Address and Billing Address

OK, this is probably enough. Thank you joes.
by mandmdiet
Mon Apr 25, 2022 11:41 am
Forum: Main Forum
Topic: Question About Clinic Pay To Address and Billing Address
Replies: 2
Views: 1718

Question About Clinic Pay To Address and Billing Address

In the documentation on this page: https://www.opendental.com/manual/cliniceditwindow.html it states: Pay To Address : Enter the address where insurance payments will go if different than the physical treating address. This can be a PO Box. It will be used as the billing address on claims. If the bi...
by mandmdiet
Thu Apr 14, 2022 2:24 pm
Forum: API
Topic: New API Request
Replies: 6
Views: 3082

Re: New API Request

Hurray! and Thank you.
by mandmdiet
Tue Apr 12, 2022 3:47 pm
Forum: API
Topic: Customer API key return data issue
Replies: 11
Views: 4468

Re: Customer API key return data issue

Subsequently installed eConnectors fail silently and preserve the connection of the original, valid eConnector. This is helpful in many cases, for example, if another workstation at the dental office accidentally tries to install a second eConnector. This erroneous eConnector does not disrupt the e...
by mandmdiet
Mon Apr 11, 2022 3:58 pm
Forum: API
Topic: Customer API key return data issue
Replies: 11
Views: 4468

Re: Customer API key return data issue

I understand your concern. Multiple offices using a single registration key should never happen in production. Each Open Dental customer must use a unique registration key and should not be shared with other customers. Many issues will arise if one dental office is trying to use another office's th...
by mandmdiet
Mon Apr 11, 2022 8:59 am
Forum: API
Topic: Customer API key return data issue
Replies: 11
Views: 4468

Re: Customer API key return data issue

You can send an email to vendor.relations at opendental.com, and they can get you set up. Thanks SLeon we were talking today about a possibility of this happening in production and wanted to get your take on it. If two separate offices somehow have the same installation key and we try to connect on...
by mandmdiet
Thu Apr 07, 2022 4:34 pm
Forum: API
Topic: Customer API key return data issue
Replies: 11
Views: 4468

Re: Customer API key return data issue

I understand that you have three different environments, machines, and databases, but it sounds like you are only using one registration key, correct? A registration key and eConnector share a one to one relationship. To use three different databases, each would need it's own registration key, eCon...
by mandmdiet
Thu Apr 07, 2022 4:33 pm
Forum: API
Topic: New API Request
Replies: 6
Views: 3082

Re: New API Request

Thank you so much!
by mandmdiet
Thu Apr 07, 2022 10:49 am
Forum: API
Topic: Customer API key return data issue
Replies: 11
Views: 4468

Re: Customer API key return data issue

The API utilizes the dental office's eConnector to validate developer API, customer API, and registration keys with Open Dental. Do you have an eConnector installed and running on each machine? At the time of eConnector installation, you choose which database to pair it with. An eConnector is speci...
by mandmdiet
Wed Mar 30, 2022 2:02 pm
Forum: API
Topic: New API Request
Replies: 9
Views: 4245

Re: New API Request

Thank you so much guys!
by mandmdiet
Mon Mar 21, 2022 9:40 am
Forum: API
Topic: New API Request
Replies: 6
Views: 3082

Re: New API Request

Thank you SLeon!
by mandmdiet
Wed Mar 16, 2022 9:31 am
Forum: API
Topic: New API Request
Replies: 6
Views: 3082

New API Request

Hello again friends, We would like to request a few new features in the Open Dental API. Hopefully these are small things for your team to tackle. Below are the details: New API Request - Update Claim Date of Accident We have a requirement in our application to be able to update the AccidentDate fie...
by mandmdiet
Mon Mar 14, 2022 8:47 am
Forum: API
Topic: New API Request
Replies: 9
Views: 4245

Re: New API Request

Wow, you guys are fast, thank you so much.
by mandmdiet
Mon Mar 14, 2022 7:07 am
Forum: API
Topic: New API Request
Replies: 9
Views: 4245

Re: New API Request

SLeon wrote:
Tue Feb 01, 2022 2:07 pm
We will add a new method to split claims via the API. It has been added to our development list and we will start implementing it fairly shortly.
Hello SLeon, is there any update on this request?

Thank you
by mandmdiet
Tue Feb 01, 2022 2:42 pm
Forum: API
Topic: New API Request
Replies: 9
Views: 4245

Re: New API Request

SLeon wrote:
Tue Feb 01, 2022 2:07 pm
We will add a new method to split claims via the API. It has been added to our development list and we will start implementing it fairly shortly.
Thank you SLeon, we appreciate it and will watch for updates.
by mandmdiet
Mon Jan 31, 2022 12:15 pm
Forum: API
Topic: New API Request
Replies: 9
Views: 4245

Re: New API Request

SLeon wrote:
Mon Jan 31, 2022 12:08 pm
Thank you for the intended use case and for this method. It is very helpful in the implementation process. We will discuss claim splitting at our next API meeting and update this thread by tomorrow.
Thank you SLeon!
by mandmdiet
Mon Jan 31, 2022 8:50 am
Forum: API
Topic: New API Request
Replies: 9
Views: 4245

New API Request

Hello friends We would like to request that a new API be created to enable us to split a claim the way the application does when a user clicks Split Claim in the Edit Claim window. Below are the details: Use Case We have a requirement in our application to be able to split a claim via an API call. T...
by mandmdiet
Mon Dec 06, 2021 2:48 pm
Forum: API
Topic: New APIs Needed
Replies: 11
Views: 6019

Re: New APIs Needed

Thanks so much Jordan. We have a few more we expect to make in the coming weeks and months as well. We appreciate you and your team being so quick and willing to help.
by mandmdiet
Wed Dec 01, 2021 12:14 pm
Forum: API
Topic: New APIs Needed
Replies: 11
Views: 6019

New APIs Needed

Hello friends, we've been slowly working through our application requirements to determine our API needs and we have some new formal requests we would like to make for the Open Dental API. Request 1: Update Patient Use Case We have a requirement in our application to be able to update patients via a...
by mandmdiet
Thu Oct 07, 2021 3:29 pm
Forum: API
Topic: API Request: Updating a Claim
Replies: 10
Views: 7995

Re: API Request: Updating a Claim

OK, perfect, thanks SLeon.
by mandmdiet
Thu Oct 07, 2021 9:45 am
Forum: API
Topic: API Request: Updating a Claim
Replies: 10
Views: 7995

Re: API Request: Updating a Claim

OK, great, so they only have to update the eConnector and not do any updates to other Open Dental software? As to your last question, 21.3 will be the beta version until 21.4 is released. At which time 21.4 will become the new beta version. Did you mean to say 21.3 is the beta until 21.3 is released...
by mandmdiet
Wed Oct 06, 2021 1:05 pm
Forum: API
Topic: API Request: Updating a Claim
Replies: 10
Views: 7995

Re: API Request: Updating a Claim

Thank you SLeon, that was very fast! This isn't mentioned in your documentation for the Claims PUT Status, but does the endpoint handle the Etrans status as we discussed earlier? Also, how do we make sure we can use this on our client's systems in the wild? I assume we will need to learn which relea...
by mandmdiet
Tue Sep 28, 2021 12:31 pm
Forum: API
Topic: API Request: Updating a Claim
Replies: 10
Views: 7995

Re: API Request: Updating a Claim

That's wonderful! Thanks SLeon.
by mandmdiet
Mon Sep 27, 2021 9:44 am
Forum: API
Topic: API Request: Updating a Claim
Replies: 10
Views: 7995

API Request: Updating a Claim

We would like to make a formal request for an endpoint to be made in the Open Dental API for purposes of performing a write operation. Use Case We have a requirement in our application to be able to mark a claim as sent via an API call. The workflow would look like this: New Claim Created We find an...
by mandmdiet
Tue Sep 21, 2021 7:58 am
Forum: Developers
Topic: API Guidance
Replies: 10
Views: 8280

Re: API Guidance

OK, awesome, and for the plugins, again, no changing of the database data either directly or indirectly through libraries / classes that exist in Open Dental itself, right?

Will the plugin framework continue to be supported for those who just want to use it for read access?
by mandmdiet
Mon Sep 20, 2021 4:57 pm
Forum: Developers
Topic: API Guidance
Replies: 10
Views: 8280

Re: API Guidance

When you say "make changes to the database" are you just talking about UPDATE and INSERT commands or are you also talking about schema changes like creating new tables?
by mandmdiet
Fri Sep 17, 2021 12:34 pm
Forum: Developers
Topic: API Guidance
Replies: 10
Views: 8280

Re: API Guidance

OK, that makes sense to me and I have read that article you linked a couple of times, but I don't remember it saying that the plugin framework is being removed. To be clear though, that is what is happening, right? They will no longer be supported and existing plugins are going to be blocked, requir...
by mandmdiet
Fri Sep 17, 2021 6:39 am
Forum: Developers
Topic: API Guidance
Replies: 10
Views: 8280

Re: API Guidance

OK, that's good to know. And to be clear, they didn't say they were using a plugin from, for instance, a console application, only that they were able to access the database through objects within Open Dental. I assume that's normal when you're writing a plugin, right? If what I'm asking about sound...
by mandmdiet
Thu Sep 16, 2021 1:18 pm
Forum: Developers
Topic: API Guidance
Replies: 10
Views: 8280

API Guidance

I know there are a lot of available API options for Open Dental and I've done my best to find the documentation talking about all of these, but I am still missing some pieces and would like some clarification. Read Access Options Plugin Direct Database Connection Open Dental API Read / Write Access ...
by mandmdiet
Fri Sep 03, 2021 9:03 am
Forum: Developers
Topic: ShortQuery
Replies: 5
Views: 6415

Re: ShortQuery

We did have to grant @localhost read access as well to get the API to work for ShortQuery. Is this something that you think is being changed JordanSparks? We need to include it in our evaluation of which integration options to use with Open Dental if we need to set this configuration on all of the o...
by mandmdiet
Fri Aug 27, 2021 12:10 pm
Forum: Developers
Topic: Developer Portal Access
Replies: 22
Views: 17936

Re: Developer Portal Access

OK, I understand now I think, thank you joes.
by mandmdiet
Thu Aug 26, 2021 3:27 pm
Forum: Developers
Topic: Developer Portal Access
Replies: 22
Views: 17936

Re: Developer Portal Access

OK thank you joes, I do remember reading this documentation in the past and we have received a key from vendor.relations@opendental.com, so that sounds like we have a Developer API Key . I'm getting a bit turned around when talking about all of the keys, so I'm going to attempt to color code them as...
by mandmdiet
Wed Aug 25, 2021 8:33 pm
Forum: Developers
Topic: Developer Portal Access
Replies: 22
Views: 17936

Re: Developer Portal Access

I've just been informed by our developer that we have the Developer License Key but we also need the Developer API Key, which is apparently behind the Open Dental Developer Portal. So it looks like we *do* need access. Can I be pointed in the direction I need to go to get access to that? I haven't b...
by mandmdiet
Wed Aug 25, 2021 12:01 pm
Forum: Developers
Topic: Developer Portal Access
Replies: 22
Views: 17936

Developer Portal Access

I'm trying to figure out what I need access to in order to fully take advantage of the resources provided by Open Dental in regards to the Open Dental API. This document: https://www.opendental.com/manual/fhir.html talks about two separate APIs, one that is new and one that is old (FHIR). It sounds ...
by mandmdiet
Wed Aug 18, 2021 6:28 am
Forum: Developers
Topic: Is it possible to change data in Open Dental without port forwarding?
Replies: 3
Views: 4777

Re: Is it possible to change data in Open Dental without port forwarding?

Oh, thanks Jordan, I read in the OD documentation that you had to port forward to get the API to work, if no port forwarding is needed then we have no issues! Incidentally, this is where the documentation says that port forwarding for the eConnector is a requirement. https://www.opendental.com/manua...
by mandmdiet
Tue Aug 17, 2021 3:51 pm
Forum: Developers
Topic: Is it possible to change data in Open Dental without port forwarding?
Replies: 3
Views: 4777

Is it possible to change data in Open Dental without port forwarding?

We’re building a set of tools to help better support our clients, all of whom are dental practices. Some of the functionality in our tools will augment functionality they get in their Open Dental system. This set of tools includes an application running on the client machine itself as well as applic...