Data Table Access in Code Node

Questions
1

Is there a way to access/update data in the new data tables in the code node? Don’t want to flip back-and-forth many times when manipulating data.

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

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

I’m quite interested in this too, as long as the base methods of data tables miss some key features (order by, count, distinct) that are required in many use cases

3

Hi, Mehulshahnj. Hi Daniele.

Here is an example of the way I access n8n data tables with a code node. It works well for my setup, but it is a two step approach:

  1. Webhook with incoming data
  2. Code node Javascript
  3. Handover to data tables

My n8n data table:

grafik
grafik1836×216 30.5 KB

My Code node:

grafik
grafik812×1188 100 KB

grafik
grafik1274×1562 162 KB

grafik
grafik1920×1813 204 KB

Handover to data table:

grafik
grafik786×1382 69.5 KB

Hope that helps for your case.

Best, Alf