For each value in an array of an API response, create a new row in a SQL table?

[bradlymathews]

Ah, I missed the part about the new row.

In that case just use a Bulk Insert query. You will need to create a transformer that will create an array of objects with properties that have the same names as your table. Pass that array into the Array of records to insert setting.

Here are some references to get you started:

https://docs.retool.com/docs/sql-writes#bulk-updates

How do I add multiple rows to table in PostgreSQL?

I improved this a bit. In the make array query, just return the array rather than set the temp var. // jsMakeBulkBundleArray var newData = []; tblLineItems.selectedRow.data.forEach(row => { newData.push({ line_item_id: row.line_item_id, bundled_sku: tblProducts.selectedRow.data[0].sku }) }); return newData In your main query use the returned value to pass it to the bulk query: // jsBulkBundle jsMakeBulkBundleArray.trigger({ onSuccess:function(data) { qryBulkBund…