Is it possible to run a new query with data from another query?

Grafana Dashboards
1

I have a query (one API call) that returns latitude and longitude fields. I would like to take those two fields and run a separate query (separate API call) to display the address given those coordinates. Is there anyway I could reference the returned fields I have in the first query and use those to run the second API call?

For example, I’m collecting the below data from one query:

C20Dbark
C20Dbark1929×565 81.2 KB

and in theory, I would like to reference those values in query 2 as the input params:

Jpgw1QZ2
Jpgw1QZ21952×519 48.7 KB

As far as I can tell via my Googling and searching StackOverflow, it’s not possible. However I’d like to verify before I give up…

2

welcome @KenGrafana

how many rows of lon/lat are coming from first query?

3

It’s dynamic - you can select multiple variables or one, however per variable there should be only one row

4

What database management systems allow running a new query using data from another query?

5

I am using API calls here. One call I can receive the coordinates, then I need to run another call to get the address. If it was database directly, sure I could just use some joins but this isn’t the case…

6

will the user be selecting from a list of lon,lats? like a drop down or something?

one way is present the lon,lat on left side but display City Name

on the right you show addresses

image
image1597×412 50.2 KB