I have a list in SP 2010 from which a Java program fetches data using a REST query.
http://sharepointfarm/sites/testsite/_vti_bin/listdata.svc/OurList?$select=Id,Title
The XML response currently shows the below error, even after using a select
query.
<message>
The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.
</message>
<type>Microsoft.SharePoint.SPQueryThrottledException</type>
This article mentions the select parameter does not restrict the ViewFields on the server.
Is there any way out to fetch the data into Java? Can we split the query to avoid the ThresholdException?
We need to fetch all records in the list.