Database REST API – NTUA

REST (representational state transfer) APIs (application programming interfaces) add levels to the process of requesting data from the database.

The URL below returns measurements stored in the postgres database through the REST API

Open using Firefox (renders and formats the JSON results).

Example 1)

An example is given below. The fields embedded in the URL string are: time, device_name, object, rx_info

The filters (SQL) embedded in the URL are:

device_name = ‘UC502_7’
limit=100
order time DESC

https://df.e-pyrros.gr/api/v2/lora/_table/event_up?fields=time,device_name,object,rx_info,&filter=device_name=UC502_7&limit=10&order=time%20DESC&api_key=d11076d30cc60b2c3d75383be92d6c9805774ca1a63837c050e7fd2e07a890ec