locked
ASA job outputs json format error Blob storage RRS feed

  • Question

  • I am collecting messages from IoT hub and outputting it to blob storage through ASA job.

    But ASA job doesn't add a parenthesis ']' character to the end of each json corresponding to starting '[' character.

    This causes a document read error in Power BI while importing blob data.

    I will really appreciate any help.

    Thanks,

    Mitesh



    Saturday, April 16, 2016 8:38 PM

Answers

  • Hi Mitesh,

    There is known issue that this may happen upon stopping the job (either manually or by our system). One possible workaround is to change the output configuration to specify "Line Separated" as the JSON format.

    Thanks,
    Kati


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, May 4, 2016 5:41 PM

All replies

  • Hi Mitesh,

    I'm sorry you are encountering an issue. Would it be possible for you to share the query and sample of the output blob?

    Thanks,
    Kati


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, April 19, 2016 10:36 PM
  • Hi Kati,

    My ASA query is "Select * into sampleoutput from sampleinput".

    And my blob output is -

    [
      {
        "Time": "4/15/2016 4:34:34 PM",
        "SensorName": "S1",
        "Temperature": 28.8125,
        "Humidity": -2.1089494163424125,
        "EventProcessedUtcTime": "2016-04-15T16:34:36.0683384Z",
        "PartitionId": 0,
        "EventEnqueuedUtcTime": "2016-04-15T16:34:36.7590000Z",
        "IoTHub": {
          "MessageId": null,
          "CorrelationId": null,
          "ConnectionDeviceId": "Sensor",
          "ConnectionDeviceGenerationId": "635962683822958726",
          "EnqueuedTime": "0001-01-01T00:00:00.0000000",
          "StreamId": null
        }
      },
      {
        "Time": "4/15/2016 4:34:52 PM",
        "SensorName": "S2",
        "Temperature": 28.9375,
        "Humidity": -2.1089494163424125,
        "EventProcessedUtcTime": "2016-04-15T16:34:52.7792133Z",
        "PartitionId": 0,
        "EventEnqueuedUtcTime": "2016-04-15T16:34:53.4870000Z",
        "IoTHub": {
          "MessageId": null,
          "CorrelationId": null,
          "ConnectionDeviceId": "Sensor",
          "ConnectionDeviceGenerationId": "635962683822958726",
          "EnqueuedTime": "0001-01-01T00:00:00.0000000",
          "StreamId": null
        }
      }

    As you can see the json array is started with '[' but is not ended witha corresponding ']' character which is causing the Power BI an error to read.

    Thanks,

    Mitesh

    Monday, April 25, 2016 6:11 PM
  • Hi Mitesh,

    There is known issue that this may happen upon stopping the job (either manually or by our system). One possible workaround is to change the output configuration to specify "Line Separated" as the JSON format.

    Thanks,
    Kati


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, May 4, 2016 5:41 PM
  • Has this issue been resolved ever, it is still happening wether you like separate the output or store as an array
    Friday, December 23, 2016 2:49 PM