Sharepoint - SharePoint Online Rest API - Filter by boolean (yes/no)

Assuming the column is a Yes/No column, and not a column with "Yes" and "No" text, the following works for me in SharePoint Online:

Returns false items:

_api/web/lists/getbytitle('TestList')/items?$select=Title,YesNoColumn&$filter=YesNoColumn eq 0

Returns true items:

_api/web/lists/getbytitle('TestList')/items?$select=Title,YesNoColumn&$filter=YesNoColumn eq 1

Neither return items with a blank value.

Using the following pattern works in our implementation:

&$filter=(Category eq 'Work Description')and (Archived eq false)

Related