Method:API Q&A

Re: Update a dropdown field to Null

seny — Wed, 25 Aug 2010 16:44:18 GMT

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

Re: Update a dropdown field to Null

Method_Victor — Tue, 24 Aug 2010 14:42:50 GMT

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

Re: Update a dropdown field to Null

seny — Tue, 24 Aug 2010 00:16:47 GMT

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.

Re: Update a dropdown field to Null

Method_Victor — Mon, 23 Aug 2010 18:39:47 GMT

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

Re: Update a dropdown field to Null

Method_Victor — Fri, 20 Aug 2010 20:27:14 GMT

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

Re: Update a dropdown field to Null

seny — Fri, 20 Aug 2010 16:21:45 GMT

Can anybody give me an answer?

Update a dropdown field to Null

Anonymous — Fri, 20 Aug 2010 13:43:09 GMT

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