Change date field to empty, Bulk API

[Steven_French]

Hi there,

I'm currently using the Bulk Import API to upload a CSV of leads.

We have lead records with values in some custom date fields. However I cannot seem to set them to null using the bulk api.

My CSV could look like this:

id, customDateField
"1234", NULL

This:

id, customDateField
"1234", ""

Or even this:

id, customDateField
"1234", " "

And still the field refuses to change! What is the expected field value to set a date to null?!

Could someone please help.

Regards,Stevne

[SanfordWhiteman]

NULL but not with that extra space.

[Chris_Morris1]

So, like this?

"1234",NULL

I'm having the same issue - thank you!

[SanfordWhiteman]

Yes.

[Gaoan_Guo]

you should use "null" as a string 

[SanfordWhiteman]

NULL does not need to be quoted.

All fields in a CSV are text (it's a text format).

Double-quoted

  ...,"NULL",...‍‍‍

is no different from

  ...,NULL,....‍

in this context.

Quoting is used to allow fields to contain double quotes, line breaks, and/or commas, i.e. to avoid delimiter collision.

Question's already answered, anyway.

[Gaoan_Guo]

I retried several cases in my local, the time I found NULL wasn't working is in early 2019, looks marketo has fixed this problem.

it's true we can use NULL to clear the field

Also using "null"(quote or unquote no difference) is still working and can set the value to blank,

[SanfordWhiteman]

Marketo uses -- and has always used -- the 4-character string NULL to represent the empty value in many places, including in forms and flows.