@Colin
The sensors are from a local startup so I cant really blame them. I wont say their name but you can sort of see the company name from the debug node in the image 
Anyways I managed to change the colon to a period with help from this stackoverflow question
[{"id":"1fbd3937e7927ca0","type":"change","z":"2c8ee17f.1fe80e","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"[\t {\t \"measurement\": msg.topic,\t \"fields\": msg.payload,\t \"timestamp\": msg.timestamp\t }\t] ","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":760,"y":520,"wires":[["c66c890a2dedeaba","3645eb887c954b5b"]],"info":"To change the "},{"id":"e3cd5154ee418319","type":"inject","z":"2c8ee17f.1fe80e","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"},{"p":"timestamp","v":"2022-03-22T06:17:28:410209Z","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"topic","payload":"{\"measurement\":69}","payloadType":"json","x":250,"y":520,"wires":[["48b7c4a188773e04"]]},{"id":"c66c890a2dedeaba","type":"debug","z":"2c8ee17f.1fe80e","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1040,"y":520,"wires":[]},{"id":"3645eb887c954b5b","type":"influxdb batch","z":"2c8ee17f.1fe80e","influxdb":"d32d1a0b4684e895","precision":"","retentionPolicy":"","name":"","database":"database","precisionV18FluxV20":"ms","retentionPolicyV18Flux":"","org":"Initial_Organization","bucket":"test","x":1040,"y":580,"wires":[]},{"id":"48b7c4a188773e04","type":"function","z":"2c8ee17f.1fe80e","name":"","func":"const input = msg.timestamp;\nlet t = 0\nconst result = input.replace(/:/g, match => ++t === 3 ? '.' : match)\nconst unixtime = new Date(result).valueOf();\nmsg.timestamp=unixtime;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":510,"y":520,"wires":[["1fbd3937e7927ca0","ccf3212992f4bcdb"]]},{"id":"ccf3212992f4bcdb","type":"debug","z":"2c8ee17f.1fe80e","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"timestamp","targetType":"msg","statusVal":"","statusType":"auto","x":790,"y":460,"wires":[]},{"id":"d32d1a0b4684e895","type":"influxdb","hostname":"127.0.0.1","port":"8086","protocol":"http","database":"database","name":"out","usetls":false,"tls":"","influxdbVersion":"2.0","url":"http://localhost:8086","rejectUnauthorized":true}]
Only thing left to do is figure out why the sensors give me values of a few days back.... the image I took was from today.
Thanks all for all your help!
