@tomatopi there is going to be 2 major parts to your solution:
A. Setting up the HTTP Retriever data source and points into a single request that gets the data into the desired points.
B. Retaining the history on the existing points so that new history is appended to it.
I'll focus on B here:
- You could try modifying the points via the JSON import/export to move them onto a single data source.
- The general idea here is that if it is possible to reconfigure the points you would need to ensure that the
seriesId
in the database doesn't change. So use the XIDs to move the points and not create new ones.
- You could create an entirely new set of points and migrate existing data into them.
- There are NoSQL tools in Mango for migrating data which you would need to explore.
- You could create an entirely new set of points and then before you start them for the first time changing the series ID for them to point to the existing data.
- This would be done after you setup the new points by a Filestore Javascript.
All of this information hinges on the fact that you are on at least Mango 4. It can probably be done in Mango 3 but we didn't have the seriesId
concept so the solution would be different. In Mango 3 the time series data is directly linked to the data point's id
column in the database. In Mango 4 we added a column called seriesId
to the dataPoints
table to allows us to move the time series data between points if we needed to.
The caveat here is that you can only move data between points that have the same data type. For example Numeric time series can only be assigned to other Numeric points, not a Binary point.