Why does the "Download CSV" on the Panther Search page export only 1000 results? How can I export the whole set of results?
The search functionality on our platform is optimized for efficiency, which means there are certain limitations in place.
If you wish to download the whole set of results you can use the workflows below:
Note: Data Explorer has a configured result size limit of 100MB. If your results exceed 100MB, please refer to this article for possible workarounds:📄 How to resolve Panther Data Explorer error "Result size exceeded configured limit"
Downloading Full Results Using Data Explorer
Perform your desired search on the Search page.
On the Search page, click on the Copy as SQL option. This action copies the SQL query generated by your search.
Open the Data Explorer.
Paste the copied SQL query into the query editor in Data Explorer.
Remove any LIMIT 999 statements from the SQL query.Â
Execute the modified query in Data Explorer to retrieve the complete set of results.
Click the "Download CSV" button.
If you see a limitation on the exported CSV size, you can limit the time window of your query to include fewer results or you can use the Panther API as described below.
Downloading Full Results Using Panther API
Perform your desired search on the Search page.
On the Search page, click on the Copy as SQL option. This action copies the SQL query generated by your search.
Remove any LIMIT 999 statements from the SQL query.Â
Execute your API calls, that will run your query following the steps on our Panther API documentation.