Method Community

Seny posted the following question:

Can I update a field of type DropDown to null?
It seems the query will fail by passing empty string or 'null' to the MethodAPIUpdateV2.
Can somebody help me out?
 
Thanks

Can anybody give me an answer?

Hi Seny,

We are currently investigating this issue and we will respond as soon as we will find a solution to this problem.

Thank you,
Victor

Dear Seny,

It turned out that when you've tried to update the dropdown list column with a null value, it was trying to find a corresponding null value in the parent table field. A repair was done to MethodAPI, and now, when you use a MethodAPIUpdateV2 method and try to update a dropdown column with an empty string or a null value, it will simply clear current value from the dropdown field.

Thank you
Victor

Thanks for your reply, and now it is working.

Meanwhile, I have another question, since it is similar to this, I will just post it here.

How can I update a field of type DateTime to a null value?

I am sure you could do similar thing as you did for the drop down list.

Thanks.

Dear Seny,

We've looked into the issue of MethodAPIUpdateV2 failing to update DateTime fields with null values, we've appled a fix and the problem should now be resolved.

Thank you
Victor

You guys are awsome. It works now. Thanks a lot.