Can Reports be pulled through API Web Services in OD ?

This forum is for programmers who have questions about the source code.
Post Reply
gopichand
Posts: 4
Joined: Mon Mar 27, 2017 11:19 am

Can Reports be pulled through API Web Services in OD ?

Post by gopichand » Mon Jul 10, 2017 2:29 pm

Through FHIR service in Open Dental we query and pull details like patients details, available time slots, appointment status Via Restful web services.

"In the same way can pull the reports from the OD server namely production and income reports ?"

Are there such possibilities to do so?
Are there any third party software which will suffice the requirement?

I would like to pull reports of 30 clinics data at one place.

Please give your inputs on this . What could possible solution for this?

Thanks
Gopi Chand

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Can Reports be pulled through API Web Services in OD ?

Post by cmcgehee » Mon Jul 10, 2017 5:48 pm

The FHIR API is not capable of pulling reports.

There are a couple ways you could run reports for clinics that are on different servers:

Option 1: CEMT. If the only report that you desire to run is the Production and Income Report, you can set up Central Enterprise Management Tool to connect to your different databases and run the report. The advantage here is that you can set it up sooner for no additional charge.
http://opendental.com/manual/cemtprodincreport.html

Option 2: Excel query. If you want to run a custom report on several databases, you can request that we write an Excel query. The advantage with this option is that you have almost infinite flexibility with what type of report you can run. There is a $90/hour fee if you would like us to write an Excel query for you.
http://opendental.com/manual/queryexcel.html
http://opendentalsoft.com:1942/ODQueryR ... tForm.aspx
Chris McGehee
Open Dental Software
http://www.opendental.com

Post Reply