1

Here is the request:

https://sub.domain.com/Stores/CrisisMgmt/_api/web/Lists/GetByTitle('StoreClosures')/Items$select=StoreRegion

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.

2

Try using:

_api/web/Lists/GetByTitle('StoreClosures')/Items?$select=StoreRegion

_api/web/Lists/GetByTitle('StoreClosures')/Items?$select=StoreRegion&$top=5

_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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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