Loading to a date picker field - can this be empty?

Developer Support APIs & Integrations
1

Hi

We’re working on a project where we need to load data which contains a data field, this has been set up in the object as a datepicket.

At the moment i get an error message about the field being nil, is there any way to process NULL values as in our project this field will not always be populated

Thank you in advance for any help

2

@CMorris74 if you’re using a date field and importing data, you’d want it to be completely blank rather than being “nil” or “NULL” - how are you passing the information?

3

@CMorris74 for example, you could pass it as a blank value by leaving no space between the quotes:

{
 "properties": [
 {
 "property": "my_date_picker",
 "value": ""
 }
 ]
}
4

thank you, we managed to get this working, it appears like we had a formatting issue on the dates and received a false positive

5

Glad you got it working @CMorris74, happy to help!