I am trying to get items from custom list using REST API which lookup column is null.
how can i make filter query for this.?
Any help is highly appreciated.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityI am trying to get items from custom list using REST API which lookup column is null.
how can i make filter query for this.?
Any help is highly appreciated.
In the REST API response, Lookup column looks like following
{Internal Name of the column} + Id
Let's say lookup column name is Person
, so it will PersonId
in response. Now you can apply filter on PersonId
column.
var query = "/_api/Web/Lists/GetByTitle('List Name')/Items?$filter=PersonId eq null";
To know more about $filter
, you can follow my article