Get Geolocation Data from IP by using QlikSense Rest Connector

micheledenardi — Thu, 19 Oct 2017 09:14:51 GMT

Hi Experts,

is there someone who know if is it possible to geo-localize at country level a list of IPs by using WebServices and QlikSense Rest connector ?

I've got a list of public IPs and i would like to know from which country they are from.

Thanks

Re: Get Geolocation Data from IP by using QlikSense Rest Connector

micheledenardi — Tue, 31 Oct 2017 11:36:05 GMT

By using the free service IP Geolocation online API‌ which support Rest connection i have built this call:

set vMyApyKey='xxxxxxxxx';
set vIpAddress='xxx.xxx.xxx.xxx';

let vConnection='Provider=QvRestConnector.exe;url=http://api.db-ip.com/v2/'& vMyApyKey & '/'& vIpAddress &';timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;XUserId=TestUse;XPassword=TestUserPsw;';


CUSTOM CONNECT TO "$(vConnection)";

RestConnectorMasterTable:
SQL SELECT
"ipAddress",
"continentCode",
"continentName",
"countryCode",
"countryName",
"stateProv",
"city"
FROM JSON (wrap on) "root";

[root]:
LOAD
[ipAddress],
[continentCode],
[continentName],
[countryCode],
[countryName],
[stateProv],
[city]
RESIDENT RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;

after this solution i have found also another easier way by using http://freegeoip.net:

set vIpAddress='xxx.xxx.xxx.xxx';

let vConnection='Provider=QvRestConnector.exe;url=http://freegeoip.net/csv/'& vIpAddress &
';timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;XUserId=XXX;XPassword=XXX;';

CUSTOM CONNECT TO "$(vConnection)";

RestConnectorMasterTable:
SQL SELECT
"col_1",
"col_2",
"col_3",
"col_4",
"col_5",
"col_6",
"col_7",
"col_8",
"col_9",
"col_10",
"col_11"
FROM CSV (header off, delimiter ",", quote """") "CSV_source";

[CSV_source]:
LOAD [col_1],
[col_2],
[col_3],
[col_4],
[col_5],
[col_6],
[col_7],
[col_8],
[col_9],
[col_10],
[col_11]
RESIDENT RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;

By using both soultion, the result is the same:

Re: Get Geolocation Data from IP by using QlikSense Rest Connector

davyd — Thu, 28 Jul 2022 14:13:13 GMT

olá, estou tentando usar esse script e sempre da erro.

topic Re: Get Geolocation Data from IP by using QlikSense Rest Connector in App Development

Get Geolocation Data from IP by using QlikSense Rest Connector

Re: Get Geolocation Data from IP by using QlikSense Rest Connector

Re: Get Geolocation Data from IP by using QlikSense Rest Connector