Today I got the unexpected error, and the reason, is that soap APIs is based on view(default or specified). By referencing soap APIs, i mean group of APIs like this: https://msdn.microsoft.com/en-us/library/lists.lists.getlistitems%28v=office.12%29.aspx
The specific problem is:
query error soap:Server with code 0x80070024: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.
it's because the list is too huge it has exceeded the limit set by the admin(which is 9000). however, i have query clause for this, so if it applies, it won't return more than 80 items.
So is there any work around or solution to this, i.e. query or modify items directly to the data itself, like COM, instead of going through the view?