Documentation: meter_events_ts
This table is deprecated and should not be used for imports
Rate limit: 300 requests per minute. Once the limit is exceeded, any further requests will result in a 429 (Too Many Requests) response.
Required | Type | p14n | Blurred | Autogenerated | Mapping | Example | |
---|---|---|---|---|---|---|---|
manufacturer Manufacturer of the device |
✓ | string | ⤫ | ⤫ | ⤫ |
A2EI |
|
serial_number Serial of the device |
✓ | string | ⤫ | ⤫ | ⤫ |
ABC/123 |
|
start_at time the event started |
✓ | datetime | ⤫ | ⤫ | ⤫ |
2021-05-03 6:23:55 |
|
end_at time the event ended |
✓ | datetime | ⤫ | ⤫ | ⤫ |
2021-05-03 8:11:21 |
|
category type of event |
✓ | string | ⤫ | ⤫ | ⤫ |
cooking |
|
device_uid organization_id + manufacturer + serial_number; FK from meters table |
⤫ | 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 |
⤫ | 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 |
|
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 |