Direct IoTool Cloud access (Pers., Prof., Ent.)

You have several options to access your measurements through IoTool Cloud.

Direct measurement table

Click select next to [your username]_readings.

  • Modify lets you change the values in the table.
  • Datetimems represents the number of milliseconds from January 1st, 1970.
  • Reading is the value your sensor measured.
  • Sensor_id represents the sensor which you used for measuring.

Table Structure

ColumnType
datetimems bigint
reading double precision
sensor_id - linked to sensors table integer

Human readable measurement view

You can also view the table in human readable format. Click select next to [your username]_readings_hrf.

  • Modify lets you change the values in the table.
  • Datetimems now shows direct date and time.
  • Reading is the value your sensor measured.
  • Sensor_id now shows the name of the sensor.

Table Structure

ColumnType
datetimems text
reading double precision
sensor_id - linked to sensors table character varying(64)

Direct files table

Click select next to [your username]_files.

  • Modify lets you change the values in the table.
  • Datetimems represents the number of milliseconds from January 1st, 1970.
  • Filename is the name of the file uploaded.
  • Sensor_id represents the sensor which you used for measuring.

Table Structure

ColumnType
datetimems bigint
filename character varying(256)
sensor_id - linked to sensors table integer

Human readable files view

You can also view the table in human readable format. Click select next to [your username]_files_hrf.

  • Modify lets you change the values in the table.
  • Datetimems now shows direct date and time.
  • Filename is the name of the file uploaded.
  • Sensor_id now shows the name of the sensor.

Table Structure

ColumnType
datetimems text
filename character varying(256)
sensor_id - linked to sensors table character varying(64)

Direct blobs table

You can also view the table blobs that can be later processed by IoTool. in human readable format. Click select next to [your username]_blobs.

  • Modify lets you change the values in the table.
  • Datetimems represents the number of milliseconds from January 1st, 1970.
  • Blob is the binary data you send to IoTool.
  • Sensor_id represents the virtual sensor associated with the sent data.

 

Table Structure

ColumnType
datetimems bigint
blob bytea
sensor_id - linked to sensors table integer

Human readable blobs view

This table stores the blobs table that can be later processed by IoTool. in human readable format. Click select next to [your username]_blobs_hrf.

  • Modify lets you change the values in the table.
  • Datetimems now shows direct date and time.
  • Blob is the binary data you send to IoTool.
  • Sensor_id now shows the name of the sensor.

 

Table Structure

ColumnType
datetimems text
blob bytea
sensor_id - linked to sensors table character varying(64)

 

 

Sensors table

This table shows the values assigned to sensors you used in your measurements. Click select next to [your username]_sensors.

  • Modify lets you change the values in the table.
  • ID is the number assigned to a sensor.
  • Sensor is the name by which the sensor is represented.

Table Structure

ColumnTypeComment
id integer  
sensor character varying(64)  
fullname character varying name for sensors list in IoTool application
shortname character varying name for dashboard buttons in IoTool application (max ~8 characters)
unit character varying reading unit
interval integer approximate interval between readings in milliseconds
displayvalue boolean set to false to hide reading value in IoTool app, e.g. for readings which varies a lot in less than one second
charttype character varying chart display type in IoTool app (line, point, column, spline etc.)
setyrange boolean set fixed y range on chart in IoTool app
minyrange integer chart y range starts with in IoTool app dashboard (min value to be displayed)
maxyrange integer chart y range ends with in IoTool app dashboard (max value to be displayed)
decimals smallint number of decimals of reading value to be displayed on IoTool app dashboard buttons

If you wish to have direct access to these tables, please contact us or open a ticket.