Reducing/extracting JSON array into list for dropdown values

Queries and Resources
1

I have a “Query JSON with SQL query” that returns values in a key,value array.
I want just the values, not the key, to be available for a dropdown element.
What should I be writing as the source of values for the dropdown?
{{query1.data}}
gives a list in the dropdown as follows:
{{“mykey”:“1223”}}
{{“mykey”:“4324”}}
when what I want to appear in the dropdown is:
1223
4324
I can’t reduce the output to a list of values with {{query1.data.mykey}}

1 Like
2

Hi Gregor! You can get the value you want using {{ query1.data.map(d=>d.mykey) }}
Map returns a value for each thing in an array, and creates a new array of just the results. So for each entry in query1.data we want to return just the query1.data[i].mykey value

1 Like
3

Thanks Alex - perfect