Skip to main content

Sentinel Null Values

A sentinel null value is a special placeholder value used to represent a NULL in situations where a true NULL cannot be used or has unintended consequences. In the API in order to set data to NULL in any PUT Requests Sentinel Null Values must be used.

Below is a table of types and their associated 'Null' value.

TypeSentinel Null Value
Binary0x
Date1900-01-01
DateTime1900-01-01 00:00:00
Decimal-999999
Guid00000000-0000-0000-0000-000000000000
Integer-999999
Long-999999
String''

Null Sentinel Values are not supported for the following data types:

  • Time
  • Boolean