Graph Generate + PDF & MAIL

General
1

How to generate Graph from Influxdb .
Use node-red and filter data based on API (unique ID) and generate PDF and automate it

During the Specified time -Shoot Email to user.

2

Grafana will do most (if not all) of that for you.

3

I need to generate Graph with some data like minimum temp
maximum temperature
device name
device mac

for each unique mac address.
later will send the report as mail

Need Guidance using node red

image
image786×221 22.2 KB

[
{
"id": "3b59e4113fc119b1",
"type": "tab",
"label": "Flow 17",
"disabled": false,
"info": "",
"env":
},
{
"id": "ebef80b91b1e1991",
"type": "inject",
"z": "3b59e4113fc119b1",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "[{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T14:00:00Z","_value":47.2578125,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T16:00:00Z","_value":56.796875,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T18:00:00Z","_value":62.4296875,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T20:00:00Z","_value":58.54296875,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T22:00:00Z","_value":65.8671875,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T00:00:00Z","_value":54.6640625,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T02:00:00Z","_value":76.515625,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T04:00:00Z","_value":57.546875,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T06:00:00Z","_value":45.38671875,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T08:00:00Z","_value":60.390625,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T10:00:00Z","_value":44.6015625,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T12:00:00Z","_value":39.21484375,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T12:15:13.804669687Z","_value":45.3515625,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T14:00:00Z","_value":22.375,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T16:00:00Z","_value":22.25,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T18:00:00Z","_value":21.921875,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T20:00:00Z","_value":22.078125,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T22:00:00Z","_value":22.9609375,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T00:00:00Z","_value":22.37109375,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T02:00:00Z","_value":22.25,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T04:00:00Z","_value":22.58203125,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T06:00:00Z","_value":22.98828125,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T08:00:00Z","_value":21.53515625,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T10:00:00Z","_value":21.60546875,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T12:00:00Z","_value":22.88671875,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T12:15:13.804669687Z","_value":22.25,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_info":"KBPro_285535","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T14:00:00Z","_value":42.1875,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T16:00:00Z","_value":56.6953125,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T18:00:00Z","_value":58.53515625,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T20:00:00Z","_value":55.41015625,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T22:00:00Z","_value":54.80859375,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T00:00:00Z","_value":67.33203125,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T02:00:00Z","_value":57.9140625,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T04:00:00Z","_value":62.53515625,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T06:00:00Z","_value":43.51953125,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T08:00:00Z","_value":59.546875,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T10:00:00Z","_value":43.1875,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T12:00:00Z","_value":41.0390625,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T12:15:13.804669687Z","_value":44.29296875,"_field":"device_humidity","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T14:00:00Z","_value":22.2421875,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T16:00:00Z","_value":21.9921875,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T18:00:00Z","_value":21.8984375,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T20:00:00Z","_value":22.81640625,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-27T22:00:00Z","_value":22.66015625,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T00:00:00Z","_value":22.04296875,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T02:00:00Z","_value":22.265625,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T04:00:00Z","_value":21.75390625,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T06:00:00Z","_value":22.23046875,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T08:00:00Z","_value":21.51953125,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T10:00:00Z","_value":23.24609375,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T12:00:00Z","_value":23.34765625,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"_start":"2023-02-27T12:15:13.804669687Z","_stop":"2023-02-28T12:15:13.804669687Z","_time":"2023-02-28T12:15:13.804669687Z","_value":21.42578125,"_field":"device_temperature","_measurement":"mem","clockin":"1","device_mac":"BC5729008E48","gateway":"MOKO","gateway_id":"0016","gateway_insert":"1","gateway_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"}]",
"payloadType": "json",
"x": 110,
"y": 80,
"wires": [
[
"20f486b844849b60",
"5eb5c536426af046"
]
]
},
{
"id": "20f486b844849b60",
"type": "debug",
"z": "3b59e4113fc119b1",
"name": "debug 302",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 350,
"y": 140,
"wires":
},
{
"id": "5eb5c536426af046",
"type": "function",
"z": "3b59e4113fc119b1",
"name": "topic & 10",
"func": "var arr = msg.payload[0] ;\n\nvar thetime, name, mac,data;\n\n\nthetime = (msg.payload[0]._time); // Some manipulation of the time may be required\ndata = msg.payload[0]._value;\nname = msg.payload[0].device_info;\nmac = msg.payload[0].device_mac;\n\nvar i = 10;\nif(typeof arr === undefined) {\n return ;\n} else {\n msg.payload = arr; \n msg.topic = 'Device Information';\n return msg;\n}",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": ,
"x": 320,
"y": 220,
"wires": [
[
"26b65c6f186cfa4d"
]
]
},
{
"id": "26b65c6f186cfa4d",
"type": "template",
"z": "3b59e4113fc119b1",
"name": "html",
"field": "payload",
"fieldType": "msg",
"format": "html",
"syntax": "mustache",
"template": "\n\n<table border="0">\n \n \n Device MAC\n Alias Name\n Temperature\n \n {{#payload}}\n <tr class="">\n {{device_mac}} \n {{device_info}}\n # {{_value}}\n \n \n {{/payload}}\n\n",
"output": "str",
"x": 610,
"y": 220,
"wires": [
[
"02abd971817e5cb1",
"da7c6e36ebff7dbb"
]
]
},
{
"id": "da7c6e36ebff7dbb",
"type": "file",
"z": "3b59e4113fc119b1",
"name": "",
"filename": "test.txt",
"filenameType": "str",
"appendNewline": true,
"createDir": true,
"overwriteFile": "false",
"encoding": "none",
"x": 930,
"y": 200,
"wires": [

]
},
{
"id": "02abd971817e5cb1",
"type": "debug",
"z": "3b59e4113fc119b1",
"name": "debug 303",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 950,
"y": 240,
"wires":
}
]

4

Did you look into doing it with Grafana.

5

Can you help on this !!!

6

Help with what? Generating PDF files from Grafana?

I have not done it, but I googled for
grafana generate pdf
and there were numerous hits that suggested that this could be done. If I were doing it I would start by looking at those.

7

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.