3

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.

4

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

CRUD Operation to List Using SharePoint 2013 Rest API

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.