TimeSeries History

the timeseries history table stores the historic values of the tags registered in timeseries configuration docid\ pvnxfcacsh2sgha 9zogj every reading is numeric the unique constraint on this table is sourcewellid + sourcetimeseriesid + timestamp re posting an existing timestamp for the same tag upserts (overwrites) the previous value, and if a payload carries the same point twice, one row is written timeseries configuration for a given sourcetimeseriesid must be added to the system before attempting to add timeseries history to that sourcetimeseriesid variable data type is nullable? description sourcewellid string no source id for the well from wellview wvwellheader table, idwell column from openwells cd well table, well id column sourcetimeseriesid string no time series tag identifier, which must already exist in timeseries configuration docid\ pvnxfcacsh2sgha 9zogj osi pi use tag id xxx yyy zzz osi pi af use attributeid \\\server\\\element\\\attributeid timestamp datetime offset no timestamp of the reading datetime offset (with timezone) in iso 8601 format example 2022 09 27t16 28 37 +0000 value double no the numeric value of the reading, in the unit of measure declared on the tag's configuration data integrity checks condition response (sourcewellid, sourcetimeseriesid) does not match a timeseries configuration row rejected sourcewellid, sourcetimeseriesid, timestamp, or value is null record rejected duplicate (tag + timestamp) record upserted partial success on bulk ingest unlike configuration upserts, history ingest does not abort the batch on bad rows all valid rows are written first; rows referencing an unknown (sourcewellid, sourcetimeseriesid) pair are then reported in the error response an error response therefore does not mean nothing was written — check the message, which states how many rows were written and which pairs were rejected common error messages api scenario error response bulk add history some rows reference unknown tags timeseries history upsert wrote n row(s) but rejected rows for m unknown (sourcewellid, sourcetimeseriesid) pair(s)