Null and Empty values

In the following table we have listed all "null" and "reset" value for each data type exposed by CaaS OData endpoint.

  • Null
    It is used to represent a non-value that didn't change. When null is passed, OData will not parse the value and not keep it into consideration.
    If the value is required passing null will cause a Validation Error.
  • Reset
    It is used to reset a value in the Datastore to null/empty.
    Each Data Type accept a specific value to be used which get parsed by OData and translated it "reset the value to its default/null value".

NET Data Type Null Reset
System.String null "0x09"
System.Guid null 00000000-0000-0000-0000-000000000000
System.Int (int16, int32, int64) null 0x80000000
System.Double null 1.7976931348623157E+308
System.Single (a.k.a. float) null 3.402823e38
System.Decimal null -79,228,162,514,264,337,593,543,950,335
System.DateTime null 1/1/0001

  $expand

This section is not up to date yet, please come back later.

  $filter

This section is not up to date yet, please come back later.

  $select

This section is not up to date yet, please come back later.