Microsoft SQL return no data

[Len]

Microsoft SQL return no data

When I try to run a SQL query and there’s no data to return, it returns an empty array. When I try to run an if and enter the data to validate, like {{Object.keys($items()[0].json).length === 0}}, it doesn’t work; the node closes.

• n8n version: 1.92.2
• Database :Microsoft SQL
• Running n8n via n8n cloud

[simon.lewis]

Hi Len,

I would make sure the SQL Server node settings are set to Always Output Data and change the IF node to check if an item exists / does not exist in the JSON from the SQL node. For example:

Any use ?

Rgds
Simon