Using any language suitable like php or python ,
query influxdb using the bucket and token and Influx Query .
from(bucket: "general")
|> range(start: -24h)
|> filter(fn: (r) => r["_measurement"] == "mem")
|> filter(fn: (r) => r["_field"] == "temperature")
This will obtain you temperature of the device
Second API will provide you
{
"id": 1493,
"user_id": 110,
"location_id": 48,
"group_id": 48,
"device_mac": "BC5729009415",
"device_name": "Device X",
"device_alias": "Device X",
"device_min_temp": 2,
"device_max_temp": 8,
"device_min_humidity": 0,
"device_max_humidity": 0,
"cron": null,
"from_hrs": null,
"to_hrs": null,
"isActive": 0,
"serial": null,
"threshold_value_code": null
}
You Task is to Join InfluxDB + API and provide me
1. Last updated time single
2. Range data between two time duration with intervals
Output similar to
{
"id": 1493,
"user_id": 110,
"location_id": 48,
"group_id": 48,
"device_mac": "BC5729009415",
"device_name": "Device X",
"device_alias": "Device X",
"device_min_temp": 2,
"device_max_temp": 8,
"device_min_humidity": 0,
"device_max_humidity": 0,
"cron": null,
"from_hrs": null,
"to_hrs": null,
"isActive": 0,
"serial": null,
"threshold_value_code": null,
device_json : [{"device_mac":"BC5729009415","time-utc":"2023-11-07T09:30:00Z","value":-25.5,"time":"2023-11-07 15:00:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T09:45:00Z","value":-24.29310344827586,"time":"2023-11-07 15:15:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T10:00:00Z","value":-24.333333333333332,"time":"2023-11-07 15:30:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T10:15:00Z","value":-24.683333333333334,"time":"2023-11-07 15:45:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T10:30:00Z","value":-24.603658536585368,"time":"2023-11-07 16:00:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T10:45:00Z","value":-24.6425,"time":"2023-11-07 16:15:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T11:00:00Z","value":-24.251592356687897,"time":"2023-11-07 16:30:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T11:15:00Z","value":-23.034591194968552,"time":"2023-11-07 16:45:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T11:30:00Z","value":-24.221739130434784,"time":"2023-11-07 17:00:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T11:45:00Z","value":-24.93548387096774,"time":"2023-11-07 17:15:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T12:00:00Z","value":-24.472027972027973,"time":"2023-11-07 17:30:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T12:15:00Z","value":-23.772435897435898,"time":"2023-11-07 17:45:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T12:30:00Z","value":-24.552486187845304,"time":"2023-11-07 18:00:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T12:45:00Z","value":-24.37171052631579,"time":"2023-11-07 18:15:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T13:00:00Z","value":-25.142335766423358,"time":"2023-11-07 18:30:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T13:15:00Z","value":-24.637323943661972,"time":"2023-11-07 18:45:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T13:30:00Z","value":-24.322115384615383,"time":"2023-11-07 19:00:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T13:45:00Z","value":-23.458333333333332,"time":"2023-11-07 19:15:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T14:00:00Z","value":-23.62847222222222,"time":"2023-11-07 19:30:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T14:15:00Z","value":-24.015151515151516,"time":"2023-11-07 19:45:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T14:30:00Z","value":-23.82608695652174,"time":"2023-11-07 20:00:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T14:45:00Z","value":-22.417218543046356,"time":"2023-11-07 20:15:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T15:00:00Z","value":-24.3006993006993,"time":"2023-11-07 20:30:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T15:15:00Z","value":-23.79861111111111,"time":"2023-11-07 20:45:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T15:30:00Z","value":-24.14723926380368,"time":"2023-11-07 21:00:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T15:45:00Z","value":-24.32712765957447,"time":"2023-11-07 21:15:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T16:00:00Z","value":-25.05722891566265,"time":"2023-11-07 21:30:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T16:15:00Z","value":-23.547101449275363,"time":"2023-11-07 21:45:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T16:30:00Z","value":-25.043478260869566,"time":"2023-11-07 22:00:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T16:45:00Z","value":-23.838983050847457,"time":"2023-11-07 22:15:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T17:00:00Z","value":-24.126168224299064,"time":"2023-11-07 22:30:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T17:15:00Z","value":-25.081196581196583,"time":"2023-11-07 22:45:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T17:30:00Z","value":-25.5,"time":"2023-11-07 23:00:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T17:45:00Z","value":-24.210526315789473,"time":"2023-11-07 23:15:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T18:00:00Z","value":-24.00609756097561,"time":"2023-11-07 23:30:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T18:15:00Z","value":-24.15753424657534,"time":"2023-11-07 23:45:00"},{"device_mac":"BC5729009415","time-utc":"2023-11-07T18:29:47.971262819Z","value":-22.88167938931298,"time":"2023-11-07 23:59:47"}]
}
And binding the response to the user
Data Visualization Project with InfluxDB and Python
I am looking for a skilled freelancer who can assist me with a data visualization project. The purpose of this project is to create visual representations of data using the InfluxDB database and Python programming language.
Skills and Experience:
- Proficiency in Python is essential for this project
- Experience working with InfluxDB or similar databases is preferred
- Strong understanding of data visualization techniques and best practices
- Ability to create visually appealing and interactive charts, graphs, and dashboards
- Familiarity with libraries such as Matplotlib, Plotly, or Seaborn for data visualization
- Knowledge of API integration to retrieve and analyze data
- Attention to detail and ability to deliver high-quality work within tight deadlines
Deadline:
The client has specified a deadline of 1 week for the completion of this project. It is important that the freelancer is able to work efficiently and effectively to meet this deadline.
Payment:
This is an instant $100 project, offering a fixed payment for the successful completion of the task.