I have site in Sharepoint Online, with a list which has more than 80.000 items and growing. It’s requeride a report with filters (at least one), so I use a rest request. Example:

var url = _spPageContextInfo.webAbsoluteUrl + “/_api/web/lists/getbytitle(‘ResultadosConsolidados’)/items?$ select=ID&$ filter=Periodo eq ‘Julio 2017’&$ top=100”;

The column ‘Periodo’ is already indexed. Error: The attempted operation is prohibited because it exceeds list view threshold enforced by administrator

I know the theory about the limitations in architecture in Sharepoint Online, but is there other option for this goal ? I thinks is incredible Sharepoint doesn’t allow you to filter with more than 5000 items.

Some people say: Depurate the items in some lists, but I can’t modify the information in the list.

Any idea?

Thanks so much.