Python script backfill data from Web API

[Clearscada_EIT]

Hi 

I'm currently using Python script to pull data from a Web API, very similar to the python Example here
https://github.com/GeoSCADA/Utilities-and-Examples/blob/main/PythonSamples/WeatherToGeoSCADA.py

If Geoscada loses connection to the Web API, for a long period of time, is there anyway to backfill these data to point historic in Geoscada, providing the historical data is available in the Web API

Thanks 

[sbeadle · Accepted solution]

Yes, all you need to do it set a timestamp property and then the value for each pair of time/values. (You can also add a quality value). The data must be processed in timestamp order.

Just set the quality, timestamp and value like this:

quality = 192 # Good
sampletime = datetime.now() # This is now, but could be any time after the last sample time
samplevalue = 3.14159265358979
connection.set_properties( P.id, [
            ("PresetQuality", Variant(VariantType.I4, quality)),
            ("PresetTimestamp", Variant(VariantType.Date, sampletime)),
            ("CurrentValue", Variant(VariantType.R8, samplevalue))
        ] )

Note that by using this method all values will be processed for alarm limits.

An alternative method is to use the history methods to load samples/times. This is quicker because you can (1) do it for multiple times/samples in one call, and (2) no alarms are processed.