Open Dental Forum

Posted: **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?

Posted: **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?

Posted: **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.

Posted: **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;

Open Dental Forum

Patient portal API

Patient portal API

Re: Patient portal API

Re: Patient portal API

Re: Patient portal API