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.