I have the following scenario
Client Site colleciton
Job Site 1
Document Library X
Document of Content Type X.docx
Job Site 2
Document Library X
---nodocumenthere---
We have 20,000 site collections, and 9000 job sites.
With the search api, I can run a query easily to return all results I need.
I was thinking on implementing this with a visual webpart and use Datatables:http://www.datatables.net/examples/basic_init/zero_configuration.html
The problem is that as far as I know the REST api returns only 500 rows, and this cant be overwritten.
I also need to be able to export the entire dataset to excel, so users can process it offline and then it seems with datatables library it would be more difficult.
What would be your suggestions