Rest Api Query filter

developer sp1 461 Reputation points
2020-12-09T07:38:40.5+00:00

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 ?

Microsoft 365 and Office SharePoint Server Development
0 comments No comments
{count} votes

Accepted answer
  1. ZhengyuGuo 10,586 Reputation points Moderator
    2020-12-10T08:25:57.71+00:00

    Hi @developer sp1 ,

    Try to filter checkbox column like this:

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

    46835-snipaste-2020-12-10-16-25-24.png


    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.