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 at 1:06
  • 1
    Notice that the "?" is missing in your api request. Check the demos – JoannaW_MSFT Jan 25 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.