Getting Sensor Data Into the Systems That Need It
Collecting sensor data is only half the job. The other half is making that data available to the systems that act on it — IMD billing platforms, energy management tools, SCADA systems and supervisory dashboards. Sensor-Online provides several export and integration paths to ensure measurement data flows where it is needed.
Export Methods in Sensor-Online
REST API
Sensor-Online’s built-in REST API provides programmatic access to all measurement data, device metadata and alarm history. Any system with HTTP capability can poll or receive data. The API is fully documented and supports both real-time polling and historical data retrieval.
MQTT Publish
For systems that prefer event-driven data delivery, Sensor-Online can publish measurement values to any MQTT broker — including Sparkplug B formatted payloads for SCADA and historian integration. This eliminates polling overhead and delivers data as soon as it arrives from the sensor.
Scheduled CSV/Excel Reports
Sensor-Online generates scheduled energy and measurement reports in CSV or Excel format, delivered by email at configured intervals. These reports are suitable for IMD billing calculations, EED compliance documentation and manual import to ERP or accounting systems.
M-Bus and IMD Platform Integration
Sensor-Online integrates directly with M-Bus master units from Elvaco, Piigab and EcoGuard, consolidating both wireless LoRaWAN sensors and wired M-Bus meters in a single platform. Data from all meter types is available through the same API and export interfaces, simplifying IMD implementations that mix metering technologies.
IMD-Specific Export
For individual metering and billing (IMD) in multi-unit residential buildings, Sensor-Online’s IMD module produces per-apartment consumption summaries at configurable billing periods. The output format is compatible with common Swedish property management systems and can be customised to match specific billing platform requirements.
Supported meter types for IMD export: LoRaWAN electricity meters (MID-approved), M-Bus heat meters, pulse-count water meters and HAN/P1-port smart meter adapters.
Node-RED and n8n Integration
For more complex data transformation workflows, Sensor-Online’s API integrates seamlessly with Node-RED and n8n. These no-code automation tools allow you to route measurement data to virtually any destination — databases, ERP systems, notification platforms, spreadsheets — with visual flow-based configuration.
FAQ: Data Export from Sensor-Online
In what formats can I export historical data?
Sensor-Online supports CSV, Excel and JSON export through the platform interface. API-based export delivers JSON. Custom formats can be achieved through Node-RED or n8n transformation workflows.
How far back does historical data go?
Data retention in Sensor-Online depends on your subscription tier. Standard SaaS deployments retain multiple years of measurement history. On-premises deployments have no enforced retention limit beyond available storage.
Can I automate the data export without manual steps?
Yes. The REST API and MQTT output both support fully automated, unattended data delivery. Scheduled reports can be configured to run and deliver automatically with no user interaction.
Read more about data processing in Sensor-Online or visit B2B pricing for subscription details.
