POST Query Timeout Issue
Posted: Thu Oct 12, 2023 7:59 am
Hi all,
We have a need to export a large amount of claim data from Open Dental. To accomplish this, we're using the Queries POST API endpoint. One problem we're having, is that, although the query executes under the timeout of 60 seconds, the API holds on to the request until the file upload to the SFTP server is also completed. This is causing us an issue because, we can't know or anticipate how much time the server might need to package the query results into a file and upload that file to us. Even in the most ideal situation for some of our clients this could go beyond 60 seconds (some clients have a slower internet bandwidth), but if there is ever an unusual delay, even rarely (such as unusually slow network speeds) the call will surely prove to be unreliable at best.
We're already dividing the query into chunks, but we worry that picking a chunk size that both never encounters a timeout like this and also doesn't divide the requested data into too small of a size isn't possible. Is there an API setting that will allow these requests to be released as soon as the client server successfully receives it and then do the packaging and uploading of the file in its own time? There's no reason for our requests to wait for that entire process to finish since we're not getting the response from the query directly anyway. If that's not an option, is there something else we can do while still using the public OD API?
Thank you
We have a need to export a large amount of claim data from Open Dental. To accomplish this, we're using the Queries POST API endpoint. One problem we're having, is that, although the query executes under the timeout of 60 seconds, the API holds on to the request until the file upload to the SFTP server is also completed. This is causing us an issue because, we can't know or anticipate how much time the server might need to package the query results into a file and upload that file to us. Even in the most ideal situation for some of our clients this could go beyond 60 seconds (some clients have a slower internet bandwidth), but if there is ever an unusual delay, even rarely (such as unusually slow network speeds) the call will surely prove to be unreliable at best.
We're already dividing the query into chunks, but we worry that picking a chunk size that both never encounters a timeout like this and also doesn't divide the requested data into too small of a size isn't possible. Is there an API setting that will allow these requests to be released as soon as the client server successfully receives it and then do the packaging and uploading of the file in its own time? There's no reason for our requests to wait for that entire process to finish since we're not getting the response from the query directly anyway. If that's not an option, is there something else we can do while still using the public OD API?
Thank you