PayPal Query Authentication

PayPal Query Authentication


Overview

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

Important Information

  • The PayPal 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 Project Manage OAuth.

    Please Note

    If a PayPal 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 PayPal. 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 PayPal Developer portal and click Log into Dashbaord in the top right of the screen, then enter valid login credentials on the next screen.

    Log in to PayPal Developer portal

    Log in to PayPal Developer portal

  2. The PayPal Developer portal will open on the My apps & credentials window. From here, click Create app below the REST API apps list.

    PayPal Developer dashboard

    PayPal Developer dashboard

  3. Now, in the Create New App window, provide details for the following fields:

    • App Name: provide a name for the new app
    • Sandbox Business Account: select which account with which the new app will be associated, then click Create App

    Create a new app

    Create a new app

  4. The browser will then redirect to an information window for the newly created app. Copy the code in the field below Client ID, then click Show and copy the code in the Secret field. These codes will be required in Authorising for use in Matillion ETL.

    Copy Client ID and Secret

    Copy Client ID and Secret


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 PayPal Developer portal earlier, provide details for the following fields:

    • Client ID – enter the Client ID
    • Client Secret – enter the Secret, then click OK.

    Configure OAuth settings

    Configure OAuth settings