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, headlinefrom linkedin_company_employeewhere company_id = 7599466 and query = 'dave';
+----------+--------------+----------+| id | title | headline |+----------+--------------+----------+| 13016000 | David Jones | CTO || 4819034 | Dave Beecham | Engineer |+----------+--------------+----------+
Documentation
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:
- Browse to LinkedIn and login.
- Open your browser developer tools.
- Open the Network view to see and analyze the network requests that make up each individual page load within a single user's session.
- Open any request to a www.linked.com URL from the list and check the Cookies tab to get the list of request cookies.
- 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