SMK Pulau Gaya Pilot IOT Network


IOT for Communities

data lab api access

api parameters

This page allows you to play around with the stored data and retrieve it for use in your own research and/or website. Access to the API and data is free - the developers do not make any guarantees on the availability of the service or the accuracy of the data. Please do not abuse the server - if you need to make periodic requests to the API, we recommend an interval of at least 10 minutes.

format: YYYYMMDDHHMMSS, defaults to 5 minutes ago | clear

format: YYYYMMDDHHMMSS, defaults to now | clear

  • legacy returns TTN payloads
  • averages returns consolidated rows
  • json hides interface, has header Access-Control-Allow-Origin: *
  • lab (csv as attachment) downloads csv file, use lab (csv) to check output
50000 (fixed, use with record offset for pagination)
reset everything

sql / mariadb dialect

SELECT
  ID,
  CONCAT(DATE_FORMAT(timestamp_server, '%Y%m%d%H%i%s'), '-', ID) AS UID,
  payload

FROM
  smkpulaugaya

WHERE

/* FILTERS: MANDATORY */
  `timestamp_server` >= '20190127042612'
  AND 
  `timestamp_server` <= '20190127043112'

/* FILTERS: EXTRA */
  AND
  (
    `dev_id` = 'pulaugaya-lora-node1'
    OR
    `dev_id` = 'pulaugaya-lora-node2'
    OR
    `dev_id` = 'pulaugaya-lora-node3'
    OR
    `dev_id` = 'pulaugaya-lora-node4'
  )

/* GROUP BY */


/* ORDER BY */
ORDER BY
  timestamp_server DESC

LIMIT 50000 OFFSET 0

deployment information / last updated: 2017-12-11

node 1

node 2

node 3

node 4

lorawan gateway

backend

database / 0 rows returned in 0.00074 seconds

no output available