Steampipe Integration

Steampipe enables querying of cloud APIs using just SQL queries. IP2Location.io Steampipe plugin enables users to query IP geolocation data as well as WHOIS data.

All you have to do is install Steampipe then install the IP2Location.io Steampipe plugin with the below command:

steampipe plugin install ip2location/ip2locationio

You will need an API key to get started. If you don't have one, please register for a free API key.

How to use IP2WHOIS in Quickwork

You can query WHOIS data using SQL like below:

select
  domain,
  domain_id,
  status,
  create_date
from
  ip2locationio_whois
where
  domain = 'google.com';

You will see:

+------------+-------------------------+---------------------------------------------------------------------------+----------------------+
| domain     | domain_id               | status                                                                    | create_date          |
+------------+-------------------------+---------------------------------------------------------------------------+----------------------+
| google.com | 2138514_DOMAIN_COM-VRSN | clientUpdateProhibited (https://www.icann.org/epp#clientUpdateProhibited) | 1997-09-15T07:00:00Z |
+------------+-------------------------+---------------------------------------------------------------------------+----------------------+
				

For more information, please refer the IP2Location.io Steampipe documentation.