Patient portal API

[beacondental]

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

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

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

[justine]

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;