Hey there @Dymalle!
It looks like you have a repeating list of text components here, is that correct? If so, you might want to use this pattern to call your query for each item in the list.
If you want to set a value on an object in the Retool model, or trigger a query, you'll need to call the corresponding method. For setting the value on a temporary state that would be yourTempstate.setValue(), and for triggering a query that's yourQuery.trigger(). There's a great post on how to pass values to triggered queries here!
All of the above is best done in a JavaScript query. Transformers (either standalone or any expression in {{}}) are re-evaluated whenever one of their inputs is re-evaluated which makes any expression with side-effects really volatile, and many functions like query triggers don't work in them.
Let me know if any of those docs are helpful or raise additional questions!