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


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

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

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

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


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

| improve this answer | |
  • 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.