MySQL JSON Column type

Hi guys,

I have a http service that return the JSON data, and I have mysql json column type, how to persist this data as json in json column type?

Hey @Ivanir_Broinizi!

Welcome to the n8n community! :slightly_smiling_face:

You can the Query operation to and write a query to add the value. You will have to select the JSON value through an expression. Below is an example workflow that might help. I am using a Webhook node to get the JSON data from a webhook request. I am then using the Function node to transform the data received from the Webhook node. And then in the MySQL node I am using a query to insert the data.

Hope this helps. :slightly_smiling_face:

Thx @harshil1712

1 Like