Rest Api Query filter

Question

I am trying to query data from my List and it working properly using rest api, but when I tried using filter in my uri against a column that is a checkbox no results showed

https://mySharepoint/sites/subsite/_api/web/lists/GetByTitle('MainList')/Items?$select=Title&$filter=(CheckboxColumn eq 'Africa')

What's the problem ?

Answer 1

Hi @developer sp1 ,

Try to filter checkbox column like this:

/_api/web/lists/getbyTitle('List1')/items?$select=Title,TestCheckBox&$filter=(TestCheckBox eq 'Test1')  

---

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.