NetX TimeSeries History
The NetX TimeSeries History table stores the high frequency (SCADA) measurement data for each tag registered in the NetX TimeSeries ConfigurationNetX TimeSeries Configuration table. The unique constraint is (tag + timestamp) - posting a point with an existing timestamp for the same tag UPSERTS (overwrites) the previous value.
The TimeSeries Configuration for a tag must exist before history can be added to it. History is identified by the equipment sourceId and the tag sourceId.
Variable | Data Type | Is Nullable? | Description |
|---|---|---|---|
timestamp | DateTimeOffset | No | Timestamp of the measurement. Datetime offset (with timezone) in ISO 8601 format. Example: 2022-09-27T16:28:37+0000 |
value | Double | No | Measured value, in the unit of measure declared on the tag's configuration |
The platform also maintains first and last boundary values on each configuration - the timestamp and value of the oldest and newest stored point for the tag. These are updated automatically by the history ingest and are available when querying configurations.
Data Integrity Checks
Condition | Response |
|---|---|
Tag configuration does not exist | Record Rejected |
Duplicate (tag + timestamp) | Record Upserted |
Deleting a time series configuration CASCADE DELETES all of its history.
Common Error Messages
API | Scenario | Error Response |
|---|---|---|
Add history | Unknown tag | TimeSeries with sourceEquipmentId: "xxx" and sourceId: "xxx" was not found |
Fetch history | Missing or invalid ids | TimeSeries with sourceEquipmentId "xxx" and sourceId "xxx" does not exist |