GET ApiProcedureLogs

For requests or help with our API
Post Reply
PBECKER
Posts: 125
Joined: Mon Jan 03, 2022 11:54 am

GET ApiProcedureLogs

Post by PBECKER » Fri Aug 05, 2022 12:33 pm

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

PBECKER
Posts: 125
Joined: Mon Jan 03, 2022 11:54 am

Re: GET ApiProcedureLogs

Post by PBECKER » Tue Aug 09, 2022 7:14 am

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

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

Re: GET ApiProcedureLogs

Post by SLeon » Tue Aug 09, 2022 7:43 am

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.

Post Reply