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.
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` >= '20230426193410'
AND
`timestamp_server` <= '20230426193910'
/* 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