Need to use API to retrieve more than one submission at a time and filtered

We have created an API, but it only allows us to grab one submission at a time and the only selection criteria we've found is by the submission ID.

We would like to grab submissions by submission date. 

Another possibility we are looking at is to pull in a report that can be filtered by date, that comes with a URL.  The closest I've been able to find is the visual report, but it seems to only provide a pdf format of the output.  Is it possible to get a text, tab delimited, excel, grid listing format?  

The other thing that would be great is if any of your grid listing reports allowed for a selection criteria on submission date.  I see they do come with a URL, just too much data.  Over the years we would have MASSIVE downloads without the ability to select by submission date.

We are will not be able to manually download files daily.  This task we are looking for is something we are able to accomplish with a forms provider that we are looking to leave.

Please advise.

Is it possible to get a text, tab delimited, excel, grid listing format?  

Unfortunately, it is not possible to filter data for the reports other than visual report. 

In order to achieve your requirement, you may check the Get Form Submissions API response 

https://api.jotform.com/docs/#form-id-submissions 

There are few filter options available with this API response that might help. You may click on 'Show Optional Fields' link to show the options available. Please give it a try and let us know if you need any further assistance. 

Thanks!

It looks like that will work!! Thank you!!!!