Skip to main content
Panther Knowledge Base

Why does the "Download CSV" on the Panther Search page export only 1000 results? How can I export the whole set of results?

  1. Last updated
  2. Save as PDF

QUESTION

Why does the "Download CSV" on the Panther Search page export only 1000 results? How can I export the whole set of results?

ANSWER

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:

Downloading Full Results Using Data Explorer

  1. Perform your desired search on the Search page.
  2. On the Search page, click on the Copy as SQL option. This action copies the SQL query generated by your search.
  3. Open the Data Explorer.
  4. Paste the copied SQL query into the query editor in Data Explorer.
  5. Remove any LIMIT 999 statements from the SQL query. 
  6. Execute the modified query in Data Explorer to retrieve the complete set of results.
  7. 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

  1. Perform your desired search on the Search page.
  2. On the Search page, click on the Copy as SQL option. This action copies the SQL query generated by your search.
  3. Remove any LIMIT 999 statements from the SQL query. 
  4. Execute your API calls, that will run your query following the steps on our Panther API documentation.