Open Dental Forum

mandmdiet

It is very likely we'd find this feature useful even with those limitations but we don't want to make the request unless we're sure of that. We'll come back here and request this feature if it is decided that we would use it as described.

Thank you SLeon!

mandmdiet

Hello SLeon, were you and your team able to look into this more?

mandmdiet

OK, thank you we really appreciate it SLeon.

mandmdiet

Just bringing awareness back to this question:

Would it be possible for us to have an API that allows us to upload an ERA into Open Dental directly?

mandmdiet

Actually, I've made an error in my wording in portions of this post. We started off talking about ERAs and I accidentally started using the acronym EOB. I apologize for that. As chance would have it, yes we are planning on using that EOB functionality as well and are looking forward to that change. ...

mandmdiet

OK, yeah, thanks jsalmon, The functionality we're after is getting EOBs into Open Dental as seamlessly as possible having to do the least amount of install work and updating on the office machine as possible. Something like an API endpoint that accepts EOBs would probably be our simplest option actu...

mandmdiet

We won't have a way to automatically put files in the report directory and so that would have to be done manually for each office and we have hundreds of offices. Our software, however, can make these EOBs available securely so that they can be accessed via a service endpoint. I understand, maybe in...

mandmdiet

Hello, We have a need to add some functionality to Open Dental that would allow us to automatically pull ERAs from our backend services into Open Dental. We haven't ever written any custom functionality that augments Open Dental and were wondering what is the current recommended way of doing somethi...

mandmdiet

This is an easy one I think but I couldn't find the information somewhere already. Developer API keys and customer API keys are paired, correct? So customer API keys that *we* create can only be used by someone with our developer API key?

Thanks

mandmdiet

One other general question for you. I'm not a MySQL expert so there are some things that are new to me, however with other database engines that I know well, like MS SQL, they have tools for shrinking or optimizing table space that, unless you run them regularly, can cause the database to slow down ...

mandmdiet

SLeon, We haven't worked on this issue again since my last message but I was just about to look at the things you have brought up. Does the office experience slowness with any eServices (eConnector reliant products)? What other eConnector reliant products could we check for this? I'm not familiar wi...

mandmdiet

SLeon,

Incidentally, for Antivirus, they are using Trend Micro and they are also using something called PRTG for network monitoring.

mandmdiet

Thanks SLeon, this is very helpful and we we will look into these. I'll keep checking back here for any additional thoughts you may have and if we need further help we will contact Open Dental support. Here are the answers to your questions: 1. This is a new customer 2. N/A 3. I don't know much abou...

mandmdiet

We're trying to troubleshoot a problem that we recently ran into with one of our clients but are having a hard time getting a good picture of what's happening and are hoping someone on this forum can help us know the best place to look to start troubleshooting. The issue we're having is that for one...

mandmdiet

OK, awesome, thank you SLeon.

mandmdiet

We are looking for an API for submitting a claim that, when we call it, uses Open Dental's currently configured clearinghouse to submit the claim to that clearinghouse in its current state. Is there an API that does that now? I've looked through the claims API but there wasn't any mention of such an...

mandmdiet

Thank you for the reply, I'll put my comments inline below. Early in the thread we discussed and agreed that large queries should be either 1) batched, or 2) replaced a lazy-loaded cache (leveraging Claims GET single/multiple). The rest of this discussion is either speculative or informational, whic...

mandmdiet

Just posting to see if we can reach some sort of conclusion on this one. I'm hoping my last two messages would serve to clear up some previous miscommunications. I'm really just trying to understand if the timeout bottleneck is in one of the yellow objects in my diagram above.

mandmdiet

I think this diagram represents the flow of data and all of the things that could be causing the speed issues. The items in green have been eliminated as possible problems. The items in yellow show places we can't rule out as causes of the problem. Is this missing something or do you find something ...

mandmdiet

Thanks SLeon Unfortunately it looks like there's still some miscommunication occurring. The request size (not response size) is 178 KB. I am not receiving an error saying "Result exceeds maximum content length" I am getting a "504 Gateway Time-out". At the end of my last message I did not posit that...

mandmdiet

Thanks for the response SLeon, First let me clear up a misunderstanding. When I say the result of the query is small, I mean, we know what the result is because we can use MySQL Workbench to run the query. In MySQL workbench it takes .047 seconds and the result is 139 bytes so that's the same amount...

mandmdiet

Hi SLeon, here's some more information for you: Query execution time when run through MySQL Workbench: 0.047 seconds Query execution time when run through Open Dental API: > 60 seconds, timeout Payload size sent to the Open Dental API: 178 KB Query response size: 139 Bytes Given the nature of the qu...

mandmdiet

Yeah, that's the strange thing about the 504 for us. If we run the query directly against the database it returns in milliseconds, so a 60 second timeout seems like an issue unrelated to our query. I will ask my developer to give me how long he waits before he receives the 504 and how long it takes ...

mandmdiet

We have a dilemma we're trying to solve with the API. We list unsent and sent claims in a grid in our application for our users. Once a claim has reached a received status, we stop listing it. If a claim gets deleted, though, we want to stop showing the claim in the list. For some of our clients, th...

mandmdiet

Thank you for the reply SLeon, I put my answers inline below. Do you get this every time you use an SFTP API method for this office, or only some of the time? It is only some of the time. Depending on the Sftp site, you might be able to look at logs to see if the dental office in question attempted ...

mandmdiet

Do you get this every time you use an SFTP API method for this office, or only some of the time? It is only some of the time. Depending on the Sftp site, you might be able to look at logs to see if the dental office in question attempted to connect. This might narrow where the error is occurring. W...

mandmdiet

Hello Friends, We have an application that we're rolling out to a few hundred Open Dental practices. We recently rolled out to a practice where we routinely get an error from Open Dental when attempting to use the POST query API. The error is about connecting to our SFTP server. The error is only oc...

mandmdiet

Thanks justine

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

This is great, we really appreciate this DerekR!

mandmdiet

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

mandmdiet

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

mandmdiet

Great! Thank you!

mandmdiet

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

mandmdiet

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

mandmdiet

OK, Thank you again justine.

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

Thanks again jsalmon.

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

Wow, that's great news. Thank you SLeon!

mandmdiet

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?

mandmdiet

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

mandmdiet

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?

mandmdiet

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

mandmdiet

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

mandmdiet

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.

mandmdiet

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

mandmdiet

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!

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

Thanks for the response DerekR.

mandmdiet

Thanks for the update DerekR. Is there any news on the progress of the other feature requests?

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

We appreciate it DerekR!

mandmdiet

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

mandmdiet

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.

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

Awesome SLeon, thank you very much.

mandmdiet

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

mandmdiet

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

mandmdiet

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!

mandmdiet

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

mandmdiet

Wow, that's great. Thanks SLeon.

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

Sounds good.

Thanks so much SLeon and adearmondsattler.

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

OK, this is probably enough. Thank you joes.

mandmdiet

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

mandmdiet

Hurray! and Thank you.

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

Thank you so much!

mandmdiet

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

mandmdiet

Thank you so much guys!

mandmdiet

Thank you SLeon!

mandmdiet

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

mandmdiet

Wow, you guys are fast, thank you so much.

mandmdiet

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

mandmdiet

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.

mandmdiet

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!

mandmdiet

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

mandmdiet

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.

mandmdiet

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

mandmdiet

OK, perfect, thanks SLeon.

mandmdiet

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

mandmdiet

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

mandmdiet

That's wonderful! Thanks SLeon.

mandmdiet

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

mandmdiet

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?

mandmdiet

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?

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

OK, I understand now I think, thank you joes.

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

mandmdiet

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

Search found 140 matches