Documentation: meters_ts

This table is deprecated and should not be used for imports

Time Series data of individual meters
To import data in this format you can use our API. -> API Documentation
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
You can also supply us with files in xlsx, csv or json format. -> Example CSV
Required Type p14n Blurred Autogenerated Mapping Example

manufacturer

Manufacturer of the device

 ✓ string ⤫ ⤫ ⤫ installations_ts => manufacturer

A2EI

serial_number

Serial of the device

 ✓ string ⤫ ⤫ ⤫ installations_ts => serial_number

ABC/123

metered_at

time the metrics apply to (not time of query)

 ✓ datetime ⤫ ⤫ ⤫ installations_ts => metered_at

2021-05-03 6:23:55

device_uid

organization_id + manufacturer + serial_number; FK from meters table

 ⤫ string ⤫ ⤫ ✓ installations_ts => device_uid

1_a2ei_ABC123

phase

1,2,3; default: 1

 ⤫ enum: 1, 2, 3 ⤫ ⤫ ⤫ installations_ts => ac_input_phase

1

voltage_v

voltage in volts

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => output_voltage_v

164.65

power_factor

ratio of working power to the apparent power, value between from 0 and 1

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => custom

0.45

power_w

power in watts

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => output_power_w

1489.6

energy_lifetime_wh

cumulative energy reading in watt-hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => output_energy_cumulative_wh

12473.02

energy_interval_wh

energy consumption at time interval in watt-hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => output_energy_interval_wh

51.04

frequency_hz

frequency in hertz

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => output_frequency_hz

58.93

current_a

current in ampere

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ float ⤫ ⤫ ⤫ installations_ts => output_current_a

22.61

interval_seconds

for remotely monitored systems, interval between measurements

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

 ⤫ integer ⤫ ⤫ ⤫ installations_ts => interval_seconds

360

billing_cycle_start_at

timestamp on which the tariff cycle starts

 ⤫ datetime ⤫ ⤫ ⤫ installations_ts => custom

2021-04-05

created_at

Timestamp when row was inserted

 ⤫ datetime ⤫ ⤫ ✓

2021-05-03 6:23:55

updated_at

Timestamp when row was updated

 ⤫ datetime ⤫ ⤫ ✓

2021-05-03 6:23:55

source_id

References Source of data

 ⤫ integer ⤫ ⤫ ✓

1

import_id

References Import of data

 ⤫ integer ⤫ ⤫ ✓

1

organization_id

References Organization of data

 ⤫ integer ⤫ ⤫ ✓

1

custom

Saves additional imported data out of standard structure

 ⤫ jsonb ⤫ ⤫ ✓

{ "some": "key" }

data_origin

Origin of the data, generic or name of the api

 ⤫ string ⤫ ⤫ ✓

generic