(Excel) api.db-ip.com IPv4 Geolocation Lookup

Demonstrates how to lookup Geolocation data for an IPv4 address using the api.db-ip.com REST API.

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Lookup an IPv4 address: 149.250.207.170  (this was a randomly chosen address)

jsonStr = http.QuickGetStr("http://api.db-ip.com/v2/free/149.250.207.170")
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.EmitCompact = False

success = json.Load(jsonStr)

Debug.Print json.Emit()

' Sample output:
' Use this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON

' {
'   "ipAddress": "149.250.207.170",
'   "continentCode": "EU",
'   "continentName": "Europe",
'   "countryCode": "DE",
'   "countryName": "Germany",
'   "stateProv": "Baden-W\u00fcrttemberg",
'   "city": "B\u00f6blingen"
' }

ipAddress = json.StringOf("ipAddress")
continentCode = json.StringOf("continentCode")
continentName = json.StringOf("continentName")
countryCode = json.StringOf("countryCode")
countryName = json.StringOf("countryName")
stateProv = json.StringOf("stateProv")
city = json.StringOf("city")