Page 1 of 1
Patient portal API
Posted: Mon Jun 05, 2023 6:49 pm
by beacondental
Hello Open Dental. Is there a way to GET the API for Username for open dental patient portal?
Re: Patient portal API
Posted: Tue Jun 06, 2023 11:08 am
by SLeon
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?
Re: Patient portal API
Posted: Tue Jun 06, 2023 1:26 pm
by beacondental
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.
Re: Patient portal API
Posted: Tue Jun 06, 2023 2:41 pm
by justine
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;