Patient portal API

For requests or help with our API
Post Reply
beacondental
Posts: 87
Joined: Wed Mar 15, 2023 8:43 am

Patient portal API

Post by beacondental » Mon Jun 05, 2023 6:49 pm

Hello Open Dental. Is there a way to GET the API for Username for open dental patient portal?

SLeon
Posts: 476
Joined: Mon Mar 01, 2021 10:00 am

Re: Patient portal API

Post by SLeon » Tue Jun 06, 2023 11:08 am

Can you please clarify, do you need to usernames of the patients or the username information for the dental office itself? What is your use case for the username?

beacondental
Posts: 87
Joined: Wed Mar 15, 2023 8:43 am

Re: Patient portal API

Post by beacondental » Tue Jun 06, 2023 1:26 pm

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.

justine
Posts: 168
Joined: Tue Dec 28, 2021 7:59 am

Re: Patient portal API

Post by justine » Tue Jun 06, 2023 2:41 pm

beacondental wrote:
Tue Jun 06, 2023 1:26 pm
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 could retrieve that information using a ShortQuery.
Something like this:

Code: Select all

SELECT username FROM userweb WHERE FKey=patient.PatNum AND FKeyType=1;

Post Reply