Open Dental

Is any way to insert Benefits line item add from API

For clarification, you would like to add Benefits similar to the the form seen on this page? https://opendental.com/manual/benefitinforowview.html

Through API NOT on form page
I want use the API

I understand you are wanting to utilize the API and we are happy to create an API method for you to do so. I would like to clarify which benefit fields you are requesting us to include in this new method.

The form I linked above allows setting the Category, ProcCode, Type, Percent, Amount, Time Period, Quantity/Qualifier, and Coverage Level. Would you like us to include all of these fields from the form?

This form also allows for the Editing and Deletion of these Benefit line items. Do you also need API methods to mimic this form behavior?

Yes update all

Great! Thank you for confirming this. I have added this to our development list. I will update this thread once it is complete.

Any excepted Time line and also confirm me is any way I am use my insert sql commands through API?

Any excepted Time line and also confirm me is any way I am use my insert sql commands through API?

There are two API feature requests above Benefits POST on our development list. I would expect implementation on this to start within the next week.

No, you cannot run insert SQL commands directly through the API. See the documentation for the Queries resources https://www.opendental.com/site/apiqueries.html:

Queries are screened to be read-only. Temporary tables are allowed. Any command that would change the database will not be run.

A new method, Benefits POST, has been added. With this method, you can insert a new benefit line item into an existing Insurance Plan or Patient Plan via the API. For more information, see https://www.opendental.com/site/apibenefits.html

This method is available as of beta version 22.3.17.