Search found 168 matches

by justine
Thu Mar 21, 2024 9:20 am
Forum: API
Topic: Name and version don't match
Replies: 1
Views: 83

Re: Name and version don't match

A client added in the API key, but when I go into my portal, the name and version doesn't match. The key is correct so I'm scratching my head as to what is happening and whether I should be concerned. The practice name on my portal shows as Relaxation Dental and the version as 23.1.36.0. The client...
by justine
Wed Mar 20, 2024 10:00 am
Forum: API
Topic: Need help for Benefits PUT API
Replies: 1
Views: 82

Re: Need help for Benefits PUT API

Hi Team, Suppose there's a wrongly entered benefit with a limitation of "3 times per benefit year" for a specific frequency under an insurance plan, and if I want to update it to "Every 3 Years" using benefit PUT API, how to do it? I tried it using the benefit PUT API, and provided below request ob...
by justine
Wed Mar 20, 2024 9:44 am
Forum: API
Topic: Database connection issue
Replies: 1
Views: 68

Re: Database connection issue

Hi Team, Today, while submitting an SQL query in the PUT API of open dental, it returned the below response message with an HTTP status code of 400, ""Error submitting query. Unable to connect to any of the specified MySQL hosts."" Please help me understand the issue & how I can prevent this from h...
by justine
Mon Mar 18, 2024 10:29 am
Forum: API
Topic: Custom logtext for audit trails
Replies: 1
Views: 64

Re: Custom logtext for audit trails

beacondental wrote:
Mon Mar 18, 2024 9:59 am
Hi Team,

Is there a possibility of setting a custom logtext for the API audit trails? if possible can you please provide some reference for the same?
Good morning beacondental,

No, it is not possible to change the logtext on Audit Trails within Open Dental or via the API.

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

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 justine
Mon Mar 18, 2024 9:19 am
Forum: API
Topic: Request webhook for blockout slots
Replies: 7
Views: 469

Re: Request webhook for blockout slots

Smilelink wrote:
Sun Mar 17, 2024 5:40 am
Hi Justine,

we should have a runner to get update on this, I meant a webhook which send the updates to our endpoint
Good morning Smilelink,

We can add the ability to create schedule subscriptions.

We will reply to this thread once the request is complete.

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

Re: API Availability Check?

Thanks justine, How do those public demo credentials work? What request should we send to the API using those credentials? This won't give us a valid indication as to whether we'd be successful using the API normally would it? Since something could be wrong related to our generated customer key? Fo...
by justine
Fri Mar 15, 2024 2:51 pm
Forum: API
Topic: Updated the Claim.CustomTracking column after ClaimTrackings POST API completed
Replies: 1
Views: 84

Re: Updated the Claim.CustomTracking column after ClaimTrackings POST API completed

Hi, Through the open dental application Once we create the claimtracking note through UI, System updating the claim.customtracking column with latest note from definition claimtracking.trackingdefnum (i.e. definition -> defnum) to respective claim. Through ClaimTracking POST Api Once we create the ...
by justine
Thu Mar 14, 2024 4:44 pm
Forum: API
Topic: API Availability Check?
Replies: 6
Views: 160

Re: API Availability Check?

We would like to be able to keep our users informed of the current connectivity status of our application to the Open Dental API. For example, if someone removes the customer API key from Open Dental or just hasn't added it yet or if something is down on the PMS machine or even if the Open Dental A...
by justine
Wed Mar 13, 2024 1:49 pm
Forum: API
Topic: Generating keys via API
Replies: 2
Views: 95

Re: Generating keys via API

Let me know if I'm overlooking this somewhere, but I would love to be able to generate new keys via the API so I can simplify the process of onboarding my clients. Good afternoon saskia, The Developer Portal is secure, requiring a username and password. We would have to add this entirely new layer ...
by justine
Tue Mar 12, 2024 2:46 pm
Forum: API
Topic: Request webhook for blockout slots
Replies: 7
Views: 469

Re: Request webhook for blockout slots

Hello, Is there anyway we can know if a block slot has been added or deleted without calling the Schedule API at a specific time? Hello Smilelink, You can use the Schedules GET endpoint without a date parameter, but it is not recommended. You should also use the SchedType parameter, and use the Blo...
by justine
Tue Mar 05, 2024 7:34 am
Forum: API
Topic: ECONNRESET when attempting PUT ShortQuery with Offset
Replies: 4
Views: 208

Re: ECONNRESET when attempting PUT ShortQuery with Offset

Good morning graham_mueller,

I apologize for the timeout misunderstanding. I'm glad you found a solution and shared it on the forums.

Thanks!
by justine
Mon Mar 04, 2024 2:51 pm
Forum: API
Topic: ECONNRESET when attempting PUT ShortQuery with Offset
Replies: 4
Views: 208

Re: ECONNRESET when attempting PUT ShortQuery with Offset

I started to try to loop through result sets today, because one query is getting a set of appointments with length > 100. When I make a second request with Offset=100, the OD API server seems to be killing my connection each time. I'm hitting [PUT] https://api.opendental.com/api/v1/queries/ShortQue...
by justine
Tue Feb 27, 2024 5:50 pm
Forum: API
Topic: Adjustment API
Replies: 3
Views: 204

Re: Adjustment API

jasoncartercs wrote:
Tue Feb 27, 2024 5:30 pm
My question was not clear. The secUserNumEntry is not a part of the Adjustment endpoint. Is there a way to add it?
Ahh, I understand. I have added returning secUserNumEntry to the adjustments GET response to the API development list.

Thanks!
by justine
Tue Feb 27, 2024 5:17 pm
Forum: API
Topic: Request webhook for blockout slots
Replies: 7
Views: 469

Re: Request webhook for blockout slots

Thanks for the reply, is there any estimate on when can we expect it ? Also can we get a event hook for Patient delete blockslot Update o delete provider Update o delete operatory Update o delete We will reply to this thread once the request is complete. A patient will have a patientStatus of 'Dele...
by justine
Tue Feb 27, 2024 5:09 pm
Forum: API
Topic: Adjustment API
Replies: 3
Views: 204

Re: Adjustment API

jasoncartercs wrote:
Tue Feb 27, 2024 1:02 pm
Is it possible to add the user who enters the adjustment as a property in the API?

This would be useful for any kind of adjustment or payment on an account.
We do not allow setting secUserNumEntry via the API. secUserNumEntry will always be 0 when an endpoint is inserted via API.

Thanks!
by justine
Tue Feb 27, 2024 4:49 pm
Forum: API
Topic: Tasks API - PUT with TaskStatus
Replies: 2
Views: 193

Re: Tasks API - PUT with TaskStatus

My client needs to mark tasks done via the API. Is TaskStatus a supported field for PUT requests to Tasks? I don't see it included in the Tasks API spec . If this is not supported, does anyone have a query handy that can be used via the Query API to update a task's TaskStatus only? Thanks so much! ...
by justine
Tue Feb 20, 2024 8:20 pm
Forum: API
Topic: "Duration" of X and / setting
Replies: 1
Views: 166

Re: "Duration" of X and / setting

In the desktop client, you can specify whether the system displays in 5/10/15 minute intervals. Is this setting exposed via the API? I'm not sure what name to search, and I haven't been able to find something that seems appropriately named. ETA: Specifically, in the Open Dental desktop application,...
by justine
Mon Feb 19, 2024 3:18 pm
Forum: API
Topic: Request webhook for blockout slots
Replies: 7
Views: 469

Re: Request webhook for blockout slots

Please add schedule events so there would be a webhook sending changes for the blockout timeslot changes data Hello Smilelink, We can add schedules to the API Events watch table. I have added researching this to our API development list. However, you can currently get this information from GET sche...
by justine
Fri Feb 16, 2024 1:52 pm
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 18
Views: 1211

Re: **URGENT BENEFITS ISSUE**

Awesome thanks! CodeGroups will always be the same across all clinics, unlike covcats, right? for example FMX/PANO will always be CodeGroupNum 2, right? Good afternoon omar22, CodeGroups (Frequency Limitations) can be configured however the practice wants. So, while it may be likely that CodeGroupN...
by justine
Fri Feb 16, 2024 9:38 am
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 18
Views: 1211

Re: **URGENT BENEFITS ISSUE**

omar22 wrote:
Fri Feb 16, 2024 7:25 am
Hey sorry to bother you again, but it appears version 23.2.62 is still unavailable for my offices to update to. Do you have an ETA to when this version will be available?
Good morning omar22,

23.2.62 has been released.

Thanks!
by justine
Wed Feb 14, 2024 8:35 am
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 18
Views: 1211

Re: **URGENT BENEFITS ISSUE**

Is there a way to POST frequency in CodeGroups? I can't find any documentation on the API specification or anything to implement this new change. Benefits were enhanced in version 23.2.62. -GET no longer requires a PlanNum or PatPlanNum. -GET now returns CodeGroupNum value. -POST now supports creat...
by justine
Wed Feb 14, 2024 8:01 am
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 18
Views: 1211

Re: **URGENT BENEFITS ISSUE**

I tried using the POST /benefits with CodeGroupNum and it doesn't work (my demo versionis 23.3.32.0). Please see payload: { "PlanNum": 74, "CovCatNum": 0, "Percent":-1, "MonetaryAmt":-1, "BenefitType":"Limitations", "QuantityQualifier":"Months", "Quantity":12, "CodeGroupNum": 2, "CoverageLevel": "N...
by justine
Tue Feb 13, 2024 3:16 pm
Forum: API
Topic: Open Dental 23.2 Benefit API does not have CodeGroup
Replies: 4
Views: 789

Re: Open Dental 23.2 Benefit API does not have CodeGroup

In latest update of Open Dental, it has broken functionality of Frequency as the screen is updated with introduction of something called "CodeGroup". if the application has the functionality, why the API does not support it? Benefits were enhanced in version 23.2.62. -GET no longer requires a PlanN...
by justine
Tue Feb 13, 2024 3:11 pm
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 18
Views: 1211

Re: **URGENT BENEFITS ISSUE**

Is there a way to POST frequency in CodeGroups? I can't find any documentation on the API specification or anything to implement this new change. Benefits were enhanced in version 23.2.62. -GET no longer requires a PlanNum or PatPlanNum. -GET now returns CodeGroupNum value. -POST now supports creat...
by justine
Thu Feb 08, 2024 8:42 am
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 18
Views: 1211

Re: **URGENT BENEFITS ISSUE**

omar22 wrote:
Thu Feb 08, 2024 6:32 am
Is there a way to POST frequency in CodeGroups? I can't find any documentation on the API specification or anything to implement this new change.
Unfortunately no, there is not. CodeGroups GET is currently in development. I have added CodeGroups PUT/POST to the API development list.

Thanks!
by justine
Wed Feb 07, 2024 1:35 pm
Forum: API
Topic: **URGENT BENEFITS ISSUE**
Replies: 18
Views: 1211

Re: **URGENT BENEFITS ISSUE**

Good afternoon omar22, Frequency Limitations implementation changed in v23.2 and now use CodeGroups. 23.1 23.2 23.3 To address this: Enhancing the Benefits endpoints to include CodeGroupNum, is on the top of our development list. Implementing CodeGroups GET is on the top of our development list. I w...
by justine
Wed Jan 31, 2024 10:51 am
Forum: API
Topic: API Events Question
Replies: 20
Views: 1461

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 justine
Wed Jan 31, 2024 10:19 am
Forum: API
Topic: API Events Question
Replies: 20
Views: 1461

Re: API Events Question

OK, I've re-read that API documentation and have a better understanding. Remote API is the API that we are using now found at https://api.opendental.com/api/v1 I have a few questions about Cloud API. 1. Since Cloud API connects directly to the API Service running on the Open Dental Cloud VM, what i...
by justine
Tue Jan 30, 2024 4:02 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 1461

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 ...
by justine
Tue Jan 30, 2024 3:06 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 1461

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 ...
by justine
Tue Jan 30, 2024 2:01 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 1461

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 justine
Mon Jan 29, 2024 1:55 pm
Forum: API
Topic: Posting a statement to the account ledger
Replies: 3
Views: 1084

Re: Posting a statement to the account ledger

saskia wrote:
Thu Jan 25, 2024 4:50 pm
We take care of the statements, we just want to be able to let OpenDental know that a statement was made/sent. THanks!
Good afternoon saskia,

I have added this to our development list. We will reply to this post with additional questions and/or when the request is complete.

Thanks!
by justine
Mon Jan 29, 2024 11:36 am
Forum: API
Topic: API Events Question
Replies: 20
Views: 1461

Re: API Events Question

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

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 justine
Thu Jan 25, 2024 1:33 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 1461

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 justine
Thu Jan 25, 2024 12:59 pm
Forum: API
Topic: API Events Question
Replies: 20
Views: 1461

Re: API Events Question

For the API Events functionality, specifically Database Events, in the Open Dental API, it says that "Open Dental and the API Service generate these events by polling the database at the frequency you specify." My question is, does it do this by checking a timestamp or other date field in the table...
by justine
Sat Jan 20, 2024 10:54 am
Forum: API
Topic: Open Dental 23.2 Benefit API does not have CodeGroup
Replies: 4
Views: 789

Re: Open Dental 23.2 Benefit API does not have CodeGroup

In latest update of Open Dental, it has broken functionality of Frequency as the screen is updated with introduction of something called "CodeGroup". if the application has the functionality, why the API does not support it? Good morning vgajeradental, We have added the following to our development...
by justine
Wed Dec 27, 2023 10:23 am
Forum: API
Topic: Appointment Slots (proposal for API)
Replies: 9
Views: 2619

Re: Appointment Slots (proposal for API)

I am rewriting my online booking system from the ground up. The current version reads data from appointment and schedule and scheduleOp to build a day and then block out slots that have appointments or blockouts. For security I am switching everything to use the open dental API....I am not sure if ...
by justine
Thu Dec 14, 2023 9:58 am
Forum: API
Topic: Daterange support for ProcedureLogs GET
Replies: 5
Views: 1871

Re: Daterange support for ProcedureLogs GET

Hi I hope procedurelog.DateTStamp will gives us the procedures from the start date to till now. Please correct me if im wrong. What we wanted is the procedure logs between two date range Regards Sendhil Good morning Sendhil, You are correct that procedurelogs OD API parameter DateTStamp will return...
by justine
Wed Dec 13, 2023 2:01 pm
Forum: API
Topic: Daterange support for ProcedureLogs GET
Replies: 5
Views: 1871

Re: Daterange support for ProcedureLogs GET

Hi API developers, Can you add Date range support in ProcedureLogs GET (multiple)? For example GET /procedurelogs?startDateTStamp=2020-07-30 08:00:00&endDateTStamp=2020-08-30 08:00:00 This will be useful in the scenario where we want to process the data in batches for period of six months. Regards ...
by justine
Wed Dec 13, 2023 1:52 pm
Forum: API
Topic: TreatPlans POST
Replies: 36
Views: 8065

Re: TreatPlans POST

PBECKER wrote:
Wed Dec 13, 2023 11:17 am
any update on the last API method?
PBECKER,

Signing a TreatPlan via OD API is complex. We are in the process of researching exactly the best way to implement this for all OD API developers and Open Dental itself. We will update this thread soon.

Thanks!
by justine
Sat Dec 09, 2023 10:44 am
Forum: API
Topic: API for web forms
Replies: 6
Views: 2806

Re: API for web forms

The Sheets endpoint now returns sheet.IsWebform. This enhancement is available in version 23.3.14.
by justine
Mon Dec 04, 2023 2:25 pm
Forum: API
Topic: Getting several documents for a patient at a time
Replies: 2
Views: 1450

Re: Getting several documents for a patient at a time

We have a use case where we want to perform some AI image processing on x-rays to create and attach additional metadata to an image. We have been looking at the API for pulling a patient's documents and have a few questions. Here is the API in question: Documents POST DownloadSftp (https://www.open...
by justine
Mon Nov 20, 2023 12:40 pm
Forum: API
Topic: patient field defs
Replies: 4
Views: 1642

Re: patient field defs

saskia wrote:
Mon Nov 20, 2023 12:15 pm
Thanks! Once added, will we be able to post data to those created patfielddefs or is that a separate request?
Yes. I have added patfieldDefs POST and PUT to our development list. For additional information, please see patFields POST.

Thanks!
by justine
Mon Nov 20, 2023 11:59 am
Forum: API
Topic: patient field defs
Replies: 4
Views: 1642

Re: patient field defs

Any chance someone can point me in the right direction of API documentation on patient field defs? I'm looking at creating them via API and then populating data. Is this possible? I couldn't see anything under definitions, is it somewhere else or not supported in the API? Thanks. It is currently no...
by justine
Thu Nov 16, 2023 11:28 am
Forum: API
Topic: Benefit API Issue
Replies: 7
Views: 2243

Re: Benefit API Issue

CovCats GET is complete and is available the version 23.3.8.

Please see CovCats for more information.

Thanks!
by justine
Thu Oct 19, 2023 10:46 am
Forum: API
Topic: REQUEST: PUT refattaches
Replies: 2
Views: 1372

Re: REQUEST: PUT refattaches

Primary Use Case: User updates ReToStatus However, it would be helpful to update all the fields on the record: RefDate DateProcCompleted Transition Of Care RefNum ReferralType ProvNum Note And... while we're at it, DELETE refattaches but less of a priority Good morning rinse-dental, I have added re...
by justine
Wed Oct 18, 2023 9:48 am
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 5349

Re: Request benefits in family module

Please do add GET etrans, GET etransmessagetext, and GET insverifies to your development list. Good morning beacondental, Etranss GET is complete and is available in version 23.2.7. EtransMessageText GET is complete and is available in version 23.2.11. Insverifies GET is complete and is available i...
by justine
Thu Oct 12, 2023 2:41 pm
Forum: API
Topic: Bulk update comm log
Replies: 7
Views: 1817

Re: Bulk update comm log

We're seeing requests timeout and have been assuming that's OD throttling us - is this not the case? From what I can see in the documentation, it's 1 request per second - what happens when we go over that? We want to make sure the data we're trying to write back gets written back and we don't have ...
by justine
Thu Oct 12, 2023 2:00 pm
Forum: API
Topic: Bulk update comm log
Replies: 7
Views: 1817

Re: Bulk update comm log

I feared that was the case. We'll have to build in our own delay to ensure we don't get throttled when we're trying to post hundreds of comm logs when we do a batch send. A real bummer, this is definitely an API where being able to bulk update would be very useful and reduce load for both sides. Pl...
by justine
Mon Oct 09, 2023 11:10 am
Forum: API
Topic: Posting payments for dynamic payment plans
Replies: 16
Views: 3223

Re: Posting payments for dynamic payment plans

Hey - checking in to see where in the pipeline these requests might be? I've got some related enhancement requests around the regular patient payment plans that were submitted around the same time - I suspect they may have all been lumped together? Thanks! Good morning Saskia, Our API team processe...
by justine
Mon Oct 02, 2023 3:12 pm
Forum: API
Topic: POST DiscountPlanSub defect
Replies: 4
Views: 1524

Re: POST DiscountPlanSub defect

rinse-dental wrote:
Tue Sep 26, 2023 7:36 pm
Thanks!
Hello rinse-dental,

We addressed an issue where procedurelog.DiscountPlanAmt may not have been updated when a discountplansub POST/PUT had been called. This fix is available in version 23.1.53 and newer.

Thanks!
by justine
Mon Sep 25, 2023 10:05 am
Forum: API
Topic: POST DiscountPlanSub defect
Replies: 4
Views: 1524

Re: POST DiscountPlanSub defect

If posting a discount plan via the API, the Open Dental client does not appear to incorporate the discounts when calculating apt estimates/totals. More specifically, the procedurelog table does not update the DiscountPlanAmt field. EDIT: This appears to be an issue when you do not set the optional ...
by justine
Mon Sep 18, 2023 1:07 pm
Forum: API
Topic: Add OrthoRemainM to Claim PUT API
Replies: 4
Views: 3472

Re: Add OrthoRemainM to Claim PUT API

Good afternoon ajaykodam,

OrthoRemainM has been added to Claims PUT and is available in version 23.2.18.

Thanks!
by justine
Wed Sep 06, 2023 9:46 am
Forum: API
Topic: Program Link Triggered E-Mail for Next appointment using n8n
Replies: 8
Views: 2386

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

You can create a Program Link to place a button in the UI, like pictured above. Our manual has a lot of details for setup and implementation. I would recommend referencing Program Links for general information and Custom Bridges for creating your own program link. Are there lists of the "many patie...
by justine
Thu Aug 31, 2023 2:35 pm
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 2116

Re: Looking for ideas on eliminating data synchronization feedback loop

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

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 justine
Thu Aug 31, 2023 10:02 am
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 2116

Re: Looking for ideas on eliminating data synchronization feedback loop

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

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 justine
Wed Aug 30, 2023 12:15 pm
Forum: API
Topic: Looking for ideas on eliminating data synchronization feedback loop
Replies: 11
Views: 2116

Re: Looking for ideas on eliminating data synchronization feedback loop

We are doing this because one requirement from our client is that a user must be able to add a note even if the eConnector is down for some reason. If the eConnector is down we will write the note back to OD as soon as it is back online, but in the meantime the user sees the note because it is stor...
by justine
Thu Jul 13, 2023 3:04 pm
Forum: API
Topic: Confirmation status
Replies: 6
Views: 4122

Re: Confirmation status

Good afternoon beacondental.

HistAppointments GET is available in version 23.1.30.
by justine
Wed Jul 05, 2023 3:11 pm
Forum: API
Topic: Payments POST - set payType
Replies: 18
Views: 5102

Re: Payments POST - set payType

Awesome! Thank you! Do you know how long it typically takes for versions to go from beta to full release? I know I'm going to have clients who don't want to run a beta version so if there's any ballpark I can give them that would be great. Thanks! We attempt to release four minor versions per year,...
by justine
Wed Jul 05, 2023 12:28 pm
Forum: API
Topic: Prepayments for dynamic payment plans
Replies: 6
Views: 3603

Re: Prepayments for dynamic payment plans

saskia wrote:
Wed Jul 05, 2023 6:23 am
Is there a target release date for this? Thanks!
Good afternoon saskia,

This is currently in the final stages of development. We will update this thread when it is complete.

Thanks!
by justine
Wed Jul 05, 2023 12:26 pm
Forum: API
Topic: Payments POST - set payType
Replies: 18
Views: 5102

Re: Payments POST - set payType

Is there a target release date for this yet? Thanks. Good afternoon saskia, Payments POST PayType enhancement is available in version 23.1.27. If you are curious about API features, you can always check out the previous versions page . Every API feature or enhancement will be on the previous versio...
by justine
Mon Jul 03, 2023 3:02 pm
Forum: API
Topic: ProcNotes
Replies: 1
Views: 1200

Re: ProcNotes

I see a method to POST ProcNotes: https://www.opendental.com/site/apiprocnotes.html is there a method to GET them? ProcedureLogs GET doesnt have Good afternoon paulwilliamsdds, Currently, there is no ProcNotes GET, but we can add this to our development list, if you'd like. Also, ChartModules GET P...
by justine
Mon Jul 03, 2023 8:40 am
Forum: API
Topic: Confirmation status
Replies: 6
Views: 4122

Re: Confirmation status

Is there a way to add GET histappointments, PUT or POST histappointments as well. I do recognize that we do can a short query on histappointments appts , but we can not change the histappointments status. Or, is there a way to change the histappointments confirmation status Good morning beacondenta...
by justine
Fri Jun 30, 2023 7:13 am
Forum: API
Topic: API ProcTPs question
Replies: 10
Views: 4581

Re: API ProcTPs question

Were you able to research the feasibility/workflow of adding procedurecodes/procedurelogs POST? Not yet. API job requests are completed in the order they are received. There are dozens of requests ahead of this one. You have made 12 API feature requests. This one is the most recent, so the API team...
by justine
Tue Jun 27, 2023 9:48 am
Forum: API
Topic: API query error message
Replies: 4
Views: 1871

Re: API query error message

That query is working fine if I run it in User Query window of Open Dental, but if I try running it in PUT ShortQuery method API then it is giving unauthorized as error. Good morning beacondental, Depending on how you are sending your API request, the application/program/client may have trouble par...
by justine
Tue Jun 20, 2023 7:55 am
Forum: API
Topic: New API for Fam Aging Balance
Replies: 6
Views: 3654

Re: New API for Fam Aging Balance

kashgoyal wrote:
Tue Jun 20, 2023 12:11 am
Hi justine,

So "GET accountmodule/Aging honors that process" means when the Api is called aging will run and provide latest balance or it will not be run?

Thanks!
Yes, accountmodule/Aging runs aging.
by justine
Thu Jun 15, 2023 9:36 am
Forum: API
Topic: New API for Fam Aging Balance
Replies: 6
Views: 3654

Re: New API for Fam Aging Balance

Hi justine, Thanks for providing the aging balance Api endpoint. We can certainly use this endpoint if the api pertains that we would be able to get accurate and current numbers for the aging report at any given moment as Open Dental's documentation (https://www.opendental.com/manual/aging.html) st...
by justine
Tue Jun 13, 2023 3:49 pm
Forum: API
Topic: API FeeScheds Request
Replies: 8
Views: 4012

Re: API FeeScheds Request

Hello, I would like to request being able to POST new fee schedules and being able to add fees on a D-code level. Is there an existing method of achieving this? If not, I would like to request it please :) Thank you all so much! Omar Good afternoon omar22, We will look into adding the ability to PO...
by justine
Tue Jun 13, 2023 8:06 am
Forum: API
Topic: New API for Fam Aging Balance
Replies: 6
Views: 3654

Re: New API for Fam Aging Balance

Hi Team, We need a way to show the current family aging balance. We noticed that Open Dental stores this information in a table, but that table is only updated in certain cases. We would like to display that data to the user, but we would need a way to get what it would show if the calculation for ...
by justine
Mon Jun 12, 2023 8:59 am
Forum: API
Topic: API ProcTPs question
Replies: 10
Views: 4581

Re: API ProcTPs question

Yes, please do add Prosthesis (and probably DateOriginalProsth and IsDateProsthEst) to procedurelogs. We would need the GET and POST functions for all these date sets. Good morning beacondental, For procedurelogs GET, we will add Prosthesis, DateOriginalProsth and IsDateProsthEst, to our developmen...
by justine
Wed Jun 07, 2023 12:39 pm
Forum: API
Topic: API ProcTPs question
Replies: 10
Views: 4581

Re: API ProcTPs question

I was looking to get the prosthesis replacement GET function in ProcTPs. I don't see it here in this link. Would it be somewhere else? https://www.opendental.com/site/apiproctps.html Hello beacondental, Within Open Dental, Prosthesis Replacement is only visible if the procedure is not in Canada and...
by justine
Wed Jun 07, 2023 8:21 am
Forum: API
Topic: Income transfer manager
Replies: 5
Views: 3299

Re: Income transfer manager

beacondental wrote:
Tue Jun 06, 2023 7:51 pm
Is there a way to run the income transfer manager thru the API short query?
No, there is not.
by justine
Tue Jun 06, 2023 2:41 pm
Forum: API
Topic: Patient portal API
Replies: 3
Views: 3003

Re: Patient portal API

We would need the patients username. The use case it that many times patients can not get into their patient records and need to be emailed the usernames. The API will allow the username to be emailed. Hello beacondental, A patient's Patient Portal username is stored in the userweb table . You coul...
by justine
Tue Jun 06, 2023 9:07 am
Forum: API
Topic: Question on DiscountPlanSubs DELETE
Replies: 1
Views: 2337

Re: Question on DiscountPlanSubs DELETE

I see that DiscountPlanSubs DELETE is a new feature. When reading the online explanation, I had a clarification. Is this DELETE function such that API users are dropping the discount plan? Or is it deleting the discount plans in List. Using DiscountPlanSubs DELETE, is essentially the same as clicki...
by justine
Thu Jun 01, 2023 12:54 pm
Forum: API
Topic: TreatPlanAttaches GET
Replies: 7
Views: 3606

Re: TreatPlanAttaches GET

How can these items we added to any of the Treatplan Get methods and/or any other API call? Note these fields are existing fields that are shown to patients for their treatment plan as the patients wants to see how much the insurance is covering and what is their out of pocket cost. Thank you API t...
by justine
Thu Jun 01, 2023 7:54 am
Forum: API
Topic: TreatPlanAttaches GET
Replies: 7
Views: 3606

Re: TreatPlanAttaches GET

PBECKER wrote:
Wed May 31, 2023 3:08 pm
for ProcedureLog GET we don't see insurance Estimate and Patient Estimate. Is it possible to get these two items added to ProcedureLog GET
No.

Insurance Estimate and Patient Estimate are not part of the procedurelog table.
by justine
Wed May 31, 2023 1:54 pm
Forum: API
Topic: TreatPlanAttaches GET
Replies: 7
Views: 3606

Re: TreatPlanAttaches GET

PBECKER wrote:
Wed May 31, 2023 1:49 pm
any way to update the existing TreatPlansAttaches GET to return all fields names instead of having to GET then compare with ProcedureLogs GET
TreatPlanAttaches GET does return all fields in the table.
by justine
Wed May 31, 2023 1:45 pm
Forum: API
Topic: TreatPlanAttaches GET
Replies: 7
Views: 3606

Re: TreatPlanAttaches GET

Is it possible to add the below fields to the api response for TreatPlanAttaches GET tooth Number Procedure Cost Insurance Estimate Patient Estimate Hello PBECKER, The TreatPlanAttach table has a FK to procedurelog.ProcNum. Using the procedurelog.ProcNum, you can look up the procedurelog. The proce...
by justine
Mon May 22, 2023 3:26 pm
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 13
Views: 4054

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

Thank you. Will this estimate consider date - similar to the Treatment Plan? For example, if a patient is not eligible for a cleaning until [recall date] and the appointment is booked after [recall date] - will the estimate be based on today, the date the estimate was created, or the scheduled appo...
by justine
Mon May 22, 2023 2:09 pm
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 13
Views: 4054

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

Is it possible to retrieve Open Dental's calculations for the following: Estimated patient portion as found in the appointment screen in Open Dental Treatment plan cost break down including Insurance portion, Patient portion, writeoff, etc. as found in the Treatment Plan screen If not, is it possib...
by justine
Wed May 17, 2023 9:38 am
Forum: API
Topic: Request for a PUT to update data via the DiscountPlanSubs API
Replies: 10
Views: 4147

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

joebrown_subscribili wrote:
Thu Apr 13, 2023 3:14 pm
Not to be a pain, but do you possibly have an estimate for when this functionality might be available? Thank you.
DiscountPlanSubs DELETE is available in version 23.1.12 and later.

Thanks!
by justine
Tue May 16, 2023 11:27 am
Forum: API
Topic: How to retrieve Open Dental's calculated insurance and patient portions?
Replies: 13
Views: 4054

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

Is it possible to retrieve Open Dental's calculations for the following: Estimated patient portion as found in the appointment screen in Open Dental Treatment plan cost break down including Insurance portion, Patient portion, writeoff, etc. as found in the Treatment Plan screen If not, is it possib...
by justine
Mon May 15, 2023 9:24 am
Forum: API
Topic: Date Issue with API
Replies: 10
Views: 4250

Re: Date Issue with API

Hello, I found that when I try to add history in the ProcedureLogs API and put the date in the YYYY-MM-DD format, the date gets uploaded as the next day. This issue is also present when I try to search for patients using the GET and filter by DOB, it doesn't work, since the date I enter is a day ah...
by justine
Thu May 11, 2023 1:05 pm
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 5349

Re: Request benefits in family module

I guess the question outstanding is the following: Is there a way for the api to ping "request benefits" to see if a plan is active and not get results that a staff member clicked "Now" When you put Getinsverity, then you are just getting the info a staff member manually modified by clicking now or...
by justine
Wed May 10, 2023 1:03 pm
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 5349

Re: Request benefits in family module

Please do add GET etrans, GET etransmessagetext, and GET insverifies to your development list. Great! We have added GET insverifies, GET etrans and GET etransmessagetext to our development list. New requests are completed in the order in which they are received. There are requests ahead of you. Com...
by justine
Wed May 10, 2023 12:09 pm
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 5349

Re: Request benefits in family module

Yes, we are talking about eBenefits under "Request benefits." Is there a way to do an API call and request results from the 271 response. Hello beacondental, You can get the results from the 271 response in the etransmessagetext table. While it is not possible to make an electronic benefits request...
by justine
Wed May 10, 2023 11:00 am
Forum: API
Topic: Request benefits in family module
Replies: 13
Views: 5349

Re: Request benefits in family module

Within family module, open dental has "Request benefits" - is there a way to get an API for request benefits feature and retrieve results of the 271 normal response from Dentalxchange. This is to see if it's active coverage or not (and maybe benefit information) under 271 normal response. As of now...
by justine
Tue May 09, 2023 3:18 pm
Forum: API
Topic: Program links
Replies: 3
Views: 2941

Re: Program links

Hello Open Dental, We understand that API documents (https://www.opendental.com/site/apidocuments.html) has the ability to get and post images saved to open dental images module. But, with program links, we link to Kodak xrays with Open Dental patnum ID. Is there a way thru the open dental API to g...
by justine
Mon May 08, 2023 12:25 pm
Forum: API
Topic: Confirmation status
Replies: 6
Views: 4122

Re: Confirmation status

beacondental wrote:
Mon May 08, 2023 10:50 am
We are you wanting to know what confirmation statuses a single appointment has had over time.
Good afternoon beacondental,

We can add GET histappointments to our development list. In the meantime, you can use PUT queries/ShortQuery to query histappointment table in the database.
by justine
Thu May 04, 2023 1:42 pm
Forum: API
Topic: Updating recall type
Replies: 5
Views: 3680

Re: Updating recall type

Right now, the API does not allow patient recall types to be changed from "Set Prophy" to "Set Perio." We are not able to find API to update recall type 'Prophy' to 'Perio' for the patient. Please help. Recalls GET and Recalls PUT SwitchType are complete. Recalls PUT SwitchType is what you're after...
by justine
Wed May 03, 2023 7:56 am
Forum: API
Topic: Claim create
Replies: 9
Views: 4135

Re: Claim create

beacondental wrote:
Tue May 02, 2023 7:09 pm
When you say "under development", then is it expected to be released in the next one month or so? Or longer?
Good morning beacondental,

I'd estimate Claims POST will be complete in about 4 weeks time.
by justine
Tue May 02, 2023 12:03 pm
Forum: API
Topic: Claim create
Replies: 9
Views: 4135

Re: Claim create

Hello Open Dental API Team, Is it possible in open dental API to create a claim based on unsent claims. What exact link should I review to create a new claim (I think it should be the post function), but just wanted to clarify. Hello beacondental, Claims POST is currently in development. However, i...
by justine
Fri Apr 28, 2023 8:48 am
Forum: API
Topic: Sheets for payment receipts
Replies: 1
Views: 3224

Re: Sheets for payment receipts

Hello Open dental API, I wanted to see if your API allows download of payment receipts based on payment date. So, the sheet PDF would be extracted and saved on our hosting via the API. Also, would we be able to access the scanned/imported images folders in Imaging module of Open dental. Basically, ...
by justine
Thu Apr 06, 2023 8:48 am
Forum: API
Topic: FHIR with trial version
Replies: 34
Views: 41565

Re: FHIR with trial version

mcardosog wrote:
Wed Apr 05, 2023 10:10 pm
I am also trying to enable the API with the trial version. Can I receive a key? :D
The trial version of Open Dental is not intended for API testing, we have a public demo specifically for this.

Please check out the Getting Started guide and API documentation.
by justine
Wed Mar 15, 2023 9:10 am
Forum: API
Topic: RefAttaches API functionality not working
Replies: 2
Views: 1358

Re: RefAttaches API functionality not working

Below API functionality not working. GET RefAttaches API functionality not working. it gives the error message "refattaches GET is not a valid method." with HTTP status code 400. GET /refattaches?PatNum= API functionality not working. it gives the error message "refattaches GET is not a valid metho...
by justine
Thu Mar 09, 2023 8:02 am
Forum: API
Topic: Updating recall type
Replies: 5
Views: 3680

Re: Updating recall type

Yes exactly. This is where SET Perio and SET Prophy is found. We would like to change this via a post function with the API. Thank you for the clarification. Your request has been added to our development list. Requests are completed in the order that they are received. We will reply here when deve...
by justine
Tue Mar 07, 2023 3:21 pm
Forum: API
Topic: Updating recall type
Replies: 5
Views: 3680

Re: Updating recall type

For example, this API link (https://www.opendental.com/site/apirecalls.html), shows you can modify many of the recall fields, but NOT Recall Type. Is this something that can be done? Good afternoon akjain1@gmail.com, You are correct, currently you cannot change a recalltype via the API. We can add ...
by justine
Wed Feb 15, 2023 11:06 am
Forum: API
Topic: Error on medicationPats api
Replies: 3
Views: 1387

Re: Error on medicationPats api

rinse-rey wrote:
Mon Feb 13, 2023 12:19 pm
- It's happening with only couple of patients.
- For those patients, the other endpoints work.
- I'm able to call other enpoints with the current key
A fix for this has been implemented and will be available in version 22.3.49 and 22.4.22.
by justine
Tue Jan 24, 2023 8:10 am
Forum: API
Topic: Benefits API req
Replies: 19
Views: 4171

Re: Benefits API req

Yes, the 'through age' field is what I was referring to. Okay cool, so I will try with that POST method. It wasn't working with the demo version though so hopefully it'll work with the full version. Thank you so much Justine The trial version of Open Dental is not intended for API testing, we have ...
by justine
Mon Jan 23, 2023 9:33 am
Forum: API
Topic: Benefits API req
Replies: 19
Views: 4171

Re: Benefits API req

Hi Justine - hope you are doing well. I have a quick question regarding fluoride and sealant age limit. How do I update these using the Benefit API? They don't appear to be part of any category. Thanks! Hello Omar, Flouride or sealant age limit is stored in the Benefits Quantity field with a Quanti...
by justine
Fri Jan 06, 2023 9:55 am
Forum: API
Topic: How to sync patfields back to our system from OD ?
Replies: 5
Views: 1620

Re: How to sync patfields back to our system from OD ?

Thanks for the reply! The second implementation would be better in our case since the webhook can be triggered automatically without any intervention. Just wanted to know the ETA for the patfield subscription feature being added to the API ? Hello vinayaka2000, The PatField table can now be monitor...
by justine
Wed Jan 04, 2023 1:09 pm
Forum: API
Topic: Benefits API req
Replies: 19
Views: 4171

Re: Benefits API req

Hi Justine - hope you are doing well. I have a quick question regarding fluoride and sealant age limit. How do I update these using the Benefit API? They don't appear to be part of any category. Thanks! Hello Omar, Flouride or sealant age limit is stored in the Benefits Quantity field with a Quanti...
by justine
Wed Jan 04, 2023 8:35 am
Forum: API
Topic: How to sync patfields back to our system from OD ?
Replies: 5
Views: 1620

Re: How to sync patfields back to our system from OD ?

Thanks for the reply! The second implementation would be better in our case since the webhook can be triggered automatically without any intervention. Just wanted to know the ETA for the patfield subscription feature being added to the API ? Hello vinayaka2000, PatFields has been enhanced. Please s...
by justine
Tue Dec 20, 2022 2:54 pm
Forum: API
Topic: API endpoint to creat API Key
Replies: 6
Views: 1993

Re: API endpoint to creat API Key

dcrider wrote:
Tue Dec 20, 2022 2:45 pm
Are generated but unassigned keys charged each month, or are they only charged after being entered at the practice's OpenDental installation?
Hello dcrider,

Generated keys are only charged after being entered in at the practice's Open Dental installation.
by justine
Tue Dec 20, 2022 11:42 am
Forum: API
Topic: Questions about API throttling and performance
Replies: 1
Views: 967

Re: 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 u...
by justine
Tue Dec 20, 2022 8:04 am
Forum: API
Topic: API endpoint to creat API Key
Replies: 6
Views: 1993

Re: API endpoint to creat API Key

Hello Sarah we agree the od api side is secure. the issue is were running out of keys that we have to manually add each time. our goal is either add api keys via an api get method or have a 15 days stored on our database ready for use. Please let me know Thank you Sarah Good morning PBECKER, I can ...
by justine
Wed Dec 14, 2022 8:04 am
Forum: API
Topic: API not found. Requesting new APIs
Replies: 57
Views: 177407

Re: API not found. Requesting new APIs

Development requests are completed in the order we receive them. There are a few ahead of you at the moment, but a rough guess would be approximately 2-3 weeks.

We will update this post as soon as it is available.

Thanks!
by justine
Tue Dec 06, 2022 8:08 am
Forum: API
Topic: Benefits API req
Replies: 19
Views: 4171

Re: Benefits API req

Good morning omar22,

We can add Benefits DELETE along with Benefits PUT. Requests are completed in the order that they come in. There are a few ahead of you so I'd estimate 4 weeks time.

We will update this post when completed.

Thank you!

justine
by justine
Mon Dec 05, 2022 3:49 pm
Forum: API
Topic: Benefits API req
Replies: 19
Views: 4171

Re: Benefits API req

omar22 wrote:
Mon Dec 05, 2022 2:58 pm
Hi,

I would like to request an option to PUT into Benefits table.

Thank you!
Hello Omar22,

We will add PUT Benefits to our development list. What specifically are you interested in updating?

Thank you.
by justine
Mon Nov 21, 2022 8:14 am
Forum: API
Topic: Webhook not getting triggerred for API Subscriptions
Replies: 8
Views: 1889

Re: Webhook not getting triggerred for API Subscriptions

Hello, thanks for the revert ! Please find details below : The version of OD currently running in sandbox env is : 22.3.24.0 Have you deleted all other subscriptions you're not using - Yes If you repeatedly call GET subscriptions, does SubscriptionNum 7's DateTimeStart value increment by the Pollin...
by justine
Wed Nov 16, 2022 11:24 am
Forum: API
Topic: Webhook not getting triggerred for API Subscriptions
Replies: 8
Views: 1889

Re: Webhook not getting triggerred for API Subscriptions

Hello vinyaka2000, Thank you for verifying the above information. A few questions. What version of Open Dental are you running? I see in your response for GET subscriptions that the SubscriptionNum is 7. Have you deleted all other subscriptions you're not using? If you repeatedly call GET subscripti...
by justine
Mon Nov 14, 2022 2:52 pm
Forum: API
Topic: Webhook not getting triggerred for API Subscriptions
Replies: 8
Views: 1889

Re: Webhook not getting triggerred for API Subscriptions

Hello, thanks for the reply. Yes, the API service has been installed in OD, and though I'm able to confirm that the webhook got added successfully, it doesn't seem to get triggered when a patient or appointment record is changed even though OD is running Hello vinayaka2000, Just for clarification, ...
by justine
Mon Nov 14, 2022 2:13 pm
Forum: API
Topic: 911 Open Dental API appesr to be down
Replies: 3
Views: 1565

Re: 911 Open Dental API appesr to be down

PBECKER wrote:
Mon Nov 14, 2022 7:59 am
The issue is hit and miss.


The second the the api is working and a couple seconds later its not working
Hello PBECKER,

This has been addressed. Please let us know if you experience any further issues.

Thanks!
by justine
Mon Nov 14, 2022 8:26 am
Forum: API
Topic: 911 Open Dental API appesr to be down
Replies: 3
Views: 1565

Re: 911 Open Dental API appesr to be down

Good morning PBECKER,

Thank you for letting us know. We are actively looking into this for you right now.
by justine
Thu Oct 20, 2022 2:27 pm
Forum: API
Topic: API Enhacement Request: PatFields
Replies: 2
Views: 1336

Re: API Enhacement Request: PatFields

Hello, I made a previous request to add POST to Referrals, and I need to make the same request to add POST to PatFields. Again, our integrated CRM system relies on many fields to create a new patient within Open Dental, make their first appointment, and assign all the variables associated with that...
by justine
Thu Oct 13, 2022 1:39 pm
Forum: API
Topic: Scheduling a Planned Appointment
Replies: 14
Views: 3915

Re: Scheduling a Planned Appointment

How can we relate the Planned Appt with the New Scheduled Appt from the Appt ? Is there any foreign key we can look at? A planned appointment and a scheduled appointment, are two separate appointments. When you schedule a planned appointment using Appointments POST SchedulePlanned, you supply the p...
by justine
Fri Sep 30, 2022 11:45 am
Forum: API
Topic: AppointmentTypeNumber for Appointments POST
Replies: 3
Views: 1588

Re: AppointmentTypeNumber for Appointments POST

Can we get some guidance on AppointmentTypeNumber for Appointments POST (create) What values can we pass for AppointmentTypeNumber? Where is their more rerferene info on how we can utilize AppointmentTypeNumber? Thank you API team. Appointments POST (create) Version Added: 21.1 The following fields...
by justine
Tue Sep 27, 2022 9:14 am
Forum: API
Topic: It is possible to API call on windows Open Dental to ubuntu machine
Replies: 1
Views: 1246

Re: It is possible to API call on windows Open Dental to ubuntu machine

My Scenario - I want to Integrate Open Dental API with my own application where data of patients, appointments, and clinics I want to fetch or pull from Open Dental to my application and store data into my own application table, Good morning Roonyx, I understand that you're interested in developing...
by justine
Mon Sep 26, 2022 10:25 am
Forum: API
Topic: I want to fetch the images from open dental using API
Replies: 1
Views: 1250

Re: I want to fetch the images from open dental using API

How can fetch images from Open Dental API into my application? I used Open dental API and it's working. I want to fetch images from Open Dental using API, but how can I achieve this? For example - I am using this endpoint - GET https://api.opendental.com/api/v1//documents response given - { "DocNum...
by justine
Mon Sep 26, 2022 9:28 am
Forum: API
Topic: Open Dental Provide to access Images using API
Replies: 1
Views: 1325

Re: Open Dental Provide to access Images using API

I want to fetch the all data of patients from my own Open Dental software, So can I fetch the patient profile image using API? Or Open Dental provide any kind of API where I can fetch the images? Please do not double post. Additional quote taken from here : How can fetch images from Open Dental API...
by justine
Mon Sep 26, 2022 9:11 am
Forum: Main Forum
Topic: I want to fetch the images from open dental using API
Replies: 1
Views: 1187

Re: I want to fetch the images from open dental using API

How can fetch images from Open Dental API into my application? I used Open dental API and it's working. I want to fetch images from Open Dental using API, but how can I achieve this? For example - I am using this endpoint - GET https://api.opendental.com/api/v1//documents response given - { "DocNum...
by justine
Fri Sep 23, 2022 10:58 am
Forum: API
Topic: GET Recall
Replies: 5
Views: 1899

Re: GET Recall

PBECKER wrote:
Fri Sep 23, 2022 9:31 am
example if we perform a Get Recall we would like all results returned and not just 100 or having to use any other methods.
PBECKER,

I understand. In the meantime, you can use Local or Service mode to get up to 1000 items at a time.
by justine
Fri Sep 23, 2022 9:26 am
Forum: API
Topic: Request for a PUT to update data via the DiscountPlanSubs API
Replies: 10
Views: 4147

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

That's amazing! Thank you. Do you have any idea when it might be available? Also, would it only be available in the newest Open Dental version or would it be pushed to some older versions as well. Thank you again. API resource development is done in requested order. There are a few ahead of you at ...
by justine
Fri Sep 23, 2022 9:23 am
Forum: API
Topic: GET Recall
Replies: 5
Views: 1899

Re: GET Recall

Justine I need a favor you may need to ask Jordan but we're ready to utilize the below get but the limit of 100 is an issue for us as we really need all results without having to use pagination or the localhost options. Is there anyway to get the rows returned to be at the minimum of 2000 rows. Thi...
by justine
Fri Sep 23, 2022 9:06 am
Forum: API
Topic: How to get API Servives?
Replies: 9
Views: 2427

Re: How to get API Servives?

Genyus wrote:
Thu Sep 22, 2022 11:50 pm
We were able to download the trial version 21-4-46 only. (TrialDownload-21-4-46.exe)
Hello Genyus,

Please see the Installation documentation:
https://www.opendental.com/manual/installation.html
by justine
Fri Sep 23, 2022 8:52 am
Forum: API
Topic: Request for a PUT to update data via the DiscountPlanSubs API
Replies: 10
Views: 4147

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

We love having the ability to link a patient to a discount plan via the API, but it would be great to be able to update it. Specifically, we want to be able to update the end date and the notes. Would it be possible to add a PUT for DiscountPlanSubs? Hello joebrown_subscribili, Yes, we can add a Di...
by justine
Fri Sep 23, 2022 8:46 am
Forum: API
Topic: GET Recall
Replies: 5
Views: 1899

Re: GET Recall

Hello API Team Request: update Recalls GET List method https://www.opendental.com/site/apirecalls.html Question 1 or end Date, how can we do current date + x number of days? If this isn't possible can this type of functionality be added for DateEnd? DateEnd: Due date range. String in "yyyy-mm-dd" f...
by justine
Fri Sep 23, 2022 8:05 am
Forum: API
Topic: Offset for Queries PUT ShortQuery
Replies: 2
Views: 1502

Re: Offset for Queries PUT ShortQuery

Hi Open Dental Support Team, I have been using Queries PUT ShortQuery along with the following JSON { "SqlCommand": "SELECT * FROM appointmenttype" } in order to get all appointment types. This works great for practices with less than 100 appt types. To handle the edge case where there is more than...
by justine
Thu Sep 22, 2022 2:23 pm
Forum: API
Topic: Moved OD db now cant access new data
Replies: 3
Views: 1425

Re: Moved OD db now cant access new data

I created a new API key specifically for the new db location and im pulling with that key which is only in the new software not the AWS instance with the old company. baoluan1, Only one eConnector per key set can be active at a time and it is likely that your AWS instance is still up and running. O...
by justine
Thu Sep 22, 2022 1:00 pm
Forum: API
Topic: Moved OD db now cant access new data
Replies: 3
Views: 1425

Re: Moved OD db now cant access new data

Our company recently changes IT support vendors for one of our clinics. In doing so we went from housing the OD db in a vendor supplied AWS VPC to an in-clinic server supported by the new company. Since doing the switch I am unable to get updated data via the API. I even tried changing to a new API...
by justine
Thu Sep 22, 2022 11:48 am
Forum: API
Topic: How can I connect Local API with trial version of open dental
Replies: 3
Views: 1589

Re: How can I connect Local API with trial version of open dental

Okay, Thanks for your valuable answer Justine, If I can purchase new open dental software so It will work for me? And Also can you please tell me how I can achieve recommend developing with the remote API and demo keys. This will allow you to develop utilizing the most current API resources. this t...
by justine
Thu Sep 22, 2022 9:07 am
Forum: API
Topic: How can I connect Local API with trial version of open dental
Replies: 3
Views: 1589

Re: How can I connect Local API with trial version of open dental

I used the trial version of open dental & want to fetch data using Local API, I just want to confirm can I use Local API with the trial version, I follow this doc https://www.opendental.com/site/apilocal.html , where It says when you open Opendental on the workstation It will open Local API end poi...
by justine
Wed Sep 21, 2022 8:30 am
Forum: API
Topic: How to get API Servives?
Replies: 9
Views: 2427

Re: How to get API Servives?

I was able to add the license key but still I'm not able to use the api service as given in the document. http://localhost:30223/api/v1/ Also I was looking to install the API Services, but I could not see any Folder/Exe files related API Service in opendental installation. Please kindly guide me. G...
by justine
Fri Sep 16, 2022 3:06 pm
Forum: API
Topic: Slot API error
Replies: 13
Views: 2802

Re: Slot API error

Please see my API request as below Source code: URL = f"{current_app.config['OD_API_REQUEST_URL']}/appointments/Slots?date=2022-09-19" headers = {"Content-Type":"application/json", "authorization":f"ODFHIR {current_app.config['OD_DEVELOPER_API_KEY']}/{current_app.config['OD_CUSTOMER_API_KEY']}" } r...
by justine
Fri Aug 26, 2022 4:23 pm
Forum: API
Topic: API down?
Replies: 4
Views: 1725

Re: API down?

Pedro,
The slowness issue has been addressed. Please let us know if you still experience issues.

Thanks!
by justine
Fri Aug 26, 2022 4:04 pm
Forum: API
Topic: API down?
Replies: 4
Views: 1725

Re: API down?

PBECKER wrote:
Fri Aug 26, 2022 3:03 pm
API Team,

Some of our API calls to Open Dental API/EConnecctor are 100% failining?

Can you check and see if everything is ok on theOpen Dental API endpoints?

Let me know, thanks so much API team!

-Pedro
Hello Pedro,

We are aware of the API slowness issue and are working on it right now.
by justine
Wed Aug 24, 2022 1:03 pm
Forum: API
Topic: API Performance Suggestions
Replies: 13
Views: 3966

Re: API Performance Suggestions

Update. I uninstalled 'OpenDent' (the econnector service)...then I installed the OpenDentalAPIService... then I reinstalled the econnector service and rebooted the server as instructed. The good news... all 3 Open Dental services are installed The bad news... the API Service is stopped and will not...
by justine
Wed Aug 24, 2022 8:22 am
Forum: API
Topic: API Performance Suggestions
Replies: 13
Views: 3966

Re: API Performance Suggestions

Good morning rinse-dental. All services must start with 'OpenDent...'. One of two things may be happening here. You may have installed the API service under the name 'OpenDent'. Typically, the Service Name would be called something like 'OpenDentalAPIService'. The documentation has been updated to m...
by justine
Mon Aug 01, 2022 9:05 am
Forum: API
Topic: Max 100
Replies: 17
Views: 4163

Re: Max 100

oK this is now making more sense. Is there any reason why this has to be run with a different port and as localhost? Instead of the same Open Dental public API endpoints? We've been a big adopted of the OD API and this is the first we have seen this new method using a port # and localhost. Local (a...
by justine
Mon Aug 01, 2022 8:24 am
Forum: API
Topic: Max 100
Replies: 17
Views: 4163

Re: Max 100

API Team, We're still unable to do a get with 1000. Everythign we have tried it continues to return 100 records. When we use the End URL (example): https://api.opendental.com/api/v1/reports/Aging?Offset=1000&DateAsOf=2022-07-13&ClinicNum=5 on the local machine we get only 100 records even if the of...
by justine
Fri Jul 29, 2022 2:59 pm
Forum: API
Topic: Ask to Arrive Early
Replies: 6
Views: 2286

Re: Ask to Arrive Early

Hello API Team, For the "Appointments GET" can you please add the appointment field named > Ask to Arrive Early ? Please let me know. Lets keep Innovating! Thank you API Team -Pedro Hello PBECKER, Appointments GET will now return DateTimeAskedToArrive. For more information, please see: https://www....
by justine
Fri Jul 29, 2022 2:49 pm
Forum: API
Topic: New API endpoint
Replies: 9
Views: 3179

Re: New API endpoint

ProcedureLogs POST GroupNote is complete. This will allow you to create a Group Note via the API. For more information please see:
https://www.opendental.com/site/apiprocedurelogs.html

This method will be available in beta version 22.2.24, which is estimated to be released within the next week.
by justine
Tue Jul 26, 2022 3:44 pm
Forum: API
Topic: Ask to Arrive Early
Replies: 6
Views: 2286

Re: Ask to Arrive Early

Hello PBECKER,

We can add DateTimeAskedToArrive to the appointments GET return object.

I have added this to our development list.
by justine
Wed Jun 15, 2022 10:41 am
Forum: API
Topic: Api implementation and sandbox account
Replies: 3
Views: 1859

Re: Api implementation and sandbox account

Hello dheesha,

I replied to your question in your other post found here:
https://www.opendentalsoft.com:8085/for ... f=9&t=7809
by justine
Wed Jun 15, 2022 10:35 am
Forum: API
Topic: Api filter
Replies: 1
Views: 1429

Re: Api filter

In the appointment api want get all results or patients list those having provAbbr" ="DOC1", how I get this with the help of API Hello dheesha, Firstly, getting all results via GET appointments. Please see our documentation in the section titled "Appointments GET (multiple)": https://www.opendental...
by justine
Tue Jun 14, 2022 11:18 am
Forum: API
Topic: Api implementation and sandbox account
Replies: 3
Views: 1859

Re: Api implementation and sandbox account

Hello dheesha,

For testing and setup information, please see our API documentation here:
https://www.opendental.com/site/apisetup.html

To pull example patient data please see our patients API documentation here:
https://www.opendental.com/site/apipatients.html
by justine
Fri May 20, 2022 10:52 am
Forum: API
Topic: New - Recalls GET List
Replies: 0
Views: 1771

New - Recalls GET List

We have received a feature request to display the Recall List as it appears in Open Dental.
This can be done with our new method: recalls GET List.

Information about recalls GET List can be found here: https://www.opendental.com/site/apirecalls.html and will be available for use in 22.1.32.

Thanks!
by justine
Thu May 12, 2022 3:23 pm
Forum: API
Topic: Appointments GET (ASAP)
Replies: 3
Views: 2093

Re: Appointments GET (ASAP)

Hello Becker, Our API is designed to mimic Open Dental functionality as closely as possible, thus ensuring database integrity. There is currently no way to filter the ASAP list by date range within Open Dental itself, so the API honors that. See: https://www.opendental.com/manual/asaplist.html Appoi...
by justine
Mon May 02, 2022 12:39 pm
Forum: API
Topic: Medicaid vs Non Medicaid Patients
Replies: 5
Views: 2871

Re: Medicaid vs Non Medicaid Patients

Patients GET (single) and Patients GET Simple response now includes MedicaidID. This functionality will be available in version 22.1.26, which is estimated to be released later this week.

See:
https://www.opendental.com/site/apipatients.html
by justine
Wed Apr 27, 2022 8:47 am
Forum: API
Topic: Medicaid vs Non Medicaid Patients
Replies: 5
Views: 2871

Re: Medicaid vs Non Medicaid Patients

Hello PBECKER, We can add MedicaidID to Patients GET. We will discuss Medicaid during our next API meeting. Also, FamilyModules GET Insurance will return information displayed similarly to the insurance section of the Family Module. This could tell you if the patient's insurance is Medicaid based on...
by justine
Wed Apr 06, 2022 10:30 am
Forum: API
Topic: Document Category clarification
Replies: 12
Views: 4601

Re: Document Category clarification

Hm - when we test the limit is 3 million not 16 million darcockerell, Documents POST Upload can now handle request lengths up to 16.8 million characters. This increased request length is available for use now. A return message stating you have exceeded this limit has been implemented and will be av...
by justine
Wed Mar 30, 2022 8:57 am
Forum: API
Topic: API Issue - Slots
Replies: 11
Views: 5082

Re: API Issue - Slots

Appointments GET Slots has been enhanced. Now includes an OpNum as a parameter and will return results for providers or hygienists. This will be available in 22.1.17. See: https://www.opendental.com/site/apiappointments.html To get what you're after, you probably want to use the ProvNum, OpNum and d...
by justine
Wed Mar 09, 2022 12:18 pm
Forum: API
Topic: Requests for new API endpoints and new fields for an existing endpoint
Replies: 21
Views: 8539

Re: Requests for new API endpoints and new fields for an existing endpoint

5. View Electronic Forms a. - New endpoint to get a list of electronic forms info, and ability to download them by Patient (PatNum), similar to Documents endpoint. i. -- Table Reference : sheet, sheetDef, sheetfield, sheetfielddef Hello phi.bui, In addition to sheets GET, we have added sheets POST ...
by justine
Tue Mar 08, 2022 9:00 am
Forum: API
Topic: Requests for new API endpoints and new fields for an existing endpoint
Replies: 21
Views: 8539

Re: Requests for new API endpoints and new fields for an existing endpoint

5. View Electronic Forms a. - New endpoint to get a list of electronic forms info, and ability to download them by Patient (PatNum), similar to Documents endpoint. i. -- Table Reference : sheet, sheetDef, sheetfield, sheetfielddef Hello phi.bui. The first part of your request was completed with she...
by justine
Wed Mar 02, 2022 11:52 am
Forum: API
Topic: API Request
Replies: 19
Views: 8551

Re: API Request

3. https://www.opendental.com/site/apiapptfields.html (Ability to create ApptField) under Setup, Appointments, Appointment Field Defs Hello PBECKER, Request 3. is complete. Information about ApptFieldDefs can be found here: https://www.opendental.com/site/apiapptfielddefs.html ApptFieldDefs GET and...
by justine
Tue Feb 15, 2022 11:48 am
Forum: API
Topic: API Request
Replies: 19
Views: 8551

Re: API Request

2. https://www.opendental.com/site/apiproviders.html (Ability to create provider) Hello PBECKER, Request 2. is complete. Information about Providers POST can be found here: https://www.opendental.com/site/apiproviders.html Providers POST will be available in version 21.4.24, which is estimated to b...
by justine
Thu Feb 10, 2022 9:36 am
Forum: API
Topic: API Request
Replies: 19
Views: 8551

Re: API Request

Hello PBECKER,

Feature requests 1, 2, and 3 are currently in development. 4 and 6 are up next. We will post a reply here as soon as they are ready.

Thanks!
by justine
Thu Feb 10, 2022 9:26 am
Forum: API
Topic: ASAP and Appointments GET (multiple)
Replies: 2
Views: 2356

Re: ASAP and Appointments GET (multiple)

Hello,

We will add these to our development list and discuss them at our next API meeting.

Thanks!
by justine
Thu Feb 10, 2022 9:21 am
Forum: API
Topic: API Request-Blockouts
Replies: 8
Views: 4324

Re: API Request-Blockouts

Hello,

We will add this to our development list and discuss it at our next API meeting.

Thanks!
by justine
Thu Jan 27, 2022 2:28 pm
Forum: API
Topic: Requests for new API endpoints and new fields for an existing endpoint
Replies: 21
Views: 8539

Re: Requests for new API endpoints and new fields for an existing endpoint

2. View Patient's Current Insurance Plan(s) for existing patient (Family File) a. - New endpoint to get a list of current insurance Plan(s) info by Patient (PatNum) Request 2 is complete. You can retrieve this information using FamilyModules GET Insurance. Please see: https://www.opendental.com/sit...
by justine
Wed Dec 29, 2021 8:49 am
Forum: API
Topic: Requests for new API endpoints and new fields for an existing endpoint
Replies: 21
Views: 8539

Re: Requests for new API endpoints and new fields for an existing endpoint

Hi, I am also looking for insurance detail by PatNum, could you please tell me the exact endpoint to retrieve that. I checked https://www.opendental.com/site/apiinssubs.html but there is no Get method for the same. Thanks, Poonam Hello poonam, You can retrieve the information you are looking for by...
by justine
Tue Dec 28, 2021 8:07 am
Forum: API
Topic: API Documents
Replies: 2
Views: 2398

Re: API Documents

We will discuss this in our next API development meeting and update you shortly. Thank you.
by justine
Tue Dec 28, 2021 8:02 am
Forum: API
Topic: Error while using Open Dental's FHIR API (v2)
Replies: 1
Views: 1992

Re: Error while using Open Dental's FHIR API (v2)

The FHIR PUT issue has been resolved.