Understanding your data export (CSV and API)

Data Export & API - Electricity

Overview

This reference article describes all metrics available through the data export (CSV) and API. Metrics are divided into two categories:

Universal metrics — returned for all electric devices, including current sensors and power meters.
Power meter metrics — returned exclusively for power meter devices, providing extended electrical measurements.

Tip: If a column appears in your export but shows NULL values, verify that your device is a power meter and that the relevant measurement is supported by your hardware configuration.

Universal Metrics

The following metrics are returned for all electric devices in both CSV exports and API responses.

Column Name	Description
external_id	A unique identifier assigned to the selected asset. Used to reference the device in external systems and integrations.
asset_name	The name of the asset as configured in the platform.
Customer	The name of the customer site the asset belongs to.
time_zone	The time zone in which the asset is located. See here for a full list of supported time zone identifiers and their descriptions.
measured_at	The timestamp of the measurement in local time (based on the asset's configured time zone).
utc_time	The timestamp of the measurement in Coordinated Universal Time (UTC).
power	Measured active power. This field always contains a value — if no measurement was received from the device, it defaults to 0. For current sensors, this is a calculated value derived from the measured current, the configured power factor, and the configured voltage. For power meters, this value is measured directly by the device.
energy	Calculated energy. Derived directly from the measured or calculated power value over time.

Power Meter Metrics

The following metrics are only returned for power meter devices. They will not appear in exports from current sensors. Some fields may contain NULL values if a specific measurement type is not supported by the connected hardware.

Column Name	Description
active_power_total	Measured active power. Equivalent to the power field, except it shows missing values (NULLs) when no measurement was received from the device.
apparent_power_total	Measured apparent power. Represents the total power flowing in the circuit, including both active and reactive components.
reactive_power_total	Measured reactive power. Represents the portion of power that does not perform useful work.
current_l1	Measured current on phase 1 (L1).
current_l2	Measured current on phase 2 (L2).
current_l3	Measured current on phase 3 (L3).
current_n	Measured neutral current.
current_total	The equivalent three-phase line current. Calculated as: apparent_power_total ÷ (√3 × voltage_ll_average).
power_factor_total	Measured power factor (range -1 to 1). Represents the ratio of active power to apparent power. A value of 1 or -1 indicates a purely resistive load; values closer to 0 indicate a lower proportion of reactive power.
voltage_average	Average line-to-neutral voltage across all phases.
voltage_l1_l2	Measured line-to-line voltage between phase 1 (L1) and phase 2 (L2).
voltage_l1_n	Measured line-to-neutral voltage on phase 1 (L1).
voltage_l2_l3	Measured line-to-line voltage between phase 2 (L2) and phase 3 (L3).
voltage_l2_n	Measured line-to-neutral voltage on phase 2 (L2).
voltage_l3_l1	Measured line-to-line voltage between phase 3 (L3) and phase 1 (L1).
voltage_l3_n	Measured line-to-neutral voltage on phase 3 (L3).
voltage_ll_average	Average line-to-line voltage across all phase pairs.

Additional Notes

NULL vs. Zero Values

There is an important distinction between the power and active_power_total fields:

power will always contain a numeric value. Missing measurements are represented as 0.
active_power_total may contain NULL when no measurement was received, allowing you to distinguish between a genuine zero reading and a missing data point.

Current Sensors vs. Power Meters

Some metrics are calculated differently depending on the device type:

Current sensors calculate power indirectly using the measured current combined with the configured voltage and power factor.
Power meters measure active power directly and provide a richer set of electrical measurements, including per-phase voltages, currents, and power factor.

Energy Calculation

The energy field is derived from the power field using time-based integration. It reflects the cumulative energy consumption over the measurement interval.