The “_msgid” does not matter, used in node-red to ID the JSON packet.
This is a setting in your Influx DB, read there documentation on retention policies.
Far to many nodes needed.
Look at this flow.
[
{
"id": "153ff67d1f2c61b8",
"type": "tab",
"label": "Flow 2sddsdvv",
"disabled": false,
"info": "",
"env": []
},
{
"id": "8e52c3ed8907ee0c",
"type": "mqtt in",
"z": "153ff67d1f2c61b8",
"name": "Füllstand Quelle",
"topic": "v3/DEVICEID@ttn/devices/+/up",
"qos": "2",
"datatype": "json",
"broker": "0a4f4fef6fee57c6",
"nl": false,
"rap": true,
"rh": 0,
"inputs": 0,
"x": 220,
"y": 260,
"wires": [
[
"059296a9a604036f"
]
]
},
{
"id": "059296a9a604036f",
"type": "change",
"z": "153ff67d1f2c61b8",
"name": "change node",
"rules": [
{
"t": "set",
"p": "payload.Distance",
"pt": "msg",
"to": "payload.uplink_message.decoded_payload.Distance",
"tot": "msg"
},
{
"t": "set",
"p": "payload.dev_eui",
"pt": "msg",
"to": "payload.end_device_ids.dev_eui",
"tot": "msg"
},
{
"t": "delete",
"p": "payload.uplink_message",
"pt": "msg"
},
{
"t": "delete",
"p": "payload.correlation_ids",
"pt": "msg"
},
{
"t": "delete",
"p": "topic",
"pt": "msg"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 510,
"y": 260,
"wires": [
[
"a99ae555ccc4abb5",
"c4aa3711222d1081"
]
]
},
{
"id": "1ae3c6d92610a908",
"type": "debug",
"z": "153ff67d1f2c61b8",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 530,
"y": 360,
"wires": []
},
{
"id": "c4aa3711222d1081",
"type": "debug",
"z": "153ff67d1f2c61b8",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": true,
"complete": "true",
"targetType": "full",
"statusVal": "dev_eui",
"statusType": "auto",
"x": 850,
"y": 360,
"wires": []
},
{
"id": "60f39d916a35dd8b",
"type": "inject",
"z": "153ff67d1f2c61b8",
"name": "Test Json",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "{\"topic\":\"v3/compact-tracker-abeeway@ttn/devices/eui-20635f0161000093/up\",\"payload\":{\"end_device_ids\":{\"device_id\":\"eui-dhdfth\",\"application_ids\":{\"application_id\":\"fjdjdy\"},\"dev_eui\":\"hth3\",\"join_eui\":\"hrhxf\",\"dev_addr\":\"hhF\"},\"correlation_ids\":[\"as:up:01FPZ2ZC6PJQE0XQ68ECN239B7\",\"gs:conn:01FNXTS68EYM139F0J53QR5ZK0\",\"gs:up:host:01FNXTS699E4A2H7VSP45SZG62\",\"gs:uplink:01FPZ2ZC04E8WTWP10DHJX97S6\",\"ns:uplink:01FPZ2ZC0568ACBK2MBZQK4148\",\"rpc:/ttn.lorawan.v3.GsNs/HandleUplink:01FPZ2ZC052XX7N17EDTRCYW6D\",\"rpc:/ttn.lorawan.v3.NsAs/HandleUplink:01FPZ2ZC6MRZ4WAM86KEJC7J6B\"],\"received_at\":\"2021-12-15T13:02:16.279389076Z\",\"uplink_message\":{\"session_key_id\":\"AX23nQJEOCVpz1fId9ugRw==\",\"f_port\":18,\"f_cnt\":182,\"frm_payload\":\"BSBhigAQAgAAAwIA\",\"decoded_payload\":{\"ack\":0,\"batteryPersentage\":97,\"bleFirmware\":\"bleFwVersion3.2.0\",\"data\":0,\"Distance\":512,\"debug\":{\"length\":12,\"payload\":\"0520618a0010gfhfg030200\",\"port\":18,\"server_time\":\"2021-12-15T13:02:16.283Z\"},\"lastResetCause\":\"lastResetCause: 16\",\"mcuFirmware\":\"fwVersion: 2.0.0\",\"status\":{\"mode\":{\"code\":1,\"description\":\"Motion tracking\"},\"moving\":false,\"on_demand\":false,\"periodic\":false,\"sos\":false,\"tracking\":false},\"temperature\":25.81,\"type\":\"HEARTBEAT\"},\"rx_metadata\":[{\"gateway_ids\":{\"gateway_id\":\"dhdth-mdhdfhfn-01-dbn\",\"eui\":\"3dhdfhdfgh0\"},\"time\":\"2021-12-15T13:02:15.958012Z\",\"timestamp\":534735231,\"rssi\":-109,\"channel_rssi\":-109,\"snr\":1.75,\"location\":{\"latitude\":-505059.885050571,\"longitude\":5050.905081617,\"altitude\":225,\"source\":\"SOURCE_REGISTRY\"},\"uplink_token\":\"CiIKIAoUdGVjaDUtbWFsdmVybi0wMS1kYm4SCDQ2MjgkAFAAEP/S/f4BGgsI2M7njQYQ1+/aICCYsNCFyP3/ASoMCNfO540GEOC06MgD\",\"channel_index\":4}],\"settings\":{\"data_rate\":{\"lora\":{\"bandwidth\":125000,\"spreading_factor\":7}},\"coding_rate\":\"4/5\",\"frequency\":\"867300000\",\"timestamp\":534735231,\"time\":\"2021-12-15T13:02:15.958012Z\"},\"received_at\":\"2021-12-15T13:02:16.069864716Z\",\"consumed_airtime\":\"0.061696s\",\"locations\":{\"frm-payload\":{\"latitude\":-29.8889728,\"longitude\":30.916608,\"source\":\"SOURCE_GPS\"}},\"network_ids\":{\"net_id\":\"000013\",\"tenant_id\":\"ttn\",\"cluster_id\":\"ttn-eu1\"}}},\"qos\":0,\"retain\":false,\"_msgid\":\"d38de075552048d0\"}",
"payloadType": "json",
"x": 230,
"y": 360,
"wires": [
[
"99997bbb40d80fb0"
]
]
},
{
"id": "99997bbb40d80fb0",
"type": "change",
"z": "153ff67d1f2c61b8",
"name": "Test Json",
"rules": [
{
"t": "set",
"p": "payload",
"pt": "msg",
"to": "payload.payload",
"tot": "msg"
}
],
"action": "",
"property": "",
"from": "",
"to": "",
"reg": false,
"x": 360,
"y": 360,
"wires": [
[
"059296a9a604036f",
"1ae3c6d92610a908"
]
]
},
{
"id": "3f4efbddb8220f44",
"type": "comment",
"z": "153ff67d1f2c61b8",
"name": "For Testing",
"info": "",
"x": 210,
"y": 320,
"wires": []
},
{
"id": "a99ae555ccc4abb5",
"type": "function",
"z": "153ff67d1f2c61b8",
"name": "level",
"func": "msg.payload.Füllmenge = (2300 - msg.payload.Distance)*2.32388\n\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 700,
"y": 260,
"wires": [
[
"c4aa3711222d1081"
]
]
},
{
"id": "0a4f4fef6fee57c6",
"type": "mqtt-broker",
"name": "Füllstand Quelle",
"broker": "eu1.cloud.thethings.network",
"port": "1883",
"clientid": "",
"autoConnect": true,
"usetls": false,
"protocolVersion": "4",
"keepalive": "60",
"cleansession": true,
"birthTopic": "",
"birthQos": "0",
"birthPayload": "",
"birthMsg": {},
"closeTopic": "",
"closeQos": "0",
"closePayload": "",
"closeMsg": {},
"willTopic": "",
"willQos": "0",
"willPayload": "",
"willMsg": {},
"sessionExpiry": ""
}
]