I have SharePoint online list which has more than 5000 records. I am trying to fetch the data using Rest API and have used 2 User and Groups columns in the filter.

When I try this it says

'The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator'

I have used top = 100. but no luck. Can any help me on this?

I have written my query below please check it.

NOTE: List view threshold is 5000

Thanks in advance.

  • So, are you facing any issue related to retrieve number of items? Or Are you facing any issue to retrieve user data? – Prashant Shah Apr 19 '18 at 7:55
  • I am facing issue with filter if filter has more than one field – Jack Apr 19 '18 at 9:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.