I am trying to get data from SharePoint list using REST query and filter on some column having null values. But It can't return desired items..

 http://<Server>/_api/web/Lists(guid'2B3BD6CD-172B-4320-898F-30BA1DA0928E')/Items?$filter=CustomColumn eq null
  • Any error are u getting? your query seems okay? Sep 21, 2016 at 10:35
  • @AtishDipongkor : no error.. but also returning no data ... "results": []
    – SID
    Sep 21, 2016 at 10:58
  • For all interest users, It's sad to say that $filter does not support null as value.. and there is one work around is there.. visit this link to find answer..
    – SID
    Sep 22, 2016 at 6:47

2 Answers 2


It seems that ODATA for SharePoint REST does not support the filtering based on null.


But there ist someone with nearly the same issue here:

Checked null with dateTime in REST API SharePoint

  • Yes.. you are right.. your given link has given me solution.. and it's also true that $filter not support null..
    – SID
    Sep 22, 2016 at 6:44

I cracked this awhile ago, and had to jog my memory to remember it again. So I am replying to your question so I can find it next time. To filter by non-nulls, use greater than zero. Yes, that actually works for text fields. I don't think it worked on data fields.

?$filter=CustomColumn gt 0

I don't think I was able to do the opposite and return only records where the field is null. eq 0 or lt 1 or similar attempts returned no records at all.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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