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

monday Apps & Developers
, , ,
1

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?

2

Hi,

Any answers from community?

3

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 "''"?

4

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?

5

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
6

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
7

Hello @onurbolaca,

I just found a way to do this:

image
image904×1068 54.2 KB

I hope that helps!

Cheers,
Matias

1 Like
8

@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
9

Thank you for the information as usual @codyfrisch!!

1 Like