Does the patientNotes PUT endpoint allow setting the `Service` column of the `patientnote` table?

For requests or help with our API
Post Reply
kevinc
Posts: 4
Joined: Mon Dec 06, 2021 5:33 am

Does the patientNotes PUT endpoint allow setting the `Service` column of the `patientnote` table?

Post by kevinc » Fri Feb 04, 2022 12:44 pm

Is it only limited to the example return?

Code: Select all

{
 "Medical": "Unknown family history.",
 "ICEName": "Carolyn Wright",
 "ICEPhone": "(820) 202-1134"
} 
Thanks!

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

Re: Does the patientNotes PUT endpoint allow setting the `Service` column of the `patientnote` table?

Post by SLeon » Fri Feb 04, 2022 2:51 pm

Yes, the PatientNotes PUT method only allows the setting of those three fields. However, the "Service" column would simple for us to add if requested.

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Does the patientNotes PUT endpoint allow setting the `Service` column of the `patientnote` table?

Post by jordansparks » Sat Feb 05, 2022 6:00 pm

Yes, we'll add it.
Jordan Sparks, DMD
http://www.opendental.com

kevinc
Posts: 4
Joined: Mon Dec 06, 2021 5:33 am

Re: Does the patientNotes PUT endpoint allow setting the `Service` column of the `patientnote` table?

Post by kevinc » Tue Feb 08, 2022 9:02 am

Thank you for your responses.

Quick related follow up question.

I'm looking to write information like this screenshot lays out and I see the `Procedurelogs POST` that's in beta. Is there anywhere else that makes sense and/or is available now?

Edit: screenshot link as other one was time limited, I gather: https://share.icloud.com/photos/06e1OpK ... 8yqIXQ-rqQ

Thanks.

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Does the patientNotes PUT endpoint allow setting the `Service` column of the `patientnote` table?

Post by jordansparks » Mon Feb 14, 2022 10:56 am

Hmm, I don't quite understand. I don't know how much you know about our schema, so I'll start at a very high level, and then you can reply to help me narrow in on what you are asking. Our schema is here:
https://www.opendental.com/OpenDentalDo ... on21-4.xml
The following tables might be related to your question:
procedurelog: These are procedures like fillings and crowns. They can also be no-fee codes for notes related to treatment.
commlog: These are notes related to non clinical things like phone calls.
rxpat: These are pharmacy prescriptions written to patients.
labcase: Examples would include fabrication of a crown or an ortho appliance.
Because when I look at that screenshot, I see EasyRx entries that seem to most closely resemble labcase entries in our database.
Jordan Sparks, DMD
http://www.opendental.com

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

Re: Does the patientNotes PUT endpoint allow setting the `Service` column of the `patientnote` table?

Post by SLeon » Mon Feb 21, 2022 11:36 am

This feature request has been completed.

The Service field can now be set with the PatientNotes PUT method. It is also returned as a field in the PatientNotes GET results.

This will be available in 21.4.26, which is estimated to be release later this week. For more information on this method see https://www.opendental.com/site/apipatientnotes.html.

Post Reply