Retrieve timeseries data on hourly avergage

Question

I am calling this api https://test.env.timeseries.azure.com/timeseries/query?api-version=2020-07-31 to retrieve the series of data and the body is provided below

{
"getSeries": {
"timeSeriesId": [
"<testtimeseriesid>"
],
"searchSpan": {
"from": "2020-08-01T00:00:00Z",
"to": "2020-11-23T00:16:50Z"
}
,
"filter": null,
"inlineVariables": {
"temperatures": {
"kind": "numeric",
"value": {
"tsx": "$event.temperature"
},
"filter": null,
"aggregation": {
"tsx": "avg($value)"
}
}
},
"projectedVariables": [
"temperatures"
]
}
}

Above query returns the data but not in hourly aggregated format. How can I retrieve the average hourly data from timeseries insights?

Answer 1

Hello @Harish did you check the following doc: Time Series Query (TSQ) APIs ?

"Aggregate Series API: Enables query and retrieval of aggregated values and the associated interval timestamps by applying calculations defined by variables on raw events. These variables can be defined in either the Time Series Model or provided inline in the query. This API supports pagination to retrieve the complete response dataset for the selected input."

Thank you.