Googleapis

kris_vliegen — Sat, 16 Nov 2024 20:32:12 GMT

Hi All,

I've a script to get the latitude and longitude out of an adress via this script:

LOAD
'$(k)' as %Customer,
[result/geometry/location/lat] as latitude,
[result/geometry/location/lng] as longitude
FROM [https://maps.googleapis.com/maps/api/geocode/xml?address=$(address)&key=AIzakeykeykey] (XmlSimple, Table is [GeocodeResponse]);

In Qlikview 11.2 it is working fine. A customer of us is using Qlikview November 2017 SR6 and it is'nt working anymore.

On my desktop I've installed the April 2019 SR1 and this is still not working.

In April 2019 SR1 I get "Cannot open file: 'https://maps.goog...

In November 2017 I get Unknown LOAD statement error

Who can help me with this?

Or how do you guys create a latitude and longitude in the script?

regards,

Kris

Re: Googleapis

kris_vliegen — Tue, 02 Jul 2019 14:37:50 GMT

Hi All,

I found the solution for the reload.

You can find the solution that worked for me here:

Regards,

Kris