The URL that gets the map uses the long and lat, so you'd need a way of linking your postcodes to this. you cant calculate the coords from the postcode so you'd have to have a list of all uk postcodes and their coords.
This is a great pointer. Unfortunately, geocoding is not for real-time user interface & they recommend to download the data & store it ahead of time. Has anyone actually implemented geocoding API?
I have a table Transaction ID, address, city, state & zip. I would like to create a table Transaction ID, latitude & longitude. I would like to get help on how to call the API in a look & get the above table.
I did it on Java. It has pretty good response time. All what you need is just accurately fulfill all necessary parameters and make an HTTP request, after that you need to parse a response by JSON library functions.
It is definitely not about QlikView. You can do this on a database or an application side with some limitation from Google:
Use of the Google Geocoding API is subject to a query limit of 2,500 geolocation requests per day. (User of Google Maps API Premier may perform up to 100,000 requests per day.) This limit is enforced to prevent abuse and/or repurposing of the Geocoding API, and this limit may be changed in the future without notice. Additionally, we enforce a request rate limit to prevent abuse of the service. If you exceed the 24-hour limit or otherwise abuse the service, the Geocoding API may stop working for you temporarily. If you continue to exceed this limit, your access to the Geocoding API may be blocked.
Note: the Geocoding API may only be used in conjunction with a Google map; geocoding results without displaying them on a map is prohibited. For complete details on allowed usage, consult the Maps API Terms of Service License Restrictions.
