Modbus to mySQL flow suggestions

[smanjunath211]

this thread may interest you...

Building a dynamic msg.topic to create a mysql insert statement

Yes, understood, really useful. I even got it to work without naming the field names before VALUES clause, as i am updating ALL the fields. msg.topic = "INSERT INTO cc VALUES (:rdate, :totalcases, :totalcl, :caseperman, :costpercase, :cpm, :cpc)"; msg.payload = { "totalcases": 1234, "rdate": "2025-07-03", "caseperman": 49, "totalcl": 25, "costpercase": 39, "cpc": 25, "cpm": 52, } EDIT: Extremely Sorry @fogmajor for hijacking your thread. I will stop.