How to give dropdown an empty field on API request on Make.com?

Hi,

I’m migrating data from Google Sheets to Monday.com on make.com

How can I send to Monday when a dropdown field is empty on sheets and make it look only empty in Monday board?

image

I already tried a couple of possibility to send it empty,

image

  • null and whitepace didnt work

image

image

I can see that there can be empty fields in dropdown so it should be possible;

image

But I just cannot send an empty space like in the sheets to monday.

I saw that in this topic they talk about empty value in dropdown but it doesnt work;

They say value should be empty object;

image

I tried this one too but
image
but it looks like this now;
image

How to control this kind of empty space when sending through make for Monday?

That’s interesting. I already tried

null,
emptystring,
ignore,
“”,
" ",
{},
“{}”

What would be the solution I wonder?

Hi,

Any answers from community?

Hello @onurbolaca,

I just tried with an empty string and it worked.
Here is my mutation below:

mutation {
  change_simple_column_value (item_id: 123, board_id: 456, column_id:"dropdown", value: "") {
    id
  }
}

Not very familar with make but if you have tried "" and it doesn’t work, can you try "''"?

Hi,

Thanks @kolaai , I will check that out,

How do you make this request that you shown on code? From postman? I think this is a graphql request right?

Yes, it is GraphQL and yes, you can use Postman. For this example, I used the playground.
You can access your playground by going to /apps/playground in your account.

So say, your account domain looks like this https://abc.monday.com, you can access the playground by going to https://abc.monday.com/apps/playground

1 Like

Hello @onurbolaca,

I am not super experienced with Make either but let us know if what @kolaai suggested solves the issue, if not, we can try to think of something else.

Thanks @kolaai!

Cheers,
Matias

1 Like

Hello @onurbolaca,

I just found a way to do this:

I hope that helps!

Cheers,
Matias

1 Like

@kolaai Youre going to find out there is some oddities with this method. If you use the API call for empty string, on the web UI it will appear to clear. However, as soon as you refresh the web UI it comes back, and the API reports the old value again!

I’ve found the a reliable way is to supply an ID that doesn’t exist, so {"ids":[-1]} has consistently worked for me.

I have a meeting with the product manager for API in the AM so I will mention this one :slight_smile:

As far as within Make, they do things under the hood with the monday.com modules to handle stuff differently than the actual graphql query does. Matias’s method should work with Make.

3 Likes

Thank you for the information as usual @codyfrisch!!

1 Like

@codyfrisch It feels like the only way really is your way (using -1 as an ID) - I’ve tried the below GraphQL and it does not work after refreshing the page.

mutation {
  change_multiple_column_values(item_id: {{id}}, board_id: {{board.id}}, column_values: "{\"dropdown4\":{}, \"dropdown5\":{}, \"long_text\":\"\", \"long_text5\":\"\"}") {
    id
  }
}

Likewise with @Matias.Monday’s solution in Integromat/Make, using the “ignore” directive and then refreshing the page brings back the previous dropdown value, and the activity log shows it not being cleared.

Please let us know whenever you have any updates cody. I’m happy to have a way that finally works, but I’m worried that eventually Monday.com may change the behavior on their backend if this isn’t intentional.

Well, I am just another developer here. I just found it via trial and error that a non-existent ID would clear it, and the only IDs that will never potentially exist are negative ones.

I’m unsure what the official stance on clearing is. @OrFrid this is something I’d brought up the last time we spoke, about no official way to clear a dropdown by API. (though ID of -1 effectively works…)

1 Like

Hi @aholtzhauer,

We’ll be sure to keep you posted on any changes we make! as always, we appreciate the feedback you share with us.

Your community management and community support is really weak. I fear to ask something. No one answers on time. One of the worst community support I have ever seen.

You should consider this; people who asks for something is on a task that they need to deliver on time!

Hi @onurbolaca,

I’m sorry to hear we didn’t meet the expectation for service.

What I gathered from the above thread was that this thread was successfully resolved and multiple solutions were offered.

Would you please let me know where we went wrong so we can improve our service?

@alessandra as I told, no question I asked answered in time so far. People ask this questions inside of an operation. A community should keep up with them. That’s what makes it community.

Hi @codyfrisch!

Just wanted to update you that we recently released the ability to clear a dropdown column via the API. Check out this announcement for more info! :sunglasses:

1 Like