LinkedIn + Steampipe

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

LinkedIn is a business and employment-focused social media platform.

Example query:

select
  id,
  title,
  headline
from
  linkedin_company_employee
where
  company_id = 7599466
  and query = 'dave';

+----------+--------------+----------+
| id       | title        | headline |
+----------+--------------+----------+
| 13016000 | David Jones  | CTO      |
|  4819034 | Dave Beecham | Engineer |
+----------+--------------+----------+

Documentation

• Table definitions & examples →

Get started

Install

Download and install the latest LinkedIn plugin:

steampipe plugin install linkedin

Configuration

Installing the latest linkedin plugin will create a config file (~/.steampipe/config/linkedin.spc) with a single connection named linkedin:

connection "linkedin" {
  plugin  = "linkedin"
  // Set to value of the `li_at` cookie from a logged in LinkedIn browser session
  token   = "BQEDBQBCO8wBpUgWBBBBhhBtNDUBBBFFNDm4NU4BzcB32MRFFNDdx9md-Qk9_IFs6Lo4z8gTYb5HqUC5h-OjVDM22UiRUgjYX7CrYZw_IMIg6qUICOqqeCzjnb1tqIBIi7_HTZ3z2g_jq3JEqNjzqL7g"
}

LinkedIn does not offer an official API. This plugin uses the APIs normally called by your browser when viewing the website. So, credentials are setup using a browser based session cookie. To get your authentication token for the plugin:

1. Browse to LinkedIn and login.
2. Open your browser developer tools.
3. Open the Network view to see and analyze the network requests that make up each individual page load within a single user's session.
4. Open any request to a www.linked.com URL from the list and check the Cookies tab to get the list of request cookies.
5. The token is the value of the cookie named li_at.

Environment variables are also available as an alternate configuration method:

• LINKEDIN_TOKEN

Get involved

• Open source: https://github.com/turbot/steampipe-plugin-linkedin
• Community: Slack Channel