I want to use the WorldMap plugin, fot that lon and lat is needed. My database table only has country and postal code. I plan to use an open source API’s to convert the address to lon and lat.
My plan was to dynamically add a lon and lat column, after grafana makes the table from my API query where only the country and postal code is returned.
Is there a way to add the two lon and lat colums and fill them with the result of a (new) query (using the API to convert address to lon/lat) in order to get the WorldMap to work?