In Azure central IoT API Query GROUP BY with local time zone feature

[electro89]

In Azure central IoT API , how to use Query to get records with WHERE 24 hour window and GROUP BY 1 hour with local time zone ? Without local time zone , it returns unwanted time ranges.

[vaavva]

Hello @electro89! Could you provide some more details on what you're using to try to accomplish this and what you've tried? What API call are you using? Are you basing this off of a sample (if so, which one)?

[github-actions]

Hi @electro89. Thank you for opening this issue and giving us the opportunity to assist. To help our team better understand your issue and the details of your scenario please provide a response to the question asked above or the information requested above. This will help us more accurately address your issue.

[github-actions]

Hi @electro89, we're sending this friendly reminder because we haven't heard back from you in 7 days. We need more information about this issue to help address it. Please be sure to give us your input. If we don't hear back from you within 14 days of this comment the issue will be automatically closed. Thank you!

[electro89]

@vaavva , Platform is Azure central IoT, and it has API Query method to get IoT telemetry data with a query. Here is the documentation https://learn.microsoft.com/en-us/azure/iot-central/core/howto-query-with-rest-api , but it always return results in UTC , I need to get 24 hour window data and they should be GROUP BY 1 hour according to the local time zone,
For example if I need to get sum of the telemetry value hourly values for a given day:
I get sum from 12:30am - 1:30am,1:30am - 2:30am, ...
But I need sum from 12:00am - 1:00am,1:00am - 2:00am, ...

Please support by giving any other documentation regarding time zone.