Hello, this query is giving me a headache for some unknown reason. The sql table datatypes are all Decimal(18,3) EXCEPT nodeID which is int and addr which is varchar(50). addr is showing up as an empty string in my table. It stopped throwing an error after I added the single quotes but the address does not show up.
INSERT INTO [track].[sensor_data]
(nodeID,rms_x,rms_y,rms_z,max_x,max_y,max_z,min_x,min_y,min_z,amps,vibration_temperature,thermocoupler_temperature,battery,addr)
VALUES (
{{{data.nodeId}}},
{{{payload.rms_x}}},
{{{payload.rms_y}}},
{{{payload.rms_z}}},
{{{payload.max_x}}},
{{{payload.max_y}}},
{{{payload.max_z}}},
{{{payload.min_x}}},
{{{payload.min_x}}},
{{{payload.min_x}}},
{{{payload.current}}},
{{{payload.vibration_temperature}}},
{{{payload.thermocouple_temperature}}},
{{{data.battery}}},
‘{{{payload.addr}}}’
)