Filter with NULL value using REST API in SharePoint
$filter=FIeldName ne null
url: _spPageContextInfo.webAbsoluteUrl+"/_api/Web/Lists/GetByTitle('Products')/Items?$select=Name,Price,Size&$filter=Size ne null",
The above URL returns the items not having Size field value as Null.
ne - Not Equal
url: _spPageContextInfo.webAbsoluteUrl+"/_api/Web/Lists/GetByTitle('Products')/Items?$select=Name,Price,Size&$filter=Size ne null",
The above URL returns the items not having Size field value as Null.
ne - Not Equal
Comments
Post a Comment