Ncd device string data to sql using mssql plus node

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)

image