syslog

Return data from the system log.

Description

https://api.eze.io/v1/syslog/{serial}/from={datetime}/[to={datetime}]/[fields]/[interval[,aggregation]]/["raw"]

Parameters

serial The serial number of the ezeio (XYZ987)
from=datetime The beginning of the range. Format per RFC3339 or 1d/1h/1m
to=datetime The end of the range. Format per RFC3339. If not given, current time is assumed.
fields (optional) Comma separated list of fields. Possible fields are 1-90, GPSx, GPSy, GPSz, GPSsignal. If not given, all fields are returned.
interval (optional) Sample interval. Given as a number followed by 'd', 'h' or 'm' for day, hour or minute.
aggregation (optional) Method of aggregation. Only valid if interval is given.
“raw” (optional) Only return values actually stored in database.

The from parameter can be given as number of minutes/hours/days relative to current time. For example from=17h means “17 hours ago”.

If no interval is given, an automatic interval will be calculated based on the size of the range. This is to ensure the amount of data returned is reasonable.

If range >= 365 days, interval will be 1 day.
If range >= 60 days, interval will be 6 hours.
If range >= 7 days, interval will be 1 hour.
For smaller ranges than 7 days, the interval will be 10 minutes.

Under no circumstances will the call return more than 5000 rows of data.

Aggregation modes:

mean : The mean (average) of samples in the interval
mode : The mode (most common value)
median : The middle value of sorted samples in the interval
min : The smallest value
max : The largest value
sum : The sum of all samples in the interval
spread : The difference between the highest and the lowest value in the interval
count : The number of samples in the interval

Example usage

15 day interval using defaults: 

https://api.eze.io/v1/syslog/XYZ987/from=2017-03-01/to=2017-03-15

Specifying fields: 

https://api.eze.io/v1/syslog/XYS987/from=2018-10-05T06:30:00Z/to=2018-10-06T06:30:00Z/fields=2,4,12,GPSx,GPSy

Available fields are:

# Field # value, where # is an integer, 1-90
ADC# Raw ADC reading, where # is 0-10. 8=DC in, 9=Terminal DC, 10=5V terminal
out# Raw output status, where # is 0, 1, 2 or 3
fRunning 1=Logic running. 0=Logic halted
ethComm 1=Ethernet connection available. 0=No Ethernet connection
ethLink 1=Ethernet link availabe. 0=No Ethernet link
GPSx Location x-coordinate (latitude)
GPSy Location y-coordinate (longitude)
GPSz Location z-coordinate (elevation)
GPSsignal GPS received signal
gpsLock 1=GPS received has locked in signals from the satellites. 0=no lock
groupid The group ID associated with this unit
uptime Uptime in seconds
gsmComm 1=Cellular data connection established. 0=No cellular data
gsmLink 1=Cellular service found. 0=No cell service
gsmNet 1=Cellular IP acquired. 0=No connection
cID Cell tower ID
cLAC Cell location area code
cMCC Cell network MCC
cMNC Cell network MNC
cRSSI Cell received signal level

Hourly max values: 

https://api.eze.io/v1/syslog/XYZ987/from=2019-02-01/to=2019-03-01/fields=1,2/interval=1h,max

Return value

JSON formatted data

(below examples have whitespaces added for readability) 

Example query:
https://api.eze.io/v1/syslog/baa157/from=2019-02-01/to=2019-03-01/fields=1,2
 
{
  "reqtime":"2019-06-16T22:51:49Z",
  "fieldmeta":[
    {
      "no":"1",
      "name":"Uptime",
      "tag":"",
      "decimals":"0",
      "unit":"s"
    },
    {
      "no":"2",
      "name":"Temperature",
      "tag":"temp",
      "decimals":"1",
      "unit":"°C"
    }
  ]
  "data":[
    {
      "time":"2019-02-01T00:00:00Z",
      "f1":null,
      "f2":null
    },
    {
      "time":"2019-02-01T00:10:00Z",
      "f1":432609,
      "f2":25.67
    },
    {
      "time":"2019-02-01T00:20:00Z",
      "f1":433209,
      "f2":25.709999
    },
    {
      "time":"2019-02-01T00:30:00Z",
      "f1":433809,
      "f2":25.709999
    },
    // ** Entries removed for brevity **
    {
      "time":"2019-02-28T22:00:00Z",
      "f1":786047.1666666666,
      "f2":25.016666666666666
    },
    {
      "time":"2019-02-28T23:00:00Z",
      "f1":789648,
      "f2":25.151667000000003
    }    
  ],
  "status":"OK",
  "exec_time":0.027250051498413086
}