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.