Filter SharePoint list using Rest API

Question

There is a SharePoint list with a lookup column. Now I want to search the SharePoint list with filter on lookup column. E.g. :

https://sharepoint.com/sites/sitename/_api/web/lists/GetByTitle('listname')/items?$expand=lookupcolumn&$select=Title,parentlookupcol/lookupcolumn&$filter=substringof('US2017 - 0002',lookupcolumn) 

Syntax filter = lookupcolumn eq 'value' is working, but I want to filter the list even if I pass part of the string.

Please share an example of how I can achieve this.

Thanks in advance usha

Answer 1

isn't the problem that you are filtering by the lookupcolumn value and not the lookup column Title?

you'll have to expand the lookupcolumn and apply the filter to the text field

Expanding columns in lookup fields