I need to fetch the User details from SiteUsers Rest API using Email on the basis of filter. Value passed in email would be dynamic value coming from another API and value of email will be in LowerCase and Email value from Data coming from SiteUsers will be in the form of both uppercase and lowercase. So we should apply filters so that we can match both the values coming from the Data and from the dynamic value as well. Filter is case sensitive in Rest API. What will be the exact API for filtering Email so that we can get the filtered data.

1 Answer 1


Yes, in Rest API, filter is case sensitive when filtering site users based on email.

A workaround is use ListData.svc to filter UserInformation List, this way will ignore case sensitive:

/_vti_bin/listdata.svc/UserInformationList?$filter=WorkEmail eq '[email protected]'

enter image description here

  • Thanks for the reply. I tried it works May 27, 2020 at 15:27
  • Hi Gaurav, Glad to hear it's working for you. You can accept this reply as answer.
    – Jerry
    May 27, 2020 at 15:44
  • @GauravKumar, could you please Accept the reply as answer to close this case ? Thanks :)
    – Jerry
    May 28, 2020 at 9:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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