Back to plugin list
ipinfo
Premium

IPinfo

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

Publisher

capregsoft

Repositorygithub.com
Latest version

v1.0.2

Type

Source

Platforms
Date Published

Price per 1M rows

Starting from $15

monthly free quota

0 rows

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": "support@mithriltelecom.com",
    "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)


Subscribe to product updates

Be the first to know about new features.