LinkedIn Query Authentication Guide

LinkedIn Query Authentication Guide


Overview

This is a step-by-step guide to creating an OAuth entry, acquiring credentials and authorising the LinkedIn Query connector for use in Matillion ETL.

Important Information

  • The LinkedIn Query connector uses an OAuth for third-party authentication.
  • While connector properties may differ between Cloud Data Warehouses, the authentication process remains the same.

Creating an OAuth Entry in Matillion ETL

  1. In Matillion ETL, on the top left of the screen, click ProjectManage OAuth.

    Please Note

    If a LinkedIn Query connector has already been added to an Orchestration Job, the Manage OAuth window may also be accessed using the following method:

    1. Click the connector icon to open the Properties panel at the bottom of the screen.
    2. Click ... next to the Authentication input, and finally click Manage in the pop-up window.
    Project dropdown menu

    Project dropdown menu

  2. Copy the Callback URL in the field at the top of the window as this will be required in Acquiring Third-Party Credentials.

  3. Click + in the bottom left of the window to open the Create OAuth Entry window.

    New OAuth entry

    New OAuth entry

  4. Click the Service dropdown menu and select LinkedIn. Then, provide a name for the OAuth in the Name field and click OK.

    Create OAuth Entry window

    Create OAuth Entry window

  5. On returning to the Manage OAuth window, check the list of OAuths to ensure the new entry is listed.

    Please Note

    This entry is Not Configured. Configuration of the OAuth entry will be discussed in Authorising for use in Matillion ETL.

    New Entry listed on Manage OAuth window

    New Entry listed on Manage OAuth window


Acquiring Third-Party Credentials

  1. Navigate to the LinkedIn Developers site, click Sign In on the menu in the top right of the screen and enter valid login credentials.

    LinkedIn Developers site homepage

    LinkedIn Developers site homepage

  2. Once logged in, the browser will return to the LinkedIn Developers site homepage. Sign In will have been replaced by the user icon. Now, click My AppsCreate app on the top left of the screen or click Create App in the centre of the screen.

    Logged in to LinkedIn Developers site

    Logged in to LinkedIn Developers site

  3. On the Create an app page, provide details for the following required (*) fields:

    • App name – provide a name for the app
    • Company – provide the name of a company to be associated with the app
    • Business email – provide an email address for the associated company
    • App logo – upload a logo to be displayed to users when authorising with the app

    Please Note

    The company associated with the app cannot be changed at a later stage.

    Create an app

    Create an app

  4. Once the required fields have been filled, scroll down to the Legal terms section. Read the API terms of use before ticking I have read and agree to these terms, then click Create app.

    Please Note

    Once the app has been created, it will require company verification, which can be initiated by clicking Verify in the Settings tab. However, this can be done at a later stage.

    Agree to legal terms

    Agree to legal terms

  5. Click the Auth tab at the top of the window, then copy the codes from both the Client ID and Client Secret fields, as they will be required in Authorising for use in Matillion ETL.

    Please Note

    When copying the codes, some browsers may add a space to the end of the code. Watch out for this as it will cause the credentials to fail.

  6. Scroll down to the OAuth 2.0 settings section. Then, in the Redirect URLs field, paste the Callback URL (copied earlier from the Manage OAuth window in Matillion ETL). Finally, click Update.

    Please Note

    In order to copy the Client Secret, 👁 must first be clicked to make it visible.

    Copy the Client ID and Secret, then paste the Callback URL

    Copy the Client ID and Secret, then paste the Callback URL


Authorising for Use in Matillion ETL

  1. Return to the Manage OAuth window in Matillion ETL and click next to the previously created OAuth entry. This will open the Configure OAuth window.

    Configure OAuth settings

    Configure OAuth settings

  2. Using the codes copied from the LinkedIn Developers site earlier, provide details for the following fields:

    Configure OAuth settings

    Configure OAuth settings

  3. The next window will have an Authorization link. Click the link to authorise Matillion ETL to use the acquired credentials.

    Authorization link

    Authorization link

  4. The browser will then redirect to a LinkedIn screen requesting access to a number of LinkedIn features. Click Allow to confirm.

    Allow LinkedIn access

    Allow LinkedIn access

  5. If all is successful, the browser will return to Matillion ETL with a window stating, "Authorization Successful".

    OAuth Authorization successful

    OAuth Authorization successful