Stripe Query Authentication Guide

Stripe Query Authentication Guide


Overview

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

Important Information

  • The Stripe Query connector uses either an OAuth or an API token 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 an API token is being used to authenticate the Stripe Query connector, skip to Acquiring Third-Party Credentials.
    • If a Stripe 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. Then, click ... next to Authentication, 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 Stripe. 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 Stripe developers dashboard. The login screen will appear immediately. Enter valid login credentials to continue. Once logged in, the browser will open on the Home window. Then, on the sidebar on the left of the screen, click DevelopersAPI keys to open the API keys window.

  2. Next, in the Standard keys section, copy the code to the right of Secret key as this will be required in Authorising for use in Matillion ETL.

    Please Note

    • If an API token is being used to authenticate the Stripe Query connector, skip to Authorising for Use in Matillion ETL with an API Key.
    • Another secret key can be created by clicking + Create secret key, providing a name in the pop-up window and clicking Create. However, a newly created secret key can only be viewed once, so it must be copied right away.
    • In order to copy the App Secret, Show must first be clicked to make it visible. Valid login credentials may also need to be re-entered.
    • Additionally, when copying the code, some browsers may add a space to the end of the code. Watch out for this as it will cause the credentials to fail.
    Copy Secret key

    Copy Secret key

  3. Then, on the sidebar on the left of the screen, click Settings. In the Settings window, scroll to the Product settings section and click Connect settings.

    Settings

    Settings

  4. Now, in the Connect settings window, scroll to the Integration section. Then, copy the code to the right of Live mode client ID as this will be required in Authorising for use in Matillion ETL.

    Please Note

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

  5. Next, click + Admin to open the Add redirect URI pop-up window. Then, paste the Callback URL (copied from the Manage OAuth window in Matillion ETL earlier) into the field provided, and click Add URI.

    Please Note

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

    Copy client ID and paste Callback URL

    Copy client ID and paste Callback URL



Authorising for Use in Matillion ETL with an OAuth

  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.

    Please Note

    If an API token is being used to authenticate the Stripe Query connector, skip to Authorising for Use in Matillion ETL with an API Key.

    Configure OAuth settings

    Configure OAuth settings

  2. Using the codes copied from the Stripe developers dashboard 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. If all is successful, the browser will return to Matillion ETL with a window stating, "Authorization Successful".

    OAuth Authorization successful

    OAuth Authorization successful



Authorising for Use in Matillion ETL with an API Key

  1. If a Stripe Query connector has not already been dragged onto the job canvas, search "Stripe" using the Components panel search field, or find the Stripe Query connector under OrchestrationLoad/UnloadFinance.

    Please Note

    An Orchestration Job must be open on the job canvas within Matillion ETL to ensure the Stripe Query connector is searchable within the Components panel.

  2. Then, click and drag the Stripe Query connector onto the job canvas.

    Search for Stripe Query connector

    Search for Stripe Query connector

  3. Click the connector icon on the job canvas to open the Properties panel at the bottom of the screen.

  4. Then, click ... next to the Authentication Method input.

    Open Stripe Query connector properties

    Open Stripe Query connector properties

  5. In the Authentication Method pop-up window, select API Key from the dropdown and click OK. The API Key input will now appear in the list of properties under the Authentication Method input.

    Paste API Key

    Paste API Key

  6. Next, click ... next to the API Key input. Then, in the API Key pop-up window, paste the Secret key (copied from the Stripe developers dashboard earlier) into the Store in connector field and click OK.

    Please Note

    Passwords and codes can also be saved using the Matillion ETL Password Manager. To learn how to do this, please refer to the Manager Passwords article.

    Paste API Key

    Paste API Key

  7. If the API Key is entered correctly, the connector should be authenticated and the status of the input will be displayed as OK.

    Connector successfully authenticated

    Connector successfully authenticated