Page 1 of 1

GET multiple appointments pagesize and offset

Posted: Tue Aug 10, 2021 12:33 pm
by jarkkok
Hello,

I have couple questions about Getting multiple appointments:

-What is the maximum limit of number of appointments returned (can I ask for instance 30,000 records at once, or all there is at once)?
-Can we ask to get me the next 100 appointments from a certain offset?
-Is there are maximum date range when querying with or without DateTStamp?

Thank you

Re: GET multiple appointments pagesize and offset

Posted: Tue Aug 10, 2021 1:21 pm
by SLeon
For your first two questions, the API utilizes paging to return large result sets. See the Pagination section in our documentation for details. https://www.opendental.com/resources/OpenDentalAPI.pdf. There is a maximum limit of 100 results, but you can specify an offset.

API methods that include DateTStamp are written to be as inclusive as possible. Take for example GET /appointments. If a date isn't specified at all, then all appointments will be returned. Refining your search using DateTStamp will only return appointments that were last changed at or after that date and time. Our documentation defines other date parameters for GET /appointments that provide further search flexibility.

Re: GET multiple appointments pagesize and offset

Posted: Tue Aug 10, 2021 1:40 pm
by jarkkok
Thank you, that explains. I missed the Pagination section in the document.