How to empty a date field with bulkUpdateCreate api

Hi,

Just want to confirm first if you are using bulkUpdateCreate instead of bulkCreateUpdate?

Regards,

Orchid

In your csv make the value of date fields empty and try checking the "Treat empty spreadsheet cells as NULL values for updated records" checkbox when creating the import map. See image below

Hope this may help.

Regards,
Orchid

Yeah your right it is bulkCreateUpdate, my mistake.

Hello Orchid,

Looks like that option is only working for the import and that the option is not an attribute of the importmap. When i import the csv this option it works fine when i use the same import map for bulkCreateUpdate it doesn't work.

Regards,

Wilco.

I see, I didn't notice it because I created the import located in the UI, not in the object definition.

I will confirm first if this is really an expected behavior.

Regards,

Orchid

Hi Wilco,

I just confirmed that the functionality "Treat empty spreadsheet cells as NULL values for updated records" isn't available when you create data map from object definition, this is only available when doing import from UI.

I find this as a good enhancement to Rollbase so that when we use the data MAP with REST or SOAP we can utilize this functionality. You can file it in our ideas page Ideas Page.

I am thinking if you can create an Update Field trigger to clear the date field, something like the code below:

var dateBefore  = "{!Date_Issued#before}";
var dateNew		= "{!Date_Issued}";
if( rbv_api.isImport() && (dateBefore == dateNew) ) {
  return "";	//clear date field
}

Hope this may help.

Regards,
Orchid

Hi Wilco,

Can you confirm if the workaround works for you?

Regards,
Orchid