Documentation: installations_ts

Time Series data of individual devices

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	Example
metered_at time the metric was measured (not time of query)	✓	datetime	⤫	⤫	⤫	2022-01-01T13:00:00.000+00:00
serial_number Serial of the installed device	✓	string	⤫	⤫	⤫	SHS/123
manufacturer The manufacturer of the device	✓	string	⤫	⤫	⤫	Mobisol
uid device_uid + metered_at	⤫	string	⤫	⤫	✓	a2ei-grid01_2022-01-01T13:00:00.000+00:00
device_uid organization_id + manufacturer + serial_number	⤫	string	⤫	⤫	✓	a2ei-grid01
interval_seconds The interval between measurements in seconds Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	3600
output_energy_interval_wh The energy consumption in the specified time interval, system to customer (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	123.456
output_energy_cumulative_wh The cumulative energy consumption, system to customer (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	123.456
output_power_w The power output of the device in Watts (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	1489.6
output_voltage_v The voltage output of the device in Volts (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	164.65
output_current_a The current output of the device in Ampere (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	22.61
output_frequency_hz The frequency of the device in Hertz (Hz) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	58.93
ac_input_energy_interval_wh The AC input into the system in the specified time interval, ex. grid input (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	123.456
ac_input_energy_cumulative_wh The cumulative AC input into the system, ex. grid input (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	123.456
ac_input_power_w The electrical power consumed by the device from the AC supply (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	1489.6
ac_input_voltage_v The voltage level of the alternating current (AC) being supplied to the device (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	164.65
ac_input_current_a The amount of alternating current (AC) being drawn by the device (in amperes (A)) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	22.61
ac_input_frequency_hz The frequency (Hz), of the alternating current (AC) supplied Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	58.93
ac_input_phase For cases where a meter only has one phase the value is 1, if a meter has three phases this field is filled with 1,2,3; "sum" will be used for aggregates of all phases	⤫	enum: 1, 2, 3	⤫	⤫	⤫	2
dc_input_energy_interval_wh The DC input into the system in the specified time interval, ex. from a solar panel (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	123.456
dc_input_energy_cumulative_wh The cumulative energy input into the system from the DC source(s), ex. from a solar panel (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	123.456
dc_input_power_w The power input reading in watts (W) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	1489.6
dc_input_voltage_v The voltage input reading in volts (V) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	164.65
dc_input_current_a The current input reading in ampere (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	22.61
battery_energy_charged_interval_wh The energy production in battery in time interval (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	123.456
battery_energy_charged_cumulative_wh The cumulative energy charged in battery (in Watt-hour) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	12473.02
battery_energy_discharged_interval_wh The amount of energy discharged over a specific time interval (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	14.5
battery_energy_discharged_cumulative_wh The cumulative energy discharged from battery (Wh) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	14.5
battery_power_io_w The battery input / output in watts (>0 = charging) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	-37.58
battery_voltage_v The battery voltage in volts Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	23.6
battery_current_io_a The input or output current flowing into or out of the battery (A) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	10.1
battery_state_of_charge_percent The battery charge level in percentage Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	76.8
battery_temperature_celsius The battery temperature in celsius Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	float	⤫	⤫	⤫	76.8
paygo_account_status active, completed, defaulted, cancelled, locked, returned	⤫	string	⤫	⤫	⤫	active
paygo_unlocked_until The date the paygo account will be locked	⤫	datetime	⤫	⤫	⤫	2022-01-01T00:03:00.585+00:00
paygo_days_left The days left until next payment (only used until system is paid off) Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.	⤫	integer	⤫	⤫	⤫	7
is_locked No energy coming through, locked due to missing payments	⤫	boolean	⤫	⤫	⤫	FALSE
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
last_import_id Id of the last import which updated the record	⤫	integer	⤫	⤫	✓	337
last_source_id Id of the last Source which updated the record	⤫	integer	⤫	⤫	✓	33