Sample code for 30+ languages & platforms
SQL Server Requires Chilkat v11.0.0+

Look up an IP location with IPinfo Core

See more Geolocation Examples

Use an IPinfo token with Core, Plus, or Max access. The current api.ipinfo.io/lookup/ endpoint returns location fields inside geo and network fields inside as. Authenticate with a Bearer token.

IPinfo continues to support its older ipinfo.io API for existing integrations. This example uses the current Core response structure. The free Lite API uses /lite/ and a different, country-level response. Choose the endpoint and parser for your subscription.

IP geolocation estimates a network location. VPNs, mobile gateways, and anycast routing can affect the result. City and coordinate fields can be missing or approximate. The sample address 8.8.8.8 is a public DNS address used to demonstrate the request.

Service documentation

Chilkat SQL Server Downloads

SQL Server
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @iTmp1 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @sTmp1 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Assumes Chilkat is unlocked. See Global Unlock Sample.
    --  Use a public IP address. Provider results can change as their databases are updated.
    DECLARE @ipAddress nvarchar(4000)
    SELECT @ipAddress = '8.8.8.8'
    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @http, 'RequireSslCertVerify', 1
    EXEC sp_OASetProperty @http, 'ConnectTimeout', 10
    EXEC sp_OASetProperty @http, 'ReadTimeout', 30
    EXEC sp_OASetProperty @http, 'Accept', 'application/json'
    EXEC sp_OASetProperty @http, 'AuthToken', 'IPINFO_TOKEN'
    DECLARE @url int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @url OUT

    EXEC sp_OAMethod @url, 'Append', @success OUT, 'https://api.ipinfo.io/lookup/'
    EXEC sp_OAMethod @http, 'UrlEncode', @sTmp0 OUT, @ipAddress
    EXEC sp_OAMethod @url, 'Append', @success OUT, @sTmp0
    DECLARE @response int
    EXEC @hr = sp_OACreate 'Chilkat.HttpResponse', @response OUT

    EXEC sp_OAMethod @url, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @http, 'HttpNoBody', @success OUT, 'GET', @sTmp0, @response
    EXEC sp_OAGetProperty @response, 'StatusCode', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        --  Request diagnostics can contain an API key. Report transport failure without logging credentials.

        PRINT 'No HTTP response. Check connectivity, DNS, and TLS configuration.'
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @url
        EXEC @hr = sp_OADestroy @response
        RETURN
      END
    DECLARE @json int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT

    DECLARE @parsed int
    EXEC sp_OAGetProperty @response, 'BodyStr', @sTmp0 OUT
    EXEC sp_OAMethod @json, 'Load', @parsed OUT, @sTmp0
    EXEC sp_OAGetProperty @response, 'StatusCode', @iTmp0 OUT
    EXEC sp_OAGetProperty @response, 'StatusCode', @iTmp1 OUT
    IF (@success <> 1) or (@iTmp0 < 200) or (@iTmp1 >= 300)
      BEGIN

        EXEC sp_OAGetProperty @response, 'StatusCode', @iTmp0 OUT
        PRINT 'Lookup failed. HTTP ' + @iTmp0
        IF @parsed = 1
          BEGIN
            EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'error.title'
            IF @iTmp0 = 1
              BEGIN
                EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'error.title'
                PRINT @sTmp0
              END
            EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'error.message'
            IF @iTmp0 = 1
              BEGIN
                EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'error.message'
                PRINT @sTmp0
              END
          END
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @url
        EXEC @hr = sp_OADestroy @response
        EXEC @hr = sp_OADestroy @json
        RETURN
      END
    IF @parsed <> 1
      BEGIN

        PRINT 'Expected a JSON object in the lookup response.'
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @url
        EXEC @hr = sp_OADestroy @response
        EXEC @hr = sp_OADestroy @json
        RETURN
      END
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'error'
    IF (@iTmp0 = 3)
      BEGIN

        PRINT 'The service could not complete the lookup.'
        EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'error.title'
        IF @iTmp0 = 1
          BEGIN
            EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'error.title'
            PRINT @sTmp0
          END
        EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'error.message'
        IF @iTmp0 = 1
          BEGIN
            EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'error.message'
            PRINT @sTmp0
          END
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @url
        EXEC @hr = sp_OADestroy @response
        EXEC @hr = sp_OADestroy @json
        RETURN
      END
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'bogon'
    EXEC sp_OAMethod @json, 'BoolOf', @iTmp1 OUT, 'bogon'
    IF (@iTmp0 = 5) and (@iTmp1 = 1)
      BEGIN

        PRINT 'This is a reserved or otherwise non-public IP address.'
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @url
        EXEC @hr = sp_OADestroy @response
        EXEC @hr = sp_OADestroy @json
        RETURN
      END
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'ip'
    EXEC sp_OAMethod @json, 'StringOfEquals', @iTmp1 OUT, 'ip', '', 1
    IF (@iTmp0 <> 1) or (@iTmp1 = 1)
      BEGIN

        PRINT 'The response did not contain the expected IP address.'
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @url
        EXEC @hr = sp_OADestroy @response
        EXEC @hr = sp_OADestroy @json
        RETURN
      END

    EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'ip'
    PRINT 'IP address: ' + @sTmp0
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'geo.country'
    EXEC sp_OAMethod @json, 'StringOfEquals', @iTmp1 OUT, 'geo.country', '', 1
    IF (@iTmp0 = 1) and (@iTmp1 <> 1)
      BEGIN

        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'geo.country'
        PRINT 'Country: ' + @sTmp0
      END
    ELSE
      BEGIN

        PRINT 'Country: unavailable'
      END
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'geo.country_code'
    EXEC sp_OAMethod @json, 'StringOfEquals', @iTmp1 OUT, 'geo.country_code', '', 1
    IF (@iTmp0 = 1) and (@iTmp1 <> 1)
      BEGIN

        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'geo.country_code'
        PRINT 'Country code: ' + @sTmp0
      END
    ELSE
      BEGIN

        PRINT 'Country code: unavailable'
      END
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'geo.region'
    EXEC sp_OAMethod @json, 'StringOfEquals', @iTmp1 OUT, 'geo.region', '', 1
    IF (@iTmp0 = 1) and (@iTmp1 <> 1)
      BEGIN

        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'geo.region'
        PRINT 'Region: ' + @sTmp0
      END
    ELSE
      BEGIN

        PRINT 'Region: unavailable'
      END
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'geo.city'
    EXEC sp_OAMethod @json, 'StringOfEquals', @iTmp1 OUT, 'geo.city', '', 1
    IF (@iTmp0 = 1) and (@iTmp1 <> 1)
      BEGIN

        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'geo.city'
        PRINT 'City: ' + @sTmp0
      END
    ELSE
      BEGIN

        PRINT 'City: unavailable'
      END
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'geo.timezone'
    EXEC sp_OAMethod @json, 'StringOfEquals', @iTmp1 OUT, 'geo.timezone', '', 1
    IF (@iTmp0 = 1) and (@iTmp1 <> 1)
      BEGIN

        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'geo.timezone'
        PRINT 'Time zone: ' + @sTmp0
      END
    ELSE
      BEGIN

        PRINT 'Time zone: unavailable'
      END
    --  Missing coordinates stay unavailable. A numeric zero is a valid coordinate.
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'geo.latitude'
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp1 OUT, 'geo.longitude'
    IF (@iTmp0 = 2) and (@iTmp1 = 2)
      BEGIN

        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'geo.latitude'

        EXEC sp_OAMethod @json, 'StringOf', @sTmp1 OUT, 'geo.longitude'
        PRINT 'Coordinates: ' + @sTmp0 + ', ' + @sTmp1
      END
    ELSE
      BEGIN

        PRINT 'Coordinates: unavailable'
      END
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'as.asn'
    EXEC sp_OAMethod @json, 'StringOfEquals', @iTmp1 OUT, 'as.asn', '', 1
    IF (@iTmp0 = 1) and (@iTmp1 <> 1)
      BEGIN

        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'as.asn'
        PRINT 'ASN: ' + @sTmp0
      END
    ELSE
      BEGIN

        PRINT 'ASN: unavailable'
      END
    EXEC sp_OAMethod @json, 'JsonTypeOf', @iTmp0 OUT, 'as.name'
    EXEC sp_OAMethod @json, 'StringOfEquals', @iTmp1 OUT, 'as.name', '', 1
    IF (@iTmp0 = 1) and (@iTmp1 <> 1)
      BEGIN

        EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'as.name'
        PRINT 'Network organization: ' + @sTmp0
      END
    ELSE
      BEGIN

        PRINT 'Network organization: unavailable'
      END

    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @url
    EXEC @hr = sp_OADestroy @response
    EXEC @hr = sp_OADestroy @json


END
GO