Inserting an array into postgresdb using a JS query

[hugowaller]

I have a JS Query that triggers a SQL GUI using an array made by a transformer, but i cant get it to work

const array = comment_array_maker.value;
var len = comment_array_maker.value.length;

for (var i=0;i<len;i++) {
  const row = array[i];
  array_inserter.trigger({
    additionalScope : {
    source_id: row[0],
    doc_id: row[1],
    url: row[2],
    time_inserted: row[3],
    operator_name: row[4],
    operator_comment: row[5],
    source_comment: row[6],
    match_code: row[7],
    match_type: row[8]
  }  
});
}

If my js Query is correct what am i supposed to put in the postgresdb insert query?

[AnsonHwang]

@hugowaller

t_a

In SQL GUI, it should be something like this.

In you case is source_id -- {{source_id}}

here is a guide

How to use additional scope (additionalScope) in your queries

Why use additionalScope When writing queries you'd like to reuse with different input value(s), Retool's additionalScope might be helpful! See our docs here and some more in depth examples below. How to use additionalScope The additionalScope option allows you to pass variables to the query that aren't already defined in the global scope (e.g. text1.value). In order to use additionalScope, you must first trigger a query in an event handler or using the .trigger() method in a JS query. [imag…

and some related docs

Web app tutorial: Write custom logic | Retool Docs