Time Series Insights <-> Iot Hub Connection - Using DeviceId as Time Series ID

KileD951 126

Hello,

I am looking to use Time Series Insights to accept data from an IoT Hub, with the time series ID set to the deviceId that is embedded in IoT Hub events (not present in the JSON message body).

I've tried several ways of encoding this key when specifying the time series ID, attempting to follow the JSON flattening rules. I have tried all of these below, but I still end up seeing the device as 'null' in TSI Explorer.

deviceId
connectionDeviceId
IoTHub.connectionDeviceId
SystemProperties.connectionDeviceId (this is what comes back when using the API to read the data files from blob storage)
$event.SystemProperties.connectionDeviceId

I have perused all the documentation on this topic and it seems the most basic use case for connecting these two services is not specified. Perhaps I've missed something.

Thank you.

António Sérgio Azevedo 7,671 Reputation points Microsoft Employee

2021-05-17T14:38:52.907+00:00

Hello @KileD951 I am sorry that you are not finding it easy to accomplish your scenario.

Please can you share what document you followed where the outcome wasn't the expected?

For example you tried this one?: Add an IoT hub event source to your Azure Time Series Insight environment

Thank you!
KileD951 126 Reputation points

2021-05-17T14:49:19.267+00:00

Hello @António Sérgio Azevedo . I asked a very specific question. What is the way to get the IoT Hub deviceID to be the Time Series ID? I have read all of the relevant docs and none of them reference this detail.

Can you please answer my specific question?
António Sérgio Azevedo 7,671 Reputation points Microsoft Employee

2021-05-17T15:06:30.567+00:00

@KileD951 I am researching on that, thanks for your time in advance. Please confirm if you are using Gen1 or Gen2 ?

Thanks
KileD951 126 Reputation points

2021-05-17T15:49:03.707+00:00

Thank you. I am using Gen 2.
KileD951 126 Reputation points

2021-05-24T13:50:50.713+00:00

Hi again. Do you have any update? I can't possibly be alone on this. It would seem that this is how many people would like to configure their time series environment.

Accepted answer

António Sérgio Azevedo 7,671 Reputation points Microsoft Employee

2021-05-26T22:26:45.38+00:00
Hello @KileD951 ,
I have confirmed that you would need to use iothub-connection-device-id as TSI ID like documented here:

Tutorial: Set up an Azure Time Series Insights Gen2 environment

Please share with us your feedback to improve documentation.
Thank you so much!

Remember:

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.
Please sign in to rate this answer.
KileD951 126 Reputation points

2021-05-27T13:19:37.623+00:00

That worked, thank you. I find it interesting that the format does not align with the JSON flattening rules in the TSI documentation. But it worked, so thanks again.
https://learn.microsoft.com/en-us/azure/time-series-insights/concepts-json-flattening-escaping-rules

António Sérgio Azevedo 7,671 Reputation points Microsoft Employee

2021-05-28T15:53:21.38+00:00

Thanks for confirming @KileD951 I will provide your feeebdack to Product Group. Please can I kindly ask you mark the above as the answer?

Happy coding!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Time Series Insights <-> Iot Hub Connection - Using DeviceId as Time Series ID

0 additional answers

Your answer