search

Azure / azure-sdk-for-c

This repository is for active development of the Azure SDK for Embedded C. For consumers of the SDK we recommend visiting our versioned developer docs at https://azure.github.io/azure-sdk-for-c.
MIT License
219 stars 115 forks source link

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

Open electro89 opened 3 months ago

electro89 commented 3 months ago

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 commented 3 months ago

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[bot] commented 3 months ago

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[bot] commented 3 months ago

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 commented 2 months ago

@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.