Handle NULL Values in MySQL Node

Questions
1

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

image
image725×392 8.7 KB

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

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

image
image1175×243 26.5 KB

2

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"] || ''}}
1 Like
3

You’re right @jan

I changed in my DB and it works now.

1 Like
4

Great to hear that it works now! Have fun!

1 Like