Goal: Hello Retool Community, I am currently facing a challenge with implementing a bulk insert operation in SQL mode using JavaScript within Retool. My primary issue is that the result of my JavaScript expression is being treated as a string, which is causing syntax errors in the SQL query. H…

I solved the problem! Not using SQL mode, Use GUI mode. {{ TableFTLMatch.changesetArray.map(item => { return { ...item, "InsPayId": TableSelectIc.selectedRow.InsPayID, "EobMethod" : InputReconcilingEobMethod.value, "EobDate" : InputReconcilingEobDate.formattedValue…

Need Help with Bulk Insert Using JavaScript in SQL Mode

💬 Queries and Resources

jmann April 4, 2024, 6:00pm 5

Linking another thread where we bulk inserted with SQL mode so that we can return the newly created records

1 Like

Topic		Replies	Views
Bulk insert SQL mode. Is it possible? 💬 Queries and Resources sql , postgres	5	4305	May 6, 2024
Bulk insert - troubleshooting 💬 Queries and Resources	8	1611	October 23, 2023
Insert data into MariaDB table in bulk via csv 💬 Queries and Resources resource-connection , javascript , sql	4	172	April 24, 2025
Issues Inserting Multiple Rows Using Array of Objects in SQL with ReTool 💬 Queries and Resources javascript , mysql	3	470	September 23, 2024
Bulk update from single value 💬 App Building javascript , sql , table	10	847	May 27, 2024

Need Help with Bulk Insert Using JavaScript in SQL Mode

Related topics