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:
Or even this:
"1234", " "
And still the field refuses to change! What is the expected field value to set a date to null?!
Could someone please help.
NULL does not need to be quoted.
All fields in a CSV are text (it's a text format).
is no different from
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.
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,
Marketo uses -- and has always used -- the 4-character string NULL to represent the empty value in many places, including in forms and flows.