Page 1 of 1
Discrepancy in Group Note API Response for Procedure Code "GRP"
Posted: Wed May 21, 2025 7:46 am
by beacondental
Hi Team,
I'm encountering an issue while fetching the group note from the ProcNote of a procedure with the procedure code ~GRP~. The API is returning a signature-type response, which doesn’t match the actual group note content displayed in Open Dental.
I've included the response below for reference. Could someone please look into this and clarify why this discrepancy exists?
This is blocking our functionality.
Response :
[
{
"PatNum": 19233,
"ProcNum": 1825149,
"ProcDate": "2025-05-15T00:00:00",
"ProcCode": "~GRP~",
"Note": "[[Prophy Child]]"
}
]
Actual Response : I've attached photo below
- Capture14.PNG (16.88 KiB) Viewed 30519 times
Thank you
Re: Discrepancy in Group Note API Response for Procedure Code "GRP"
Posted: Wed May 21, 2025 3:05 pm
by AustinD
Hello beacondental,
In order to help us troubleshoot your issue, please provide the following information in your post:
Database Version
API Endpoint being called
exact URL sent
exact JSON sent
exact JSON received (minus PHI)
ProcNotes GET will get a list of procnotes ordered by most recent. You can filter by procnum to return all related procnotes.
Thank you.
Re: Discrepancy in Group Note API Response for Procedure Code "GRP"
Posted: Fri May 30, 2025 4:46 am
by beacondental
Open Dental Version : 24.4.45.0
API Endpoint : PUT /queries/ShortQuery
Exact URL :
https://api.opendental.com/api/v1/queries/ShortQuery
JSON:
{
"SqlCommand": "select pl.PatNum,pl.ProcNum,pl.ProcDate,pc.ProcCode,pn.Note from procedurelog pl JOIN procedurecode pc ON pl.CodeNum=pc.CodeNum JOIN procnote pn ON pl.ProcNum=pn.ProcNum where ProcCode='~GRP~' and pl.PatNum=19233 and pl.ProcDate='2025-05-15'"
}
JSON Response :
[
{
"PatNum": 19233,
"ProcNum": 1825154,
"ProcDate": "2025-05-15T00:00:00",
"ProcCode": "~GRP~",
"Note": "[[Prophy Child]]"
},
{
"PatNum": 19233,
"ProcNum": 1825154,
"ProcDate": "2025-05-15T00:00:00",
"ProcCode": "~GRP~",
"Note": "Personal: favorite show is Bluey\r\nCC: No pain or discomfort at this time\r\nMed History: No contraindications to treatment, Pt's guardian denies any changes to med history/meds/allergies. Mom gave permission for application of 5% NaF varnish\r\nRadiographs: No x-rays\r\nChild Prophy: Hand Scaled, Polish, Floss, Fluoride applied\r\nRMH: Patient denies any med conditions, Patient denies taking any medications, No contraindications to treatment\r\nEOE/IOE: no changes/contradications noted. All Permanent first molars erupted. O-has shed, N-wiggly\r\nOCS: Negative (no lesions noted)\r\nGingiva: Generalized pink, Firm gingiva\r\nPlaque level: Localized, Light\r\nCalculus Level: Localized , Slight\r\nPerio: Normal\r\nOH: Patient's OH is Good. MTB 2x, Flosses 1x week. Demo'd proper homecare techniques. \r\nPeriodic Exam: Dr. Carol Rice. No findings, no caries detected.\r\nRecall: 6 month recall\r\nNext Priority: sealants on all permanent first molars\r\nHygienist: Isabelle Marques RDH"
},
{
"PatNum": 19233,
"ProcNum": 1825149,
"ProcDate": "2025-05-15T00:00:00",
"ProcCode": "~GRP~",
"Note": "[[Prophy Child]]"
}
]
Re: Discrepancy in Group Note API Response for Procedure Code "GRP"
Posted: Mon Jun 02, 2025 9:24 am
by justine
beacondental wrote: ↑Fri May 30, 2025 4:46 am
Open Dental Version : 24.4.45.0
API Endpoint : PUT /queries/ShortQuery
Exact URL :
https://api.opendental.com/api/v1/queries/ShortQuery
JSON:
{
"SqlCommand": "select pl.PatNum,pl.ProcNum,pl.ProcDate,pc.ProcCode,pn.Note from procedurelog pl JOIN procedurecode pc ON pl.CodeNum=pc.CodeNum JOIN procnote pn ON pl.ProcNum=pn.ProcNum where ProcCode='~GRP~' and pl.PatNum=19233 and pl.ProcDate='2025-05-15'"
}
JSON Response :
[
{
"PatNum": 19233,
"ProcNum": 1825154,
"ProcDate": "2025-05-15T00:00:00",
"ProcCode": "~GRP~",
"Note": "[[Prophy Child]]"
},
{
"PatNum": 19233,
"ProcNum": 1825154,
"ProcDate": "2025-05-15T00:00:00",
"ProcCode": "~GRP~",
"Note": "Personal: favorite show is Bluey\r\nCC: No pain or discomfort at this time\r\nMed History: No contraindications to treatment, Pt's guardian denies any changes to med history/meds/allergies. Mom gave permission for application of 5% NaF varnish\r\nRadiographs: No x-rays\r\nChild Prophy: Hand Scaled, Polish, Floss, Fluoride applied\r\nRMH: Patient denies any med conditions, Patient denies taking any medications, No contraindications to treatment\r\nEOE/IOE: no changes/contradications noted. All Permanent first molars erupted. O-has shed, N-wiggly\r\nOCS: Negative (no lesions noted)\r\nGingiva: Generalized pink, Firm gingiva\r\nPlaque level: Localized, Light\r\nCalculus Level: Localized , Slight\r\nPerio: Normal\r\nOH: Patient's OH is Good. MTB 2x, Flosses 1x week. Demo'd proper homecare techniques. \r\nPeriodic Exam: Dr. Carol Rice. No findings, no caries detected.\r\nRecall: 6 month recall\r\nNext Priority: sealants on all permanent first molars\r\nHygienist: Isabelle Marques RDH"
},
{
"PatNum": 19233,
"ProcNum": 1825149,
"ProcDate": "2025-05-15T00:00:00",
"ProcCode": "~GRP~",
"Note": "[[Prophy Child]]"
}
]
Hello beacondental,
From your example, calling GET:
Code: Select all
https://api.opendental.com/api/v1/procnotes?PatNum=19233&ProcNum=1825154
returns the all the procnotes for that patient and that procedure,
ordered by most recent. Then use the most recent procnote.Note field value.
Thanks!
Re: Discrepancy in Group Note API Response for Procedure Code "GRP"
Posted: Wed Jun 04, 2025 6:17 am
by beacondental
Hi Team,
Could you please add ProcDate as a filter parameter in the request for the ProcNote API?
The reason is that I fetch notes based on appointment procedures. However, procedures with the code ~GRP~ are not linked to appointments, making it difficult to identify the ProcNum associated with the specific appointment. Adding ProcDate as a filter would help accurately retrieve notes in such cases.
Re: Discrepancy in Group Note API Response for Procedure Code "GRP"
Posted: Wed Jun 04, 2025 8:24 am
by justine
beacondental wrote: ↑Wed Jun 04, 2025 6:17 am
Hi Team,
Could you please add
ProcDate as a filter parameter in the request for the
ProcNote API?
The reason is that I fetch notes based on appointment procedures. However, procedures with the code ~GRP~ are not linked to appointments, making it difficult to identify the ProcNum associated with the specific appointment. Adding ProcDate as a filter would help accurately retrieve notes in such cases.
Good morning beacondental,
ProcDate is not part of the
ProcNote table, so it cannot be added.
Thanks!