Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
English (US)
US English (US)
ES Spanish
IT Italian
  • Home
  • Using the Platform
  • Data Export

Export Jobs: Measurements Interface

Written by Omri Landman

Updated at March 1st, 2025

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Using the Platform
    Getting Started Administration Energy Applications Triggers and Notification Center Data Export Data Import Reports
  • Hardware & Deployment
    Frequently Asked Questions (FAQ) Hardware Datasheets and Deployment Guides Software Deployment Guide Troubleshooting Flow Charts
  • Interactive Demos
  • Legal
+ More

Table of Contents

Measurements CSV Measurements Example JSON Measurements Example

Once you have set up your export jobs (see Export Jobs: Setup), each job invocation will create a data file/stream. The service supports four types of data: Catalog, Measurements, Pulse Meter Measurements, and Pan42 Measurements. This guide will discuss what to expect in the Measurements export job type.

Measurements

The Measurements document data structure consists of the actual electrical readings measured by Panoramic Power sensors. (The device ID specified here is the same device ID specified in the Catalog).

Name Description
device_id The ID of an electrical device corresponding to the ID in the Catalog.
device_name The device name as assigned at installation time. 
measurement_time (UTC) The time of the measurement in the UTC time zone, in ISO 8601 format. 
resolution (minutes) The number of minutes this measurement data is relevant for. 
site_id A unique identifier of the physical site in the software, in which the device is located. 
site_name The site’s name as assigned at installation time. For example, "New York site". 
current (A) Electrical current reading
voltage (V) Electrical voltage reading
power (W) Electrical power
power_factor Electrical power factor
energy (Wh) Electrical energy

CSV Measurements Example

Below is an example of the Measurements export in a CSV format.

CSV Measurements Example.csv

JSON Measurements Example

{
 "measurements": [{
  "device_id": 1,
  "device_name": "Main Device",
  "measurement_time(UTC)": "2015-10-25T10:40:00Z",
  "resolution(minutes)": 5,
  "site_id": 11,
  "site_name": "Site 1",
  "current(A)": 1.73,
  "voltage(V)": 240.0,
  "power(W)": 394.0,
  "power_factor": 0.95,
  "energy(Wh)": 32.8
 },{
  "device_id": 1,
  "device_name": "Main Device",
  "measurement_time(UTC)": "2015-10-25T10:45:00Z",
  "resolution(minutes)": 5,
  "site_id": 11,
  "site_name": "Site 1",
  "current(A)": 1.95,
  "voltage(V)": 240.0,
  "power(W)": 412.0,
  "power_factor": 0.95,
  "energy(Wh)": 36.6
 }]
} 

Note:

 

JSON files are limited to 2,000 measurements (may be larger if zero padding is enabled) and csv files are limited to 10,000 rows (again, may be larger if zero padding is enabled).
In both cases if the job includes more measurements the file is split into multiple files. 

In the case where data is sent from the bridge with delay (due to loss of communication) and a record is based on partial measurements, an updated record will be sent.

 

 

 

metrics interface export employment

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • What is the difference between Managed Load and Real-Time Consumption on the Site Dashboard?
  • Can I configure PAN-42 sensors for a Modbus setup?
  • What languages can I view on the platform?
  • Export Jobs: Pan-42 Measurements Interface
Expand