Let's say i got 4 devices connected to my IOT HUB, and the messages sent from the devices to the iot hub contains only the parameters that i'm interested to(humidity temperature). I assigned a tag to every devices, using device twin, so i can filter them. Then i have created a route that send data to a Blob storage. When i went inside the blob to see what i got, i noticed that the device twin tags are not there.; i can only see deviceId and the body message. Is there a way to send to blob storage the message and the device twin tags that the IOT HUB assigned to it? I need the tags to filter message using a query.

Hello @Masaniello , So you have tags added to your devices and set up a route to blob storage using a certain custom routing endpoint. Check out the enrichment feature in the IoT Hub: Here you can add one or more tags to your incoming messages as extra context. These will appear as application properties in the outgoing messages. If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.

How add digital twin tags to body messages of iot Devices

Accepted answer

Sander van de Velde 28,796 Reputation points MVP

2023-01-25T16:07:29.9333333+00:00

Hello @Masaniello ,

So you have tags added to your devices and set up a route to blob storage using a certain custom routing endpoint.

Check out the enrichment feature in the IoT Hub:

Here you can add one or more tags to your incoming messages as extra context.

These will appear as application properties in the outgoing messages.

If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.
Please sign in to rate this answer.

1 person found this answer helpful.
Masaniello 65 Reputation points

2023-01-26T14:34:42.4833333+00:00

Ok, really thanks.

I would ask you if you know an efficency way to do a time series for do some plots.

I think I need a NoSQL database like blob storage or cosmos for data from iot device because I don't know the column name of iot device.

Do you have any advice?

thanks.

Sander van de Velde 28,796 Reputation points MVP

2023-01-26T23:42:14.1133333+00:00

Hello @Masaniello ,

You're welcome. If the response helped, do "Accept Answer" so others with the same challenge see the answer directly!

Regarding the database question, there is no simple answer.

Blob storage is the cheapest storage but querying is a challenge.

For most of our projects, we use Azure Data Explorer. Querying is sublime but it's only cost-effective once you both store a lot of data and query a lot.

I suggest checking out CosmosDB which has a free tier. And SQL Server Databases are also interesting as long as you do not store too much data.

Masaniello 65 Reputation points

2023-01-27T08:53:53.25+00:00

I understand enrichment

But as custom endpoints I don't have what interests me:

Actually the problem is that if I select a storage then the body is base64 encoded.

I wanted to bring the normal data to the data explorer to be able to work with it better.

Do you have any tips on how to decode from base64 and then send them to data explorer?

I'm currently trying to read about the event hub.

The idea would be to send the data to the event hub with the enrichment, then decode it in the event hub and then send it to the dataexplorer. (I don't know if this pipeline is possible, I'm still studying the topics)

If you have other advice I will thank you very much, possibly you can also recommend other pipelines.

Masaniello 65 Reputation points

2023-01-27T08:54:20.3433333+00:00

I understand enrichment

But as custom endpoints I don't have what interests me:

Actually the problem is that if I select a storage then the body is base64 encoded.

I wanted to bring the normal data to the data explorer to be able to work with it better.

Do you have any tips on how to decode from base64 and then send them to data explorer?

I'm currently trying to read about the event hub.

The idea would be to send the data to the event hub with the enrichment, then decode it in the event hub and then send it to the dataexplorer. (I don't know if this pipeline is possible, I'm still studying the topics)

If you have other advice I will thank you very much, possibly you can also recommend other pipelines.

Sander van de Velde 28,796 Reputation points MVP

2023-01-27T17:06:40.7766667+00:00

Hello @Masaniello ,

do you put a JSON message in the body?

You can tell the IoT hub you are sending UTF-8 JSON:

// Set message body type and content encoding. message.ContentEncoding = "utf-8"; message.ContentType = "application/json";

Masaniello 65 Reputation points

2023-01-31T10:18:45.6966667+00:00

Yes, the body is a json, in fact if I make a connection with the stream analytics it receives the body as I wish but not the tags.

Sander van de Velde 28,796 Reputation points MVP

2023-01-31T13:54:49.23+00:00

Hello @Masaniello ,

Messages coming from the IoT Hub have a body, system properties (technical fields added by eg. the IoT Hub like the IoT Hub name), and application properties (aka user properties). If you use enrichment, eg. adding tags to the message, these tags are made available as application/user properties.

Azure Stream Analytics makes them available using the GetMetaDataPropertyValue.

There is one catch... the Azure Portal page for the Azure Stream Analytics query editor cannot show these properties! Check the ASA query outcome with other tooling (like an extra Event Hub during testing phase).
Sign in to comment

How add digital twin tags to body messages of iot Devices

0 additional answers