Page 1 of 1

GET ApiProcedureLogs

Posted: Fri Aug 05, 2022 12:33 pm
by PBECKER
Hello API Team

Question: We're trying to see if any of the Open Dental's APIs offers the below results. The following method appears to do the below can you please advise: https://www.opendental.com/site/apiprocedurelogs.html

Patient ID
patient Full Name
Date of Service: This is the date a procedure was completed
Provider Name: The provider Name that completed the below above procedure.
Procedure Completed: code or name of the type of procedures that was completed.
Amount due: (Broken down by insurance balance, and patient balance) - This must be current meaning it is an open balance that has not been paid.
Aging Period. Example this is the aging period of the above balance 0-30, 31-60, ..

Re: GET ApiProcedureLogs

Posted: Tue Aug 09, 2022 7:14 am
by PBECKER
Hello API Team Attn Jordan or Sarah.

Really need your help unless you recommend we go with a custom sql query.

Question: We're trying to see if any of the Open Dental's APIs offers the below results. The following method appears to do the below can you please advise: https://www.opendental.com/site/apiprocedurelogs.html

Patient ID
patient Full Name
Date of Service: This is the date a procedure was completed
Provider Name: The provider Name that completed the below above procedure.
Procedure Completed: code or name of the type of procedures that was completed.
Amount due: (Broken down by insurance balance, and patient balance) - This must be current meaning it is an open balance that has not been paid.
Aging Period. Example this is the aging period of the above balance 0-30, 31-60, ..

Re: GET ApiProcedureLogs

Posted: Tue Aug 09, 2022 7:43 am
by SLeon
Good morning,

Because these fields come from different tables and require many calculations, a query may be your best bet. I would recommend using Query #740 from https://opendentalsoft.com:1943/ODQuery ... yList.aspx as a starting place.