Page 1 of 1

getting Reports thru the API

Posted: Mon Feb 06, 2023 7:26 am
by flaviokihbba
Hello Open Dental team,
I would like to know if it's possible to access the information generated on a report pre-built using the API.

We are looking to grab data that is provided on the reports in the Open Dental software, I would like to know if it's possible to grab that data in an API Call using this report, or should we do individual calls to multiple endpoints and try to generate and build that data.

Re: getting Reports thru the API

Posted: Mon Feb 06, 2023 8:43 am
by SLeon
Good morning,

The API has a Reports resource which currently has two methods: Reports GET Aging and Reports GET FinanceCharges. They return data identically as two of the reports available within the Open Dental software. If there additional reports you are interested in, request them here and we can discuss adding them to our development list.

However, making individual calls to multiple endpoints is a also valid workflow depending on your implementation. Doing so would allow you to fully customize the data you retrieve, both in terms of specificity and scope. It is also worth noting that reports in Open Dental typically lack the primary keys of most tables used to build the final dataset. If your application intends to link data from a report to other objects (such as procedures, etc) you may prefer to use individual method calls/queries.