Open Dental Forum

I'm looking for information about how the API handles offices that are set up with multiple locations -- in terms of filtering for appointments, patients, etc. - We have encountered several offices that share a database but our current output shows them all patients and appointments for all location...

We have experienced an issue with the PUT Request for patients when there are more than 100 results. example query: {"SqlCommand": "select p.FName from patient as p where p.LName = 'Brown'"} The Use case is searching for a patient whose last name is "Brown" - the patient does not show in the results...

Ok cool thanks for looking into this. We prefer to stick with the POST Upload method because moving to sftp would require that we change how we deal with attached files. We are finding that when moving files using POST Upload method the Date Created changes when you actually open the file. Currently...

Hm - when we test the limit is 3 million not 16 million

Any answer about this? I've searched for anything on here about a size limit for placing documents/images/etc -- it looks like it starts erroring out at about 3MB but we can't find anything that officially gives a file size limit for what can be placed using the API. Can you confirm the limit size a...

Thanks! I missed that thread when looking. I've searched for anything on here about a size limit for placing documents/images/etc -- it looks like it starts erroring out at about 3MB but we can't find anything that officially gives a file size limit for what can be placed using the API. Can you conf...

Thank you! Has anyone experienced two document items being created when importing? We tried both methods below - and both created one listing with the date and description - but when you click on it, it creates a second listing that is the actual file. How do we keep it one listing? Documents POST U...

We are working with the Document API and had some questions we couldn't find answers. 1) What is the correct way (SQL command?) to get the DocCategory ID numbers. 2) Are Category ID's the same for all Open Dental accounts? -- if we use the "Patient Information" category ID will that number be the sa...

Awesome! Very excited about the local option. Is there a release date for vs 22.1?

Thanks SLeon, the 400 BadRequest error doesn't give any additional information. Strangely, we ended up just uninstalling OD and reinstalling and now the Short Queries are working fine. So, I guess if anyone else is just getting started and having trouble with a 400 error - maybe try uninstalling and...

We are having trouble testing the ShortQueries. Our API Patient GET requests are working Our Short Query - PUT is not working. We are using a sample query provided in this page https://www.opendental.com/site/apiqueries.html and it gives the 400 BadRequest error We are doing this for PUT URL: https:...