incorporating API for geoanalytics (lat, long)

[124rooski]

What would be the best way to pull latitude and longitude data for the us of geoanalytics? My goal is to be able to plot stores worldwide and city, state, country dimensions are giving me some trouble whereas coordinates are plotting the data points precisely with a sample set I created. Should I be looking for an API and possibly do a look up in the database or is there a simpler method to do that in the front end in qlik itself? Thoughts are all appreciated.

[lorenzoconforti]

You can call an API service in your script (like Bing); it would return json/xml based on an input address:

https://docs.microsoft.com/en-us/bingmaps/rest-services/locations/find-a-location-by-address

In the response data there would be also latitude and longitude