REST API - Revision history

Uwe: /* Feed log */

2026-04-28T18:45:42Z

Feed log

← Older revision		Revision as of 20:45, 28 April 2026
Line 191:		Line 191:
	=== Requirements for feed feature ===		=== Requirements for feed feature ===
	==== Feed log ====		==== Feed log ====
	The API shall provide an endpoint communicating from the server to the client the feed events read from the tables <code>feed_log</code> and <code>feed_profiles</code> of either the last 24 hours or the last 7 days depending on parameter provided by the client.		The API shall provide an endpoint communicating from the server to the client the feed events read from the tables <code>feed_log</code> and <code>feed_profiles</code> of either the last 24 hours or the last 7 days or of a specific date depending on parameter provided by the client.
	The corresponding SQL query (for a period of one day) is:		The corresponding SQL query (for a period of one day) is:

Uwe: /* Refill log */

2026-04-28T18:45:21Z

Refill log

← Older revision		Revision as of 20:45, 28 April 2026
Line 520:		Line 520:
	=== Requirements for refill feature ===		=== Requirements for refill feature ===
	==== Refill log ====		==== Refill log ====
	The API shall provide an endpoint communicating from the server to the client the refill events read from the table <code>refill_log</code> of either the last 24 hours or the last 7 days depending on parameter provided by the client.		The API shall provide an endpoint communicating from the server to the client the refill events read from the table <code>refill_log</code> of either the last 24 hours or the last 7 days or of a specific date depending on parameter provided by the client.

	The corresponding SQL query (for a period of one day) is:		The corresponding SQL query (for a period of one day) is:

	<code>SELECT timestamp, duration, volume, error_code FROM refill_log WHERE timestamp > (NOW() - INTERVAL 1 DAY)</code>		<code>SELECT timestamp, duration, volume, error_code FROM refill_log WHERE timestamp > (NOW() - INTERVAL 1 DAY)</code>

			The query for specific date is:
			<code>SELECT timestamp, duration, volume, error_code FROM refill_log WHERE DATE(timestamp) = ? ORDER BY timestamp DESC</code>

	{\| class="wikitable"		{\| class="wikitable"

Uwe: /* Feed log */

2026-04-28T18:44:10Z

Feed log

← Older revision		Revision as of 20:44, 28 April 2026
Line 195:		Line 195:

	<code>SELECT fl.timestamp, fl.feeder_on_time, fp.profile_name, fl.profile_id FROM feed_log AS fl LEFT JOIN feed_profiles AS fp ON fl.profile_id = fp.profile_id WHERE timestamp > (NOW() - INTERVAL 1 DAY) ORDER BY timestamp;</code>		<code>SELECT fl.timestamp, fl.feeder_on_time, fp.profile_name, fl.profile_id FROM feed_log AS fl LEFT JOIN feed_profiles AS fp ON fl.profile_id = fp.profile_id WHERE timestamp > (NOW() - INTERVAL 1 DAY) ORDER BY timestamp;</code>

			The query for a specific date is:
			<code>SELECT fl.timestamp, fl.feeder_on_time, fl.profile_name, fl.profile_id FROM feed_log AS fl LEFT JOIN feed_profiles AS fp ON fl.profile_id = fp.profile_id WHERE DATE(fl.timestamp) = ? ORDER BY fl.timestamp DESC </code>

	{\| class="wikitable"		{\| class="wikitable"
	\|-		\|-

Uwe: /* Balling dosing log */

2026-04-28T18:41:41Z

Balling dosing log

← Older revision		Revision as of 20:41, 28 April 2026
Line 117:		Line 117:

	==== Balling dosing log ====		==== Balling dosing log ====
	The API shall provide an endpoint communicating from the server to the client the Balling dosing events read from the tables <code>balling_log</code> and <code>balling_set_vals</code> of either the last 24 hours or the last 7 days depending on parameter provided by the client.		The API shall provide an endpoint communicating from the server to the client the Balling dosing events read from the tables <code>balling_log</code> and <code>balling_set_vals</code> of either the last 24 hours or the last 7 days or of a specific date depending on parameter provided by the client.
	The corresponding SQL query (for a period of one day) is:		The corresponding SQL query (for a period of one day) is:

			For periods:
	<code>SELECT balling_log.Timestamp, balling_log.pumpid, balling_log.dosingvolume, balling_set_vals.label FROM balling_log LEFT JOIN balling_set_vals ON balling_log.pumpid=balling_set_vals.pumpid WHERE Timestamp > (NOW() - INTERVAL 1 DAY) ORDER BY Timestamp</code>		<code>SELECT balling_log.Timestamp, balling_log.pumpid, balling_log.dosingvolume, balling_set_vals.label FROM balling_log LEFT JOIN balling_set_vals ON balling_log.pumpid=balling_set_vals.pumpid WHERE Timestamp > (NOW() - INTERVAL 1 DAY) ORDER BY Timestamp</code>

			The query for a specific date is:
			<code>SELECT b.timestamp, b.pump_id, b.dosing_volume, s.label FROM balling_log AS b LEFT JOIN balling_set_vals AS s ON b.pump_id = s.pump_id WHERE DATE(b.timestamp) = ? ORDER BY b.timestamp DESC;</code>

			</code>

	{\| class="wikitable"		{\| class="wikitable"

Uwe: /* Feed profiles */

2025-12-19T08:57:02Z

Feed profiles

← Older revision		Revision as of 10:57, 19 December 2025
Line 223:		Line 223:
	!\|Signal format		!\|Signal format
	!\|Database column name		!\|Database column name
			!\|API response
	\|-		\|-
	\|\|profile id		\|\|profile id
	\|\|integer number		\|\|integer number
	\|\|feed_profiles.profile_id		\|\|feed_profiles.profile_id
			\|\|profileId
	\|-		\|-
	\|\|profile name		\|\|profile name
	\|\|string		\|\|string
	\|\|feed_profiles.profile_name		\|\|feed_profiles.profile_name
			\|\|profileName
	\|-		\|-
	\|\|pause 01 duration		\|\|pause 01 duration
	\|\|integer		\|\|integer
	\|\|feed_profiles.pause_01_duration		\|\|feed_profiles.pause_01_duration
			\|\|pause01Duration
	\|-		\|-
	\|\|pause 01 skimmer target state		\|\|pause 01 skimmer target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_01_skimmer		\|\|feed_profiles.pause_01_skimmer
			\|\|pause01Skimmer
	\|-		\|-
	\|\|pause 01 main pump #1 target state		\|\|pause 01 main pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_01_main_pump1		\|\|feed_profiles.pause_01_main_pump1
			\|\|pause01MainPump1
	\|-		\|-
	\|\|pause 01 main pump #2 target state		\|\|pause 01 main pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_01_main_pump2		\|\|feed_profiles.pause_01_main_pump2
			\|\|pause01MainPump2
	\|-		\|-
	\|\|pause 01 aux. pump #1 target state		\|\|pause 01 aux. pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_01_aux_pump1		\|\|feed_profiles.pause_01_aux_pump1
			\|\|pause01AuxPump1
	\|-		\|-
	\|\|pause 01 aux. pump #2 target state		\|\|pause 01 aux. pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_01_aux_pump2		\|\|feed_profiles.pause_01_aux_pump2
			\|\|pause01AuxPump2
	\|-		\|-
	\|\|feed 01 duration		\|\|feed 01 duration
	\|\|integer		\|\|integer
	\|\|feed_profiles.feed_01_duration		\|\|feed_profiles.feed_01_duration
			\|\|feed01Duration
	\|-		\|-
	\|\|feed 01 skimmer target state		\|\|feed 01 skimmer target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_01_skimmer		\|\|feed_profiles.feed_01_skimmer
			\|\|feed01Skimmer
	\|-		\|-
	\|\|feed 01 main pump #1 target state		\|\|feed 01 main pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_01_main_pump1		\|\|feed_profiles.feed_01_main_pump1
			\|\|feed01MainPump1
	\|-		\|-
	\|\|feed 01 main pump #2 target state		\|\|feed 01 main pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_01_main_pump2		\|\|feed_profiles.feed_01_main_pump2
			\|\|feed01MainPump2
	\|-		\|-
	\|\|feed 01 aux. pump #1 target state		\|\|feed 01 aux. pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_01_aux_pump1		\|\|feed_profiles.feed_01_aux_pump1
			\|\|feed01AuxPump1
	\|-		\|-
	\|\|feed 01 aux. pump #2 target state		\|\|feed 01 aux. pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_01_aux_pump2		\|\|feed_profiles.feed_01_aux_pump2
			\|\|feed01AuxPump2
	\|-		\|-
	\|\|...		\|\|...
Line 287:		Line 302:
	\|\|integer		\|\|integer
	\|\|feed_profiles.pause_10_duration		\|\|feed_profiles.pause_10_duration
			\|\|pause10Duration
	\|-		\|-
	\|\|pause 10 skimmer target state		\|\|pause 10 skimmer target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_10_skimmer		\|\|feed_profiles.pause_10_skimmer
			\|\|pause10Skimmer
	\|-		\|-
	\|\|pause 10 main pump #1 target state		\|\|pause 10 main pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_10_main_pump1		\|\|feed_profiles.pause_10_main_pump1
			\|\|pause10MainPump1
	\|-		\|-
	\|\|pause 10 main pump #2 target state		\|\|pause 10 main pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_10_main_pump2		\|\|feed_profiles.pause_10_main_pump2
			\|\|pause10MainPump2
	\|-		\|-
	\|\|pause 10 aux. pump #1 target state		\|\|pause 10 aux. pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_10_aux_pump1		\|\|feed_profiles.pause_10_aux_pump1
			\|\|pause10AuxPump1
	\|-		\|-
	\|\|pause 10 aux. pump #2 target state		\|\|pause 10 aux. pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_10_aux_pump2		\|\|feed_profiles.pause_10_aux_pump2
			\|\|pause10AuxPump2
	\|-		\|-
	\|\|feed 10 duration		\|\|feed 10 duration
	\|\|integer		\|\|integer
	\|\|feed_profiles.feed_10_duration		\|\|feed_profiles.feed_10_duration
			\|\|feed10Duration
	\|-		\|-
	\|\|feed 10 skimmer target state		\|\|feed 10 skimmer target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_10_skimmer		\|\|feed_profiles.feed_10_skimmer
			\|\|feed10Skimmer
	\|-		\|-
	\|\|feed 10 main pump #1 target state		\|\|feed 10 main pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_10_main_pump1		\|\|feed_profiles.feed_10_main_pump1
			\|\|feed10MainPump1
	\|-		\|-
	\|\|feed 10 main pump #2 target state		\|\|feed 10 main pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_10_main_pump2		\|\|feed_profiles.feed_10_main_pump2
			\|\|feed10MainPump2
	\|-		\|-
	\|\|feed 10 aux. pump #1 target state		\|\|feed 10 aux. pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_10_aux_pump1		\|\|feed_profiles.feed_10_aux_pump1
			\|\|feed10AuxPump1
	\|-		\|-
	\|\|feed 10 aux. pump #2 target state		\|\|feed 10 aux. pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_10_aux_pump2		\|\|feed_profiles.feed_10_aux_pump2
			\|\|feed10AuxPump2
	\|-		\|-
	\|}		\|}

Uwe: /* Requirements for overview feature */

2025-12-18T18:58:55Z

Requirements for overview feature

← Older revision		Revision as of 20:58, 18 December 2025
Line 76:		Line 76:
	\|\|/var/local/aquarium-ctrl/atlsscntfc-conduc		\|\|/var/local/aquarium-ctrl/atlsscntfc-conduc
	\|\|conductivity		\|\|conductivity
			\|-
			\|\|filtered conductivity
			\|\|floating point number
			\|\|/var/local/aquarium-ctrl/atlsscntfc-conducfltrd
			\|\|filteredConductivity
	\|-		\|-
	\|\|filtered water temperature		\|\|filtered water temperature

Uwe: /* Requirements for overview feature */

2025-12-18T18:57:16Z

Requirements for overview feature

← Older revision		Revision as of 20:57, 18 December 2025
Line 45:		Line 45:
	!\|Signal format		!\|Signal format
	!\|Signal source		!\|Signal source
			!\|API response
	\|-		\|-
	\|\|timestamp		\|\|timestamp
	\|\|string		\|\|string
	\|\|/var/local/aquarium-ctrl/aquarium-ctrl-ts		\|\|/var/local/aquarium-ctrl/aquarium-ctrl-ts
			\|\|timestamp
	\|-		\|-
	\|\|water temperature		\|\|water temperature
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-temp		\|\|/var/local/aquarium-ctrl/atlsscntfc-temp
			\|\|waterTemperature
	\|-		\|-
	\|\|filtered water temperature		\|\|filtered water temperature
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-tempfltrd		\|\|/var/local/aquarium-ctrl/atlsscntfc-tempfltrd
			\|\|filteredWaterTemperature
	\|-		\|-
	\|\|pH value		\|\|pH value
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-ph		\|\|/var/local/aquarium-ctrl/atlsscntfc-ph
			\|\|phValue
	\|-		\|-
	\|\|filtered pH value		\|\|filtered pH value
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-phfltrd		\|\|/var/local/aquarium-ctrl/atlsscntfc-phfltrd
			\|\|filteredPhValue
	\|-		\|-
	\|\|conductivity		\|\|conductivity
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-conduc		\|\|/var/local/aquarium-ctrl/atlsscntfc-conduc
			\|\|conductivity
	\|-		\|-
	\|\|filtered water temperature		\|\|filtered water temperature
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-conducfltrd		\|\|/var/local/aquarium-ctrl/atlsscntfc-conducfltrd
			\|\|filteredWaterTemperature
	\|-		\|-
	\|\|tank level switch position		\|\|tank level switch position
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/tnklvlsswtch		\|\|/var/local/aquarium-ctrl/tnklvlsswtch
			\|\|tankLevelSwitchPosition
	\|-		\|-
	\|\|surface ventilation status		\|\|surface ventilation status
	\|\|string		\|\|string
	\|\|/var/local/aquarium-ctrl/srfcvntltn		\|\|/var/local/aquarium-ctrl/srfcvntltn
			\|\|surfaceVentilationStatus
	\|-		\|-
	\|\|ambient temperature		\|\|ambient temperature
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/ambtemp		\|\|/var/local/aquarium-ctrl/ambtemp
			\|\|ambientTemperature
	\|-		\|-
	\|\|ambient humidity		\|\|ambient humidity
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/ambhum		\|\|/var/local/aquarium-ctrl/ambhum
			\|\|ambientHumidity
	\|-		\|-
	\|\|heating status		\|\|heating status
	\|\|string		\|\|string
	\|\|/var/local/aquarium-ctrl/htng		\|\|/var/local/aquarium-ctrl/htng
			\|\|heatingStatus
	\|-		\|-
	\|}		\|}

Uwe: /* Requirements for time data feature */

2025-12-18T18:46:25Z

Requirements for time data feature

← Older revision		Revision as of 20:46, 18 December 2025
Line 603:		Line 603:
	!\|Signal format		!\|Signal format
	!\|Database column name		!\|Database column name
			!\|API response
	\|-		\|-
	\|\|timestamp		\|\|timestamp
	\|\|string		\|\|string
	\|\|data.timestamp		\|\|data.timestamp
			\|\|timestamp
	\|-		\|-
	\|\|water temperature		\|\|water temperature
	\|\|floating point number		\|\|floating point number
	\|\|data.water_temperature		\|\|data.water_temperature
			\|\|waterTemperature
	\|-		\|-
	\|\|filtered water temperature		\|\|filtered water temperature
	\|\|floating point number		\|\|floating point number
	\|\|data.water_temperature_filtered		\|\|data.water_temperature_filtered
			\|\|waterTemperatureFiltered
	\|-		\|-
	\|\|pH value		\|\|pH value
	\|\|floating point number		\|\|floating point number
	\|\|data.ph_value		\|\|data.ph_value
			\|\|phValue
	\|-		\|-
	\|\|filtered pH value		\|\|filtered pH value
	\|\|floating point number		\|\|floating point number
	\|\|data.ph_value_filtered		\|\|data.ph_value_filtered
			\|\|filteredPhValue
	\|-		\|-
	\|\|conductivity		\|\|conductivity
	\|\|floating point number		\|\|floating point number
	\|\|data.conductivity		\|\|data.conductivity
			\|\|conductivity
	\|-		\|-
	\|\|filtered conductivity		\|\|filtered conductivity
	\|\|floating point number		\|\|floating point number
	\|\|data.conductivity_filtered		\|\|data.conductivity_filtered
			\|\|filteredConductivity
	\|-		\|-
	\|\|refill in progress		\|\|refill in progress
	\|\|boolean		\|\|boolean
	\|\|data.refill_in_progress		\|\|data.refill_in_progress
			\|\|refillInProgress
	\|-		\|-
	\|\|tank level switch position		\|\|tank level switch position
	\|\|boolean		\|\|boolean
	\|\|data.tank_level_switch_position		\|\|data.tank_level_switch_position
			\|\|tankLevelSwitchPosition
	\|-		\|-
	\|\|tank level switch validity indicator		\|\|tank level switch validity indicator
	\|\|boolean		\|\|boolean
	\|\|data.tank_level_switch_invalid		\|\|data.tank_level_switch_invalid
			\|\|tankLevelSwitchInvalid
	\|-		\|-
	\|\|tank level switch position stabilized		\|\|tank level switch position stabilized
	\|\|boolean		\|\|boolean
	\|\|data.tank_level_switch_position_stabilized		\|\|data.tank_level_switch_position_stabilized
			\|\|tankLevelSwitchPositionStabilized
	\|-		\|-
	\|\|surface ventilation status		\|\|surface ventilation status
	\|\|boolean		\|\|boolean
	\|\|data.surface_ventilation_status		\|\|data.surface_ventilation_status
			\|\|surfaceVentilationStatus
	\|-		\|-
	\|\|ambient temperature		\|\|ambient temperature
	\|\|floating point number		\|\|floating point number
	\|\|data.ambient_temperature		\|\|data.ambient_temperature
			\|\|ambientTemperature
	\|-		\|-
	\|\|ambient humidity		\|\|ambient humidity
	\|\|floating point number		\|\|floating point number
	\|\|data.ambient_humidity		\|\|data.ambient_humidity
			\|\|ambientHumidity
	\|-		\|-
	\|\|heater status		\|\|heater status
	\|\|boolean		\|\|boolean
	\|\|data.heater_status		\|\|data.heater_status
			\|\|heaterStatus
	\|-		\|-
	\|}		\|}

Uwe: /* Balling dosing log */

2025-12-16T16:45:13Z

Balling dosing log

← Older revision		Revision as of 18:45, 16 December 2025
Line 109:		Line 109:
	!\|Signal format		!\|Signal format
	!\|Database column name		!\|Database column name
			!\|API response
	\|-		\|-
	\|\|timestamp		\|\|timestamp
	\|\|string		\|\|string
	\|\|balling_log.Timestamp		\|\|balling_log.Timestamp
			\|\|timestamp
	\|-		\|-
	\|\|pump id		\|\|pump id
	\|\|integer number		\|\|integer number
	\|\|balling_log.pumpid		\|\|balling_log.pumpid
			\|\|pumpId
	\|-		\|-
	\|\|dosing volume		\|\|dosing volume
	\|\|floating point number		\|\|floating point number
	\|\|balling_log.dosingvolume		\|\|balling_log.dosingvolume
			\|\|dosingVolume
	\|-		\|-
	\|\|label		\|\|label
	\|\|string		\|\|string
	\|\|balling_set_vals.label		\|\|balling_set_vals.label
			\|\|label
	\|-		\|-
	\|}		\|}

Uwe: /* load_balling_long */

2025-12-09T18:19:22Z

load_balling_long

← Older revision		Revision as of 20:19, 9 December 2025
Line 754:		Line 754:
	When using this parameter value, the API provides the overview data in JSON format as per [[REST_API#Requirements_for_overview_feature\|above requirement]].		When using this parameter value, the API provides the overview data in JSON format as per [[REST_API#Requirements_for_overview_feature\|above requirement]].

	=== ~~load_balling_long~~ ===		=== load_balling_log ===
	When using this parameter value, the API provides the balling dosing log as per [[REST_API#Balling_dosing_log\|above requirements]].		When using this parameter value, the API provides the balling dosing log as per [[REST_API#Balling_dosing_log\|above requirements]].

← Older revision		Revision as of 10:57, 19 December 2025
Line 223:		Line 223:
	!\|Signal format		!\|Signal format
	!\|Database column name		!\|Database column name
			!\|API response
	\|-		\|-
	\|\|profile id		\|\|profile id
	\|\|integer number		\|\|integer number
	\|\|feed_profiles.profile_id		\|\|feed_profiles.profile_id
			\|\|profileId
	\|-		\|-
	\|\|profile name		\|\|profile name
	\|\|string		\|\|string
	\|\|feed_profiles.profile_name		\|\|feed_profiles.profile_name
			\|\|profileName
	\|-		\|-
	\|\|pause 01 duration		\|\|pause 01 duration
	\|\|integer		\|\|integer
	\|\|feed_profiles.pause_01_duration		\|\|feed_profiles.pause_01_duration
			\|\|pause01Duration
	\|-		\|-
	\|\|pause 01 skimmer target state		\|\|pause 01 skimmer target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_01_skimmer		\|\|feed_profiles.pause_01_skimmer
			\|\|pause01Skimmer
	\|-		\|-
	\|\|pause 01 main pump #1 target state		\|\|pause 01 main pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_01_main_pump1		\|\|feed_profiles.pause_01_main_pump1
			\|\|pause01MainPump1
	\|-		\|-
	\|\|pause 01 main pump #2 target state		\|\|pause 01 main pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_01_main_pump2		\|\|feed_profiles.pause_01_main_pump2
			\|\|pause01MainPump2
	\|-		\|-
	\|\|pause 01 aux. pump #1 target state		\|\|pause 01 aux. pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_01_aux_pump1		\|\|feed_profiles.pause_01_aux_pump1
			\|\|pause01AuxPump1
	\|-		\|-
	\|\|pause 01 aux. pump #2 target state		\|\|pause 01 aux. pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_01_aux_pump2		\|\|feed_profiles.pause_01_aux_pump2
			\|\|pause01AuxPump2
	\|-		\|-
	\|\|feed 01 duration		\|\|feed 01 duration
	\|\|integer		\|\|integer
	\|\|feed_profiles.feed_01_duration		\|\|feed_profiles.feed_01_duration
			\|\|feed01Duration
	\|-		\|-
	\|\|feed 01 skimmer target state		\|\|feed 01 skimmer target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_01_skimmer		\|\|feed_profiles.feed_01_skimmer
			\|\|feed01Skimmer
	\|-		\|-
	\|\|feed 01 main pump #1 target state		\|\|feed 01 main pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_01_main_pump1		\|\|feed_profiles.feed_01_main_pump1
			\|\|feed01MainPump1
	\|-		\|-
	\|\|feed 01 main pump #2 target state		\|\|feed 01 main pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_01_main_pump2		\|\|feed_profiles.feed_01_main_pump2
			\|\|feed01MainPump2
	\|-		\|-
	\|\|feed 01 aux. pump #1 target state		\|\|feed 01 aux. pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_01_aux_pump1		\|\|feed_profiles.feed_01_aux_pump1
			\|\|feed01AuxPump1
	\|-		\|-
	\|\|feed 01 aux. pump #2 target state		\|\|feed 01 aux. pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_01_aux_pump2		\|\|feed_profiles.feed_01_aux_pump2
			\|\|feed01AuxPump2
	\|-		\|-
	\|\|...		\|\|...
Line 287:		Line 302:
	\|\|integer		\|\|integer
	\|\|feed_profiles.pause_10_duration		\|\|feed_profiles.pause_10_duration
			\|\|pause10Duration
	\|-		\|-
	\|\|pause 10 skimmer target state		\|\|pause 10 skimmer target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_10_skimmer		\|\|feed_profiles.pause_10_skimmer
			\|\|pause10Skimmer
	\|-		\|-
	\|\|pause 10 main pump #1 target state		\|\|pause 10 main pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_10_main_pump1		\|\|feed_profiles.pause_10_main_pump1
			\|\|pause10MainPump1
	\|-		\|-
	\|\|pause 10 main pump #2 target state		\|\|pause 10 main pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_10_main_pump2		\|\|feed_profiles.pause_10_main_pump2
			\|\|pause10MainPump2
	\|-		\|-
	\|\|pause 10 aux. pump #1 target state		\|\|pause 10 aux. pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_10_aux_pump1		\|\|feed_profiles.pause_10_aux_pump1
			\|\|pause10AuxPump1
	\|-		\|-
	\|\|pause 10 aux. pump #2 target state		\|\|pause 10 aux. pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.pause_10_aux_pump2		\|\|feed_profiles.pause_10_aux_pump2
			\|\|pause10AuxPump2
	\|-		\|-
	\|\|feed 10 duration		\|\|feed 10 duration
	\|\|integer		\|\|integer
	\|\|feed_profiles.feed_10_duration		\|\|feed_profiles.feed_10_duration
			\|\|feed10Duration
	\|-		\|-
	\|\|feed 10 skimmer target state		\|\|feed 10 skimmer target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_10_skimmer		\|\|feed_profiles.feed_10_skimmer
			\|\|feed10Skimmer
	\|-		\|-
	\|\|feed 10 main pump #1 target state		\|\|feed 10 main pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_10_main_pump1		\|\|feed_profiles.feed_10_main_pump1
			\|\|feed10MainPump1
	\|-		\|-
	\|\|feed 10 main pump #2 target state		\|\|feed 10 main pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_10_main_pump2		\|\|feed_profiles.feed_10_main_pump2
			\|\|feed10MainPump2
	\|-		\|-
	\|\|feed 10 aux. pump #1 target state		\|\|feed 10 aux. pump #1 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_10_aux_pump1		\|\|feed_profiles.feed_10_aux_pump1
			\|\|feed10AuxPump1
	\|-		\|-
	\|\|feed 10 aux. pump #2 target state		\|\|feed 10 aux. pump #2 target state
	\|\|boolean		\|\|boolean
	\|\|feed_profiles.feed_10_aux_pump2		\|\|feed_profiles.feed_10_aux_pump2
			\|\|feed10AuxPump2
	\|-		\|-
	\|}		\|}

← Older revision		Revision as of 20:58, 18 December 2025
Line 76:		Line 76:
	\|\|/var/local/aquarium-ctrl/atlsscntfc-conduc		\|\|/var/local/aquarium-ctrl/atlsscntfc-conduc
	\|\|conductivity		\|\|conductivity
			\|-
			\|\|filtered conductivity
			\|\|floating point number
			\|\|/var/local/aquarium-ctrl/atlsscntfc-conducfltrd
			\|\|filteredConductivity
	\|-		\|-
	\|\|filtered water temperature		\|\|filtered water temperature

← Older revision		Revision as of 20:57, 18 December 2025
Line 45:		Line 45:
	!\|Signal format		!\|Signal format
	!\|Signal source		!\|Signal source
			!\|API response
	\|-		\|-
	\|\|timestamp		\|\|timestamp
	\|\|string		\|\|string
	\|\|/var/local/aquarium-ctrl/aquarium-ctrl-ts		\|\|/var/local/aquarium-ctrl/aquarium-ctrl-ts
			\|\|timestamp
	\|-		\|-
	\|\|water temperature		\|\|water temperature
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-temp		\|\|/var/local/aquarium-ctrl/atlsscntfc-temp
			\|\|waterTemperature
	\|-		\|-
	\|\|filtered water temperature		\|\|filtered water temperature
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-tempfltrd		\|\|/var/local/aquarium-ctrl/atlsscntfc-tempfltrd
			\|\|filteredWaterTemperature
	\|-		\|-
	\|\|pH value		\|\|pH value
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-ph		\|\|/var/local/aquarium-ctrl/atlsscntfc-ph
			\|\|phValue
	\|-		\|-
	\|\|filtered pH value		\|\|filtered pH value
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-phfltrd		\|\|/var/local/aquarium-ctrl/atlsscntfc-phfltrd
			\|\|filteredPhValue
	\|-		\|-
	\|\|conductivity		\|\|conductivity
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-conduc		\|\|/var/local/aquarium-ctrl/atlsscntfc-conduc
			\|\|conductivity
	\|-		\|-
	\|\|filtered water temperature		\|\|filtered water temperature
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/atlsscntfc-conducfltrd		\|\|/var/local/aquarium-ctrl/atlsscntfc-conducfltrd
			\|\|filteredWaterTemperature
	\|-		\|-
	\|\|tank level switch position		\|\|tank level switch position
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/tnklvlsswtch		\|\|/var/local/aquarium-ctrl/tnklvlsswtch
			\|\|tankLevelSwitchPosition
	\|-		\|-
	\|\|surface ventilation status		\|\|surface ventilation status
	\|\|string		\|\|string
	\|\|/var/local/aquarium-ctrl/srfcvntltn		\|\|/var/local/aquarium-ctrl/srfcvntltn
			\|\|surfaceVentilationStatus
	\|-		\|-
	\|\|ambient temperature		\|\|ambient temperature
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/ambtemp		\|\|/var/local/aquarium-ctrl/ambtemp
			\|\|ambientTemperature
	\|-		\|-
	\|\|ambient humidity		\|\|ambient humidity
	\|\|floating point number		\|\|floating point number
	\|\|/var/local/aquarium-ctrl/ambhum		\|\|/var/local/aquarium-ctrl/ambhum
			\|\|ambientHumidity
	\|-		\|-
	\|\|heating status		\|\|heating status
	\|\|string		\|\|string
	\|\|/var/local/aquarium-ctrl/htng		\|\|/var/local/aquarium-ctrl/htng
			\|\|heatingStatus
	\|-		\|-
	\|}		\|}

← Older revision		Revision as of 20:46, 18 December 2025
Line 603:		Line 603:
	!\|Signal format		!\|Signal format
	!\|Database column name		!\|Database column name
			!\|API response
	\|-		\|-
	\|\|timestamp		\|\|timestamp
	\|\|string		\|\|string
	\|\|data.timestamp		\|\|data.timestamp
			\|\|timestamp
	\|-		\|-
	\|\|water temperature		\|\|water temperature
	\|\|floating point number		\|\|floating point number
	\|\|data.water_temperature		\|\|data.water_temperature
			\|\|waterTemperature
	\|-		\|-
	\|\|filtered water temperature		\|\|filtered water temperature
	\|\|floating point number		\|\|floating point number
	\|\|data.water_temperature_filtered		\|\|data.water_temperature_filtered
			\|\|waterTemperatureFiltered
	\|-		\|-
	\|\|pH value		\|\|pH value
	\|\|floating point number		\|\|floating point number
	\|\|data.ph_value		\|\|data.ph_value
			\|\|phValue
	\|-		\|-
	\|\|filtered pH value		\|\|filtered pH value
	\|\|floating point number		\|\|floating point number
	\|\|data.ph_value_filtered		\|\|data.ph_value_filtered
			\|\|filteredPhValue
	\|-		\|-
	\|\|conductivity		\|\|conductivity
	\|\|floating point number		\|\|floating point number
	\|\|data.conductivity		\|\|data.conductivity
			\|\|conductivity
	\|-		\|-
	\|\|filtered conductivity		\|\|filtered conductivity
	\|\|floating point number		\|\|floating point number
	\|\|data.conductivity_filtered		\|\|data.conductivity_filtered
			\|\|filteredConductivity
	\|-		\|-
	\|\|refill in progress		\|\|refill in progress
	\|\|boolean		\|\|boolean
	\|\|data.refill_in_progress		\|\|data.refill_in_progress
			\|\|refillInProgress
	\|-		\|-
	\|\|tank level switch position		\|\|tank level switch position
	\|\|boolean		\|\|boolean
	\|\|data.tank_level_switch_position		\|\|data.tank_level_switch_position
			\|\|tankLevelSwitchPosition
	\|-		\|-
	\|\|tank level switch validity indicator		\|\|tank level switch validity indicator
	\|\|boolean		\|\|boolean
	\|\|data.tank_level_switch_invalid		\|\|data.tank_level_switch_invalid
			\|\|tankLevelSwitchInvalid
	\|-		\|-
	\|\|tank level switch position stabilized		\|\|tank level switch position stabilized
	\|\|boolean		\|\|boolean
	\|\|data.tank_level_switch_position_stabilized		\|\|data.tank_level_switch_position_stabilized
			\|\|tankLevelSwitchPositionStabilized
	\|-		\|-
	\|\|surface ventilation status		\|\|surface ventilation status
	\|\|boolean		\|\|boolean
	\|\|data.surface_ventilation_status		\|\|data.surface_ventilation_status
			\|\|surfaceVentilationStatus
	\|-		\|-
	\|\|ambient temperature		\|\|ambient temperature
	\|\|floating point number		\|\|floating point number
	\|\|data.ambient_temperature		\|\|data.ambient_temperature
			\|\|ambientTemperature
	\|-		\|-
	\|\|ambient humidity		\|\|ambient humidity
	\|\|floating point number		\|\|floating point number
	\|\|data.ambient_humidity		\|\|data.ambient_humidity
			\|\|ambientHumidity
	\|-		\|-
	\|\|heater status		\|\|heater status
	\|\|boolean		\|\|boolean
	\|\|data.heater_status		\|\|data.heater_status
			\|\|heaterStatus
	\|-		\|-
	\|}		\|}

← Older revision		Revision as of 18:45, 16 December 2025
Line 109:		Line 109:
	!\|Signal format		!\|Signal format
	!\|Database column name		!\|Database column name
			!\|API response
	\|-		\|-
	\|\|timestamp		\|\|timestamp
	\|\|string		\|\|string
	\|\|balling_log.Timestamp		\|\|balling_log.Timestamp
			\|\|timestamp
	\|-		\|-
	\|\|pump id		\|\|pump id
	\|\|integer number		\|\|integer number
	\|\|balling_log.pumpid		\|\|balling_log.pumpid
			\|\|pumpId
	\|-		\|-
	\|\|dosing volume		\|\|dosing volume
	\|\|floating point number		\|\|floating point number
	\|\|balling_log.dosingvolume		\|\|balling_log.dosingvolume
			\|\|dosingVolume
	\|-		\|-
	\|\|label		\|\|label
	\|\|string		\|\|string
	\|\|balling_set_vals.label		\|\|balling_set_vals.label
			\|\|label
	\|-		\|-
	\|}		\|}