Open Dental

greg.merrill wrote: ↑

Thu Sep 22, 2022 4:46 pm

Hi Open Dental Support Team,

I have been using Queries PUT ShortQuery along with the following JSON

Code: Select all

{
  "SqlCommand": "SELECT * FROM appointmenttype"
}

in order to get all appointment types. This works great for practices with less than 100 appt types. To handle the edge case where there is more than 100, it says in the documentation(https://www.opendental.com/site/apiqueries.html) that the Offset query param should still work with these types of requests. However, when I add an ?Offset=100 to the URL using ARC, the modified request seems to ignore the Offset value entirely and sends back the original number of appointment types, whereas I would expect it to send back an empty array since I have less than 100 appointment types saved in Open Dental.

Since this will be an edge case for us most of the time, I'm hoping I can continue using the PUT method rather than switching to the POST method. Am I doing something wrong with the Offset query param to be getting this unexpected behavior?

Thanks,
Greg