How to parse json and insert into mysql from MQTT ChipStack in Golang

Applications
1

How to parse json and insert into mysql from MQTT ChipStack in Golang?

I need three parameter in below json,
“dev_EUI”:“test03”,
“temperature”:20.66
“humidity”:32.15

{“applicationID”:“61”,
“applicationName”:
“test”,
“dev_Name”:“test03”,
“dev_EUI”:“test03”,
“rxInfo”:[{“gatewayID”:“test84b”,“uplinkID”:“test2bab”,“name”:“test-684B”,“rssi”:-110,“loRaSNR”:-13.5,“location”:{“latitude”:0,“longitude”:0,“altitude”:0}}],
“txInfo”:{“frequency”:487700000,“dr”:0},
“adr”:true,“fCnt”:23882,“fPort”:2,“data”:“testAyP”,
“object”:{“Decoded”:[{“name”:“temperature”,“type”:103,“value”:20.66},{“name”:“humidity”,“type”:104,“value”:32.15}],“Payload”:“670812680c8f”,“isController”:false},
“tags”:{“group”:“2”}}

Thanks so much for any advice.

2

Have not understand your question.

I think you just parse chirpstack event data and save data what you need .

3

Yes, I would like to delete this post. Do you know how to delete it?