var newMsg = { payload: msg.payload };
if (typeof msg.payload.ProgramNumber === "undefined") msg.payload.ProgramNumber = 0;
if (typeof msg.payload.NumOfLeaks === "undefined") msg.payload.NumOfLeaks = 0;
if (typeof msg.payload.FsFlow === "undefined") msg.payload.FsFlow = 0;
if (typeof msg.payload.MsFlow === "undefined") msg.payload.MsFlow = 0;
if (typeof msg.payload.Ds1Flow === "undefined") msg.payload.Ds1Flow = 0;
if (typeof msg.payload.SpruFlow === "undefined") msg.payload.SpruFlow = 0;
if (typeof msg.payload.Jc1Flow === "undefined") msg.payload.Jc1Flow = 0;
if (typeof msg.payload.Jc2Flow === "undefined") msg.payload.Jc2Flow = 0;
if (typeof msg.payload.Jc3Flow === "undefined") msg.payload.Jc3Flow = 0;
if (typeof msg.payload.Jc4Flow === "undefined") msg.payload.Jc4Flow = 0;
if (typeof msg.payload.FacFlow === "undefined") msg.payload.FacFlow = 0;
if (typeof msg.payload.JcFlow === "undefined") msg.payload.JcFlow = 0;
if (typeof msg.payload.FacPress === "undefined") msg.payload.FacPress = 0;
if (typeof msg.payload.JcPress === "undefined") msg.payload.JcPress = 0;
if (typeof msg.payload.Ds2Flow === "undefined") msg.payload.Ds2Flow = 0;
newMsg.topic = `INSERT INTO SSreadings (ProgramNumber, NumOfLeaks, FsFlow, MsFlow, Ds1Flow, SpruFlow, Jc1Flow, Jc2Flow, Jc3Flow, Jc4Flow, FacFlow, JcFlow, FacPress, JcPress, Ds2Flow) VALUES (${msg.payload.ProgramNumber.value}, ${msg.payload.NumOfLeaks.value}, ${msg.payload.FsFlow.value}, ${msg.payload.MsFlow.value}, ${msg.payload.Ds1Flow.value}, ${msg.payload.SpruFlow.value}, ${msg.payload.Jc1Flow.value}, ${msg.payload.Jc2Flow.value}, ${msg.payload.Jc3Flow.value}, ${msg.payload.Jc4Flow.value}, ${msg.payload.FacFlow.value}, ${msg.payload.JcFlow.value}, ${msg.payload.FacPress.value}, ${msg.payload.JcPress.value}, ${msg.payload.Ds2Flow.value});`
return newMsg;
Is this correct when adding to my Original Script?