The attached extension object (bottom of post) is to be used with QlikView Expressor 3.9.x and can be installed and enabled in a QVE Workspace. The extension object has been built using QlikView Expressor Datascript and the new SDK Extension Builder. Please see the above mentioned link for more on building your own extensions.
A customer needed the ability to enrich their data sets with additional location information including gecoding those locations for mapping purposes. All they had as input was a list of IP addresses (from logs or DB queries) that were accessing their systems. They wanted this process to be reusable, repeatable and shareable with other applications and development groups.
The attached extension () is provided as a QlikView Expressor Transform Operator which accepts incoming IP addresses. It then geocodes them using a free RESTful web service API (http://freegeoip.net/) and provides the following additional location data:
country_code country_name region_code region_name city zipcode latitude longitude metro_code areacode
Custom properties for the extension simply include the ability to toggle the returned results in the Results pane as well as set a sleep time in between API calls. This may be necessary as the web service may have time period execution query limits on the number of results that are returned.