You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to set date field to NULL and get it accepted on POST or PATCH

Received Response
29
Views
3
Comments
edited Mar 11, 2019 5:53PM in Integrations and APIs 3 comments

Summary

Tried datevariable = NULL, datevariable = NULL DATE - any other suggestions?

Content

We are passing customer information into Oracle Service Cloud.

Date fields may or may not be set depending on how far the user progressed. Other null fields are OK, just dates or times are the problem.

They are set on the database as isNullable but we can't find exactly the right syntax to set them to Null. Can anyone advise?

A back resort is to set them to some date date/time in 1970 but that won't really help the stats. An empty date should be empty.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!