Sharepoint Search REST query filter with special characters

Question

I have a requirement to get all records where Status = Expired and Contract Renewability ='Yes (Auto Renew)' i tried below query but it does not bring any results. Can someone suggest what am i missing?

https://xxxx.sharepoint.com/sites/scr/_api/search/query?QueryText=%27scStatusOWSCHCS=Expired+scContractRenewabilityOWSCHCS=Yes%20%28Auto%20Renew%29%27&selectproperties=%27Title,scContractRenewability,SPWebUrl,OriginalPath,ListItemID,ModifiedBy%27&rowlimit=500

Answer 1

You can try to wrap the part containing special characters with double-quotes.

https://xxxx.sharepoint.com/sites/scr/_api/search/query?QueryText='scStatusOWSCHCS=Expired scContractRenewabilityOWSCHCS="Yes (Auto Renew)"'&selectproperties='Title,scContractRenewability,SPWebUrl,OriginalPath,ListItemID,ModifiedBy'&rowlimit=500  

I create a Contract Renewability column in my list.
My test result:

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thank you so much ! enclosing in double quotes worked !!