1

This question already has an answer here:

I have tried below URL for filter using Author column in list in REST API.

siteURL/_api/web/lists/GetByTitle('ABC')/Items?select=*&$filter=AuthorId%20eq%201

but it doesnt work in OnPremise. It works as expected in SharePoint Online.Please provide solution if anyone have.

marked as duplicate by Eric Alexander Jan 19 '17 at 15:12

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • try using $expand=Author and then $filter=Author\AuthorId – dsouzajoel22 Jan 19 '17 at 13:09
4

If you expand the field Author, you can filter it. Example:

$filter=Author/Id eq 18&$expand=Author&$select=Author/Id,Title

Greetings

is it possible without select parameter ? No, it's not, when you expand a field you must provide the select with the output fields.

  • One is happy to be of service :) – Marco Jan 19 '17 at 14:24

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