I am using Sharepoint 2013 Online.
I have the following code using the /_vti_bin/lists.asmx web service
XmlDocument camlDocument = new XmlDocument(); XmlNode camlNode = camlDocument.CreateElement("Query"); StringBuilder sb = new StringBuilder(); sb.Append("<Where>"); sb.AppendFormat("<Eq>"); sb.AppendFormat("<FieldRef Name='Individual' />"); sb.AppendFormat("<Value Type='Lookup'>John Doe</Value>"); sb.AppendFormat("</Eq>"); sb.Append("</Where>"); camlNode.InnerXml = sb.ToString(); int rowlimit = 2000; XmlNode items = myService.GetListItems("Documents", null, camlNode, null, rowlimit.ToString(), null, null);
and when I run it I am getting the following error message:
The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.0x80070024
The list Documents has 50,000 records. However there is only 90 that have a record that has the individuals name John Doe.
It should be able to return the 90 records? Or can I not query any list that has more than 5000 records?