Handle NULL Values in MySQL Node

[mcnaveen]

Sometimes Specific Value from WooCommerce Trigger Nodes comes empty (Optional Field on Checkout)

If it comes empty, the MySQL Node shows an error.

If I can handle NULL values in MySQL Node. It’ll be really awesome.

[jan]

Not sure if I understand. The problem is not n8n, the problem is in MySQL. The column is set up in a way that it can not be set to null. If you want to be able to set it to null you would have to make that change in MySQL.

If you want to instead of saving null simply set an empty string, you can change your expression to:

{{$node["WooCommerce Trigger"].json["meta_data"][2]["value"] || ''}}

[mcnaveen]

You’re right @jan

I changed in my DB and it works now.

[jan]

Great to hear that it works now! Have fun!