CODEWITHSUNDEEP
mappingazure-iot-hubazure-data-explorer
Ruudjah
Ruudjah

Reputation: 847

Map custom properties when ingesting IoT hub into ADX

I have the following setup: an IoT Hub ih1 routing messages to Azure Data Explorer adx1. Messages on the IoT hub look like the following:

{
  "body": {
    { "value": "myValue" }
  },
  "messageId": "deadbeef-1234-5678-9abc-0123456789ab",
  "properties": {
    "myCustomProperty": "myCustomValue"
  }
}

(There are more root properties and more custom properties, but the above outline should be clear).

I want to map the custom properties of the IoT Hub message onto a table column. So far, I've only been able to map the system properties and the body property content (in above example: "value": "myValue") to a column.

Using the $.propertyName will only refer to properties within the body property, not on properties on the root of the message.

How can I map custom properties to a column?

Upvotes: 1

Views: 351

Answers (2)

Vladik Branevich
Vladik Branevich

Reputation: 1175

Payload enrichment for IoT Hubs and Event Hubs in ADX is currently not fully implemented and is limited to system properties only. Full support is on the backlog but we have no ETA at the present time.

Upvotes: 0

René
René

Reputation: 151

Currently this is not implemented in ADX. As a workaround you can route messages to en Event Hub and then to ADX. Then you should be able to access that properties.

Upvotes: 1

Related Questions