JSON to MySQL

Questions
1

I’m very new in N8N , could someone share or help how to build a workflow… that reads a JSON raw data and write to mysql database ?

i found just one topic, but… not so clear to me.

thanks.

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @Perseus_Perseus, welcome to the n8n community!

Did you do our Level 1 and 2 courses? See the Getting Started section on https://docs.n8n.io/. I highly recommend you do these as they’ll give you a solid understanding of how n8n works.

But basically, what you would do it:

  1. Parse the JSON into a data structure.
  2. Possibly split this data structure into separate ‘items’ which represent the rows to insert.
  3. Inside the MySQL node, map the data inside these items to the columns where you want them.
4

the concept i know… but “do” i dont know… like a told … im new in n8n

5

Did you complete our Level 1 and Level 2 course? You really should start there.

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.