NetX TimeSeries History

the netx timeseries history table stores the high frequency (scada) measurement data for each tag registered in the netx timeseries configuration docid\ fe26orxao pioronb2dgt 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