Hi, i have a question about using a rest connection.
I did two extractions on google using the same API with divergent results:
1- API by Browser
https://maps.googleapis.com/maps/api/geocode/json?address=AV+NILO+PECANHA,1928,LJ,CENTRO(DC)DUQUE+DE...
2- API by Rest Connection
RestConnectorMasterTable:
SQL SELECT
"status",
"__KEY_root",
(SELECT
"formatted_address",
"place_id",
"__KEY_results",
"__FK_results",
(SELECT
"long_name",
"short_name",
"__KEY_address_components",
"__FK_address_components",
(SELECT
"@Value",
"__FK_types"
FROM "types" FK "__FK_types" ArrayValueAlias "@Value")
FROM "address_components" PK "__KEY_address_components" FK "__FK_address_components"),
(SELECT
"location_type",
"__KEY_geometry",
"__FK_geometry",
(SELECT
"lat" AS "lat_u1",
"lng" AS "lng_u1",
"__FK_location"
FROM "location" FK "__FK_location")
FROM "geometry" PK "__KEY_geometry" FK "__FK_geometry"),
(SELECT
"@Value" AS "@Value_u0",
"__FK_types_u0"
FROM "types" FK "__FK_types_u0" ArrayValueAlias "@Value_u0")
FROM "results" PK "__KEY_results" FK "__FK_results")
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION(Url"https://maps.googleapis.com/maps/api/geocode/json?address=AV+NILO+PECANHA,1928,LJ,CENTRO(DC),DUQUE+DE+CAXIAS&key=MyKey");
Results:
1 - Browser
"formatted_address" : "Av. Nilo Peçanha, 1928 - Parque Lafaiete, Duque de Caxias - RJ, 25015-500, Brasil",
"geometry" : {
"location" : {
"lat" : -22.7890967,
"lng" : -43.3272876
2-Qlik Sense
I dont know why in this case i get a different lat long using the same API