Documentation: meter_events_ts

This table is deprecated and should not be used for imports

Time Series data of events processed from meters_ts
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
Row Name Type Mapping Example

manufacturer *

Manufacturer of the device

  • * required
string

A2EI

serial_number *

Serial of the device

  • * required
string

ABC/123

start_at *

time the event started

  • * required
datetime

2021-05-03 6:23:55

end_at *

time the event ended

  • * required
datetime

2021-05-03 8:11:21

category *

type of event

  • * required
string

cooking

device_uid

organization_id + manufacturer + serial_number; FK from meters table

  • auto-generated
string

1_a2ei_ABC123

duration_sec

time the event was lasting rounded to seconds

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

 integer

32443

energy_start_wh

energy value at start time in watt-hour

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

 float

1646.5

energy_end_wh

energy value at end time in watt-hour

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

 float

1758.9

energy_consumed_wh

energy value used for the event watt-hour

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

 float

112.4

created_at

Timestamp when row was inserted

  • auto-generated
datetime

2021-05-03 6:23:55

updated_at

Timestamp when row was updated

  • auto-generated
datetime

2021-05-03 6:23:55

source_id

References Source of data

  • auto-generated
integer

1

organization_id

References Organization of data

  • auto-generated
integer

1

custom

Saves additional imported data out of standard structure

  • auto-generated
jsonb

{ "some": "key" }

data_origin

Origin of the data, generic or name of the api

  • auto-generated
string

generic