GET request has maximum length limit configured in the web.config. It is 260 characters I guess. So it is the reason you can not make more than 35 filters.
So now you can consider POST and CAML. Make a CAML Query like following. field1 and field2 are considered in the following query. Do not forget to include others.
var query = "<View> " +
" <Query> " +
" <Where> " +
" <Or> " +
" <Eq> " +
" <FieldRef Name=\"field1\" /> " +
" <Value Type=\"Integer\"> " +
" <UserID Type=\"Integer\" /> " +
" </Value> " +
" </Eq> " +
" <Eq> " +
" <FieldRef Name=\"field2\" /> " +
" <Value Type=\"Integer\"> " +
" <UserID Type=\"Integer\" /> " +
" </Value> " +
" </Eq> " +
" </Or> " +
" </Where> " +
" </Query> " +
"</View> "
Request Body
var data = {
query: {
__metadata: {
'type': 'SP.CamlQuery'
},
ViewXml: query
}
};
Now make a POST request to the following URL. I hope it will serve your purpose.
"/_api/web/lists/getbytitle('Global Contact List')/getitems";
Following things may help you to build CAML
- U2U Caml Query Builder
- Building CAML for querying List in SharePoint