Here is the request:


When I make a request without the filter, I get all this data just fine including the StoreRegion, but select, filter, etc always result in expression not valid.

Any ideas where to start troubleshooting? Worth mentioning even things as trivial as $top=5 will not work.


Try using:



_api/web/Lists/GetByTitle('StoreClosures')/Items?$select=StoreRegion&$filter=<you  filter>

The issue is the missing ? before the filter identifying the filter as a query parameter.

  • Yeah I did end up doing something like this in the end. Is this seriously the recommended route, though? That's so messy and involved.
    – CodeSpent
    Jan 25 '19 at 1:06
  • 1
    Notice that the "?" is missing in your api request. Check the demos Jan 25 '19 at 1:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.