People search query shows invalid refinementfilters

Question

I want to get all the peoples whose PreferredName contains "Tar".

I have written a search query for this search

/_api/search/query?querytext='*'&selectproperties='PreferredName,OriginalPath,WorkEmail,SipAddress,Department,Path,PictureURL,JobTitle,AccountName,BaseOfficeLocation,'&sourceid='b09a7990-05ea-4af9-81ef-edfab16c4e31'&refinementfilters='substringof("Tar", PreferredName)'

but it shows an error message "Bad Request" and tells refinementFilter is invalid. what is the error in this query??

Answer 1

You can use it as below:

/_api/search/query?querytext='*'&selectproperties='PreferredName,OriginalPath,WorkEmail,SipAddress,Department,Path,PictureURL,JobTitle,AccountName,BaseOfficeLocation,'&sourceid='b09a7990-05ea-4af9-81ef-edfab16c4e31'&refinementfilters='PreferredName:("Tar*")'

looks like substring or contains is not supported in refinement filters

Answer 2

You can use filter=substringof('Tar', PreferredName) to find names containing the string "Tar".

Your query will be:

/_api/search/query?querytext='*'&selectproperties='PreferredName,OriginalPath,WorkEmail,SipAddress,Department,Path,PictureURL,JobTitle,AccountName,BaseOfficeLocation,'&sourceid='b09a7990-05ea-4af9-81ef-edfab16c4e31'&filter='substringof("Tar", PreferredName)'

Read More: Filter Expressions

Answer 3

You can try using "tar"

/_api/search/query?querytext='*'&selectproperties='PreferredName,OriginalPath,WorkEmail,SipAddress,Department,Path,PictureURL,JobTitle,AccountName,BaseOfficeLocation,'&sourceid='b09a7990-05ea-4af9-81ef-edfab16c4e31'&refinementfilters='PreferredName:("*Tar*")'