Json datasource variable query

How do I make a variable with the JSON datasource, by using a query? I want to make a selection menu with the variable. The idea is to show only the data from an specific row.

Example:
ID | FOOD | PRICE
0 | CORN | 10
1 | BEANS| 20
.
.

I want to show only data from an specific ID for example, if i select 0 should only show CORN and 10 in two specific panels. Is that possible?

Thanks!

1 Like