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?