ShortQuery help
Posted: Mon Jan 31, 2022 8:54 am
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://api.opendental.com/api/v1/queries/ShortQuery
We are doing this for the BODY:
{
"SqlCommand": "SELECT count(*) FROM Patients"
}
It does not seem to be a user permissions issue because our GET requests are working. There was another post where ShortQueries weren't working because of an outdated version - our OD version is 21.3 so we don't think that is the issue either. Any advice on what to check?
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://api.opendental.com/api/v1/queries/ShortQuery
We are doing this for the BODY:
{
"SqlCommand": "SELECT count(*) FROM Patients"
}
It does not seem to be a user permissions issue because our GET requests are working. There was another post where ShortQueries weren't working because of an outdated version - our OD version is 21.3 so we don't think that is the issue either. Any advice on what to check?