Api problem with columns to be selected

Hey all, i wanna select from this only firstname and lastname. Now i have in results - error, data, results so i cannot do sql query there.

Hi @vilden, what do you intend to do with the firstname and lastname?
The response is good enough and you can manipulate this already by using {{query1.data.result.data}}. You can use this in a table component so you can visually see your data. Check your left-panel as well on how your query1 data is structured. What I used above might not be the case.

Depending on how you are going to use this result, you might want to do some JS transformer to make it work on your SQL query.

Lemme know what you think about this