I want to create a workflow that backup the entire data table daily, but currently there is no option to list each table on the Data Table node, so I can’t do it.
Could you create something like “Get many data tables” menu on Data Table node? This would be helpful!
Thanks!
Hi @Mollly,
I think it’s possible to get all rows from the data table, convert them into a CSV file, and then back it up somewhere:
The only trick is that when importing the CSV, the id, createdAt, updatedAt columns are reserved and as a result they will either be created with new names, or you’ll need to delete them and use the newly generated values. (this is if you use/need these columns in your workflow)
However, if you have access to your PostgreSQL database, you can import the data table without any issues, as the backup preserves the data exactly as-is. (by inserting the rows into the table)
Hardcoding IDs to manage multiple tables isn’t scalable and makes maintenance tricky as data changes. The “Get many” action would clearly be the best option—cleaner and aligned with n8n’s modular approach. Using the internal API can be a workaround but isn’t accessible or practical for everyone.