Discrepancy in Group Note API Response for Procedure Code "GRP"

[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 29751 times

Thank you

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

[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]]"
}
]

[justine]

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!

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

[justine]

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!