API Google Maps

[NicholeBolivar1]

Hello everyone, I have an excel file with addresses and I need to obtain the latitude and longitude, I have seen that a google maps API can be used, but I don't know how to use it in Qlik Sense. Any help please?

[stevedark]

HI @NicholeBolivar1 

Google changed their charging structure a while back, so I moved to using MapQuest for a couple of clients and this works quite well:

https://developer.mapquest.com/

I have found that you have to try different calls to get good results, and if you can set boundaries (i.e. if you know all addresses are in a certain country).

Steve

[stevedark]

Hi @NicholeBolivar1 

Google changed their pricing structure, so I moved to using MapQuest for some clients. Details of the API are here:

https://developer.mapquest.com/

I found that you have to make a couple of calls to get the right result some times, and it works a much better if you can specify bounds to look within (i.e. if you know all addresses are in one country).

Hope that helps,

Steve

[stevedark]

Hi @NicholeBolivar1 

I would suggest looking at the MapQuest API https://developer.mapquest.com/

Steve