AES_DECRYPT in MYSQL node?

Questions
1

Good morning,

I’m having an issue with the function " AES_DECRYPT " from MYSQL in n8n. I have been testing some querys using the function AES_DECRYPT in my mysql server and they are working perfectly. But when I copy and paste these querys on MYSQL node from n8n, the results are never decrypted.

I’m new on this platform, so maybe you have some advice to fix this issue.

Thank you a lot,
Cemcat

2

I just found the way to fix this problem. After the MYSQL node result, you add a new “Function” node where you can access to the results. In my case I made the following:
items[0].json.name = Buffer.from(items[0].json.name.data).toString(‘utf-8’);

That’s it!
Cemcat

1 Like