Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
eduardo_dimperio
Specialist II
Specialist II

Problem with a REST connector using WITH CONNECTION

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

image.png

 

I dont know why in this case i get a different lat long using the same API

Labels (2)
0 Replies