title: Partial data loss in JSON deserialization between IoT Hub and ASA Input
body: <blockquote>
  <p>Setup is: <strong>IoT Hub &gt; input into &gt; Stream Analytics</strong></p>
  </blockquote>
  <p>I currently have (3) sensors and an azure gateway from ncd.io which are all reporting great into Azure IoT Hub.</p>
  <p>Only two elements the record data from my sensors are making it through the auto JSON deserialization when setting up an IoT Hub input in ASA.</p>
  <p>I have a device setup in IoT Hub which reports the correct <strong>Device Twin</strong> data from my local gateway as follows:</p>
  <pre><code>&quot;reported&quot;: {
      &quot;nodes&quot;: {
        &quot;SN0013A20041DADDF7&quot;: {
          &quot;firmware_version&quot;: 10,
          &quot;transmission_count&quot;: 192,
          &quot;reserve_byte&quot;: 0,
          &quot;battery_level&quot;: 3.29406,
          &quot;type&quot;: 1,
          &quot;node_id&quot;: 0,
          &quot;rssi&quot;: 100,
          &quot;humidity&quot;: 27.93,
          &quot;temperature&quot;: 22.28
        },
        &quot;SN0013A20041DADD51&quot;: {
          &quot;firmware_version&quot;: 10,
          &quot;transmission_count&quot;: 175,
          &quot;reserve_byte&quot;: 0,
          &quot;battery_level&quot;: 3.29406,
          &quot;type&quot;: 1,
          &quot;node_id&quot;: 0,
          &quot;rssi&quot;: 100,
          &quot;humidity&quot;: 42.25,
          &quot;temperature&quot;: 22.55
        },
        &quot;SN0013A20041DADE33&quot;: {
          &quot;firmware_version&quot;: 10,
          &quot;transmission_count&quot;: 217,
          &quot;reserve_byte&quot;: 0,
          &quot;battery_level&quot;: 3.29406,
          &quot;type&quot;: 1,
          &quot;node_id&quot;: 0,
          &quot;rssi&quot;: 100,
          &quot;humidity&quot;: 39.33,
          &quot;temperature&quot;: 22.62
        }
      },
  </code></pre>
  <p>I setup the input in ASA from my IoT Hub as JSON with no compression. The result in ASA looks great, but first position 'node' <em>seems to be excluded from the result</em>.</p>
  <pre><code> [
    {
      &quot;nodes&quot;: {
        &quot;SN0013A20041DADE33&quot;: {
          &quot;firmware_version&quot;: 10,
          &quot;transmission_count&quot;: 164,
          &quot;reserve_byte&quot;: 0,
          &quot;battery_level&quot;: 3.29406,
          &quot;type&quot;: 1,
          &quot;node_id&quot;: 0,
          &quot;rssi&quot;: 100,
          &quot;humidity&quot;: 39.01,
          &quot;temperature&quot;: 23.08
        }
      },
      &quot;EventProcessedUtcTime&quot;: &quot;2022-05-02T20:39:23.3568635Z&quot;,
      &quot;PartitionId&quot;: 3,
      &quot;EventEnqueuedUtcTime&quot;: &quot;2022-05-02T19:55:43.2820000Z&quot;,
      &quot;IoTHub&quot;: {
        &quot;MessageId&quot;: null,
        &quot;CorrelationId&quot;: null,
        &quot;ConnectionDeviceId&quot;: &quot;***&quot;,
        &quot;ConnectionDeviceGenerationId&quot;: &quot;***&quot;,
        &quot;EnqueuedTime&quot;: &quot;2022-05-02T19:55:43.1570000Z&quot;
      }
    },
    {
      &quot;nodes&quot;: {
        &quot;SN0013A20041DADD51&quot;: {
          &quot;firmware_version&quot;: 10,
          &quot;transmission_count&quot;: 122,
          &quot;reserve_byte&quot;: 0,
          &quot;battery_level&quot;: 3.29406,
          &quot;type&quot;: 1,
          &quot;node_id&quot;: 0,
          &quot;rssi&quot;: 100,
          &quot;humidity&quot;: 42.09,
          &quot;temperature&quot;: 22.62
        }
      },
      &quot;EventProcessedUtcTime&quot;: &quot;2022-05-02T20:39:23.3568635Z&quot;,
      &quot;PartitionId&quot;: 3,
      &quot;EventEnqueuedUtcTime&quot;: &quot;2022-05-02T19:55:40.8290000Z&quot;,
      &quot;IoTHub&quot;: {
        &quot;MessageId&quot;: null,
        &quot;CorrelationId&quot;: null,
        &quot;ConnectionDeviceId&quot;: &quot;***&quot;,
        &quot;ConnectionDeviceGenerationId&quot;: &quot;***&quot;,
        &quot;EnqueuedTime&quot;: &quot;2022-05-02T19:55:40.8130000Z&quot;
      }
    },
    {
      &quot;nodes&quot;: {
        &quot;SN0013A20041DADE33&quot;: {
          &quot;firmware_version&quot;: 10,
          &quot;transmission_count&quot;: 163,
          &quot;reserve_byte&quot;: 0,
          &quot;battery_level&quot;: 3.29406,
          &quot;type&quot;: 1,
          &quot;node_id&quot;: 0,
          &quot;rssi&quot;: 100,
          &quot;humidity&quot;: 38.9,
          &quot;temperature&quot;: 23.14
        }
      },
      &quot;EventProcessedUtcTime&quot;: &quot;2022-05-02T20:39:23.3568635Z&quot;,
      &quot;PartitionId&quot;: 3,
      &quot;EventEnqueuedUtcTime&quot;: &quot;2022-05-02T19:55:03.7180000Z&quot;,
      &quot;IoTHub&quot;: {
        &quot;MessageId&quot;: null,
        &quot;CorrelationId&quot;: null,
        &quot;ConnectionDeviceId&quot;: &quot;***&quot;,
        &quot;ConnectionDeviceGenerationId&quot;: &quot;***&quot;,
        &quot;EnqueuedTime&quot;: &quot;2022-05-02T19:55:03.6710000Z&quot;
      }
    },
    {
      &quot;nodes&quot;: {
        &quot;SN0013A20041DADD51&quot;: {
          &quot;firmware_version&quot;: 10,
          &quot;transmission_count&quot;: 121,
          &quot;reserve_byte&quot;: 0,
          &quot;battery_level&quot;: 3.29406,
          &quot;type&quot;: 1,
          &quot;node_id&quot;: 0,
          &quot;rssi&quot;: 100,
          &quot;humidity&quot;: 42.22,
          &quot;temperature&quot;: 22.65
        }
      },
  </code></pre>
  <p>There are really no options I can find to adjust this as it is all part of a single record... I can query the data I do receive and output it no problem.</p>
  <p><a href="https://i.stack.imgur.com/MMkCG.png" rel="nofollow noreferrer">Example output in ASA</a></p>
  <p><a href="https://i.stack.imgur.com/zZLlt.png" rel="nofollow noreferrer">Reference of the issue</a></p>