Premium

IPinfo

The CloudQuery IPinfo source plugin extracts IP address information and loads it into any supported CloudQuery destination

Publisher

capregsoft

Latest version

v1.0.2

Type

Source

Platforms

Date Published

December 20, 2023

Price per 1M rows

Starting from $17

monthly free quota

1M rows

Documentation Tables Changelog Destinations

Overview

Set up process #

brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync ipinfo.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview #

IPinfo Source Plugin

The CloudQuery IPinfo plugin extracts information from supported services by ipinfo.io and loads into any supported CloudQuery destination (e.g, Sqlite, and more). It is based on the github.com/ipinfo/go library.

Authentication #

CloudQuery requires only IP and TOKEN. Follow this guide for how to create an token for ipinfo CloudQuery.

On the free tier, users have access to geolocation information of IP addresses, and the response payload looks like this:

{
  "ip": "207.31.10.72",
  "hostname": "a207-31-10-072.unionsd.k12.ca.us",
  "city": "San Jose",
  "region": "California",
  "country": "US",
  "loc": "37.2563,-121.9229",
  "org": "AS3734 Santa Clara County Office of Education",
  "postal": "95124",
  "timezone": "America/Los_Angeles",
}

If the user is signed up to a paid tier, they can access several different IP data such as IP privacy/VPN detection, company insights, ASN data, carrier data etc. The API response payload depends on the pricing the user is on. The highest tier API response payload looks like this:

{
  "ip": "43.241.123.0",
  "city": "Mahbūbnagar",
  "region": "Telangana",
  "country": "IN",
  "loc": "17.3250,78.5623",
  "postal": "509129",
  "timezone": "Asia/Kolkata",
  "asn": {
    "asn": "AS134033",
    "name": "MITHRIL TELECOMMUNICATIONS PVT. LTD.",
    "domain": "hireachbroadband.com",
    "route": "43.241.123.0/24",
    "type": "isp"
  },
  "company": {
    "name": "MITHRIL TELECOMMUNICATIONS PVT. LTD.",
    "domain": "mithriltele.com",
    "type": "isp"
  },
  "carrier": {
    "name": "AirTel",
    "mcc": "404",
    "mnc": "2"
  },
  "privacy": {
    "vpn": false,
    "proxy": false,
    "tor": false,
    "relay": false,
    "hosting": false,
    "service": ""
  },
  "abuse": {
    "address": "5-5-126/1/PLOT NO.5, KRANTHI HILLS COLONY,VANSATHALIPURAM, Hyderabad, Telangana, 500070",
    "country": "IN",
    "email": "[email protected]",
    "name": "RAJESH PONNA",
    "network": "43.241.120.0/22",
    "phone": "+91 9951512121"
  },
  "domains": {
    "page": 0,
    "total": 0,
    "domains": []
  }
}

Configuration #

The following example sets up the HubSpot plugin, and connects it to a postgresql destination:

kind: source
spec:
  # Source spec section
  name: ipinfo
  path: cloudquery/ipinfo
  registry: cloudquery
#   registry: "grpc"
  version: "undefined"
  tables: ["*"]
  destinations: ["postgresql"]
  spec:
    # Firestore specific configuration goes here
    ip: ${IP}
    token: ${TOKEN}

IPinfo Spec #

This is the specs that can be used by the IPinfo source Plugin.

ip (string, optional): To lookup information of a particular IP address, for example, 8.8.8.8
token (string, optional)
Rate limit per second for requests done HubSpot API, this will depend on your IPinfo plan (https://ipinfo.io/pricing)