Steve-Mcl,
I noticed I may have not clarified the item I am trying to get into the db. data.sensor_name (Temperature/Humidity) is the sensor_name value.
Thanks for the msg.query info.
Is this what you are referring to for 'full output'?
INSERT INTO [temperaturehumidity] (temp,humidity,nodeID,voltage,SensorName) VALUES (18.86*1.8+32,29.59,0,3.2940600000000004,Temperature/Humidity)
After looking at it it appears that Temperature/Humidity (the sensor name) is missing ' before and after the value. So it should be 'Temperature/Humidity' to properly go into the sql db. I am assuming I need to append the value to include the apostrophes.
On the separate note you pointed out about temp and humidity data.....
It appears I can get it from either data.sensor_data.temperature (humidity) or payload.temperature (humidity)