Trying to query all boards for specific Status column values

monday Apps & Developers
, , ,
1

I am trying to get all tasks that have the “Status” column set to a specific value.

–
payload = {“query”: “{items_by_column_values(board_id: 226020274, column_id:"Status", column_value:"Done"){id name column_values{id value}}}”}

    r = requests.post(url_api, json=payload, headers=headers)

    print (r.text)

–
gets me :
{“data”:{“items_by_column_values”:},“account_id”:XXXXXX}

Where am i going wrong ? I am sure that the board id exists (tried with all my board_ids) and that the status column is that exact name

2

HI @djpsantos! Thanks for posting this! Happy to help! I see that your column_id has a capital “S” in “Status” can you try running the query with lowercase “status”? If that doesn’t work can you double check the column ID for this status label on this specific board ID?

I believe this is case sensitive since I was able to replicate this on my end. Look forward to hearing from you! Cheers! Laura