Checked null with dateTime in REST API SharePoint

Question

I want to get all article pages which Article Date is not null. so I have try to do by this way.

var ArticlePageContentTypeID = "0x010100C568DB52D9D0A14D9B2FDCC96666E9F2007948130EC3DB064584E219954237AF3900242457EFB8B24247815D688C526CD44D";
 var url = "/_api/web/lists/getbytitle('Pages')/items?&$select=ArticleStartDate&$orderby=ArticleStartDate desc&$filter=startswith(ContentTypeId,'" + ArticlePageContentTypeID + "') and ArticleStartDate ne null";
 jQuery.ajax({
   url: url,
   type: "GET",
   headers: { "Accept": "application/json;odata=verbose" },
   success: function(){},
   error: function(){}

  });

but it does not working it. error mention that

"String was not recognized as a valid DateTime."

Please help me if you have idea.

Answer 1

Hi @sp13test ,

If you are using SharePoint 2013, then Rest OData didn't support to check null value operation, a workaround is to use CAML Query with a Post Request like this:

$.ajax({
type: "POST",
headers: {
"accept": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose",
"X-RequestDigest": $("#__REQUESTDIGEST").val()
},
url: 'http://siteurl/_api/web/Lists/GetByTitle(\'Pages\')/GetItems(query=@v1)?@v1={"ViewXml":"<View><Query><Where><IsNotNull><FieldRef Name=\'ArticleStartDate\' /></IsNotNull></Where></Query></View>"}',
success: function(data){console.log(data); },
failure: function(data){console.log(data); }
});

SharePoint REST API - CAML Query

For SharePoint 2016 and Online, currently, it has already supported with null check in endpoint directly.

Thanks
Best Regards

---

If an Answer 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.