How do I get the most recent good value at a point in time from Time Series Insights?

Richard Bailey 21 Reputation points
2021-09-28T05:42:45.813+00:00

I cannot find a reliable way to retrieve the most recent good value prior to a given timestamp via the TSI API without recursing the entire history of each point. It looks like the getEvents, getSeries, and getAggregateSeries only ever process data INSIDE the searchSpan, so if you need to find the value prior to a timestamp, you need to put a huge span in place. Since these methods only ever return the first 10k (or 250k) samples ordered from the beginning of the search span, there is no easy way to find the most recent value without progressively recursing back in history until you find a sample.

Is there a way to do this using the various aggregate, boundary, and take: 1 options which doesn't need me to search the entire history of the series?

Azure Time Series Insights
Azure Time Series Insights
An Azure internet of things (IoT) analytics platform to monitor, analyze, and visualize industrial IoT analytics data at scale.
74 questions
{count} votes

Accepted answer
  1. AshokPeddakotla-MSFT 27,126 Reputation points
    2021-10-05T11:44:29.44+00:00

    @Richard Bailey Apologies for taking too long on this. Currently we don't support this feature.

    Also, We would like to inform you that, We have shared this feedback with our Time Series Insights product team and it has been considered for feature request. Please let us know if you have any further queries.

    ------------------------------

    Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

    0 comments No comments

0 additional answers

Sort by: Most helpful