Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (1)
0 Replies