Skip to main content

Unable to clear dropdowns with API

  • July 6, 2022
  • 5 replies
  • 1225 views

I have tried every permutation of updating a column value: simple value of “”, json “{}” and “{“ids”:}”, json in a change_multiple_column_values, as well as “clear_all”: true.

The thing is most if not all of these appear to succeed - api appears to succeed (unless you also then query for the columns value in the mutation). The board in the browser shows the column being cleared - but as soon as you refresh the values come back. What is extra odd is once they come back, if I add another item in the dropdown the values that should have been deleted vanish, only to return on the next refresh.

There appears to be some sort of bug someplace?

5 replies

basdebruin
  • Community Expert
  • July 6, 2022

hi @anon29275264

Have you tried to use the same one as for clearing the people column?

value: "{\\"clear\\":\\"all\\"}"

  • Author
  • Participating Frequently
  • July 6, 2022

I have tried that, as well as:

value: "{ \\"clear_all\\": true }"

The weird part is that as long as I dont read back the value in the mutation - it seems to clear until the browser is refreshed. If i read back the column value with the mutation query, it doesnt appear to clear.

This is striking me more and more like a bug.


JCorrell
Forum|alt.badge.img
  • Community Expert
  • July 6, 2022

@anon29275264

This works:
.... column_values: "{\\"dropdown\\": {\\"ids\\":[-1]}}"....

I’m not completely sure it SHOULD. But it does.


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • July 7, 2022

Hello all!

Thank you for the question and the answers.

I am sharing this with the API team so that it can be reviewed 🙂

Cheers,
Matias


rachelatmonday
Forum|alt.badge.img
  • monday.com Team Member
  • February 28, 2023

We recently fixed a bug that now allows you to clear a dropdown column with the API. Check out this announcement for more info 😎