Add timeseries by Postman

[Franz]

Watching the forum i tried a json method to modify an asset field.
For example:

[
  {
    "ref": {
      "id": "68k1gpNuppd8an7hNSerA5",
      "name": "power"
    },
    "value": "10"
  },
  {
    "ref": {
      "id": "68k1gpNuppd8an7hNSerA5",
      "name": "power"
    },
    "value": "20"
  }
]

but i always have the last value. May i add a timestamp to create a sequence values about “power” field ? (or another measurement field)
Thanks
Francesco DG

[Rich]

Hi,

Which API endpoint are you trying to PUT that data to?

There is currently no HTTP endpoint for uploading historical datapoints for a given attribute; you will have to do this directly on the DB using psql as described in this post:

Import historical data points

Hi, I am new to this forum, finding a lot of good resources and sharing! I am deploying an OR3 to monitor a few solar power generator sites, and have set up some charts in insight to see the trend. Previously we had 2 years’ of daily power generation history and they are stored in a csv. Does anyone know if there is a way I can import them into OR so I can see them in the chart as well? Many thanks in advanced! Jeffrey

[Franz]

ok but is expected only active data source? Is there a passive endpoint where can i send data collections on a specific asset?
Thanks

[Rich]

Historical attribute/sensor data is stored in the asset_datapoint table; the HTTP API for this currently only retrieves data; as mentioned the linked forum post gives details about how to import historical data directly into this table so it is then available for the history charts.