Excel Add-In for LinkedIn

Build 21.0.8137

Establishing a Connection

Configure a Connection Profile

From the CData ribbon, click Get Data and select From LinkedIn connection/s to launch the CData Query window. To setup a new connection, you will have to click the New LinkedIn Connection button. Here you can set the connection settings, test the connection, and save the connection profile.

Connecting to LinkedIn

The LinkedIn CompanyId is a string of numbers, usually 6 to 9 digits long, that is unique to your company. You can find this ID in the URL of the search results page when you click on See All Jobs on your LinkedIn Page. The CompanyId is often required in queries for company data. While this may be set directly in the criteria of a query, the CompanyId may be set globally to avoid issues where the query is not so easily modified.

Authenticate via OAuth Authentication

OAuth requires the authenticating user to interact with LinkedIn using the browser. The add-in facilitates this in various ways as described below. You can connect without setting any connection properties for your user credentials.

When you connect, the add-in opens the LinkedIn OAuth endpoint in your default browser. Log in and grant permissions to the add-in. The add-in then completes the OAuth process.

See Using OAuth Authentication for other OAuth authentication flows.

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to LinkedIn you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

See Also

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137