I received raw data in iot central and I want to export it as a csv file. Blob seems to have this feature, but I haven't figured out exactly how to do it.

PAN, FEILING (PGR) 40 Reputation points
2023-07-18T22:35:26.2233333+00:00

Sorry I'm not very familiar with Blob, thank you very much for all your help

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,436 questions
Azure IoT Central
Azure IoT Central
An Azure hosted internet of things (IoT) application platform.
347 questions
Accepted answer
  1. Dom 1,551 Reputation points Microsoft Employee
    2023-07-20T10:24:53.78+00:00

    Hi,

    If you export telemetry data to a Blob from IoT Central, the exported output is JSON (not CSV) with the structure described here: https://learn.microsoft.com/en-us/azure/iot-central/core/howto-export-to-blob-storage?tabs=connection-string%2Cjavascript#telemetry-format.

    All the IoT Central export destinations (Blob Storage, Service Bus, Event Hubs, webhook) receive JSON (not CSV).

    One option to consider, is to export to an Azure Function (by using a webhook to invoke an HTTP Trigger) and using the Azure Function to convert from JSON to CSV.

    Alternatively, you could convert the JSON to CSV as part of an export process from Blob Storage to wherever you need the CSV data.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest