Iterating through message's child array in SQL Query

[bppuck]

Hi,
I need help figuring out how to instantiate a SQL variable with an array value, or find another method to accomplish iterating through a child array within the message. The results from my attempt are producing empty results:

{"jsonVersion":1,"deviceProperties":{"version":{"value":"1.0"},"deviceId":{"value":"a123456789"}},"records":[{"dataType":{"value":"weightMeasurement"},"weight":{"value":12,"unit":"lbs"},"measurementTime":{"value":"2020-07-08 17:39:59"}}]}

Using: node-red-contrib-mssql-plus v0.4.4

[Steve-Mcl]

Hi, in this scenario, I move the logic outside of SQL and back to node-red.

E.g. your insert data is in an array, send it through a split node, then you will get multiple msgs sent to the SQL node where you would insert each record.

[bppuck]

Thank you for the quick response. I'll learn how to split it first then.