Authentication method: 2 Step Authentication

Highlights

Overview The 2-step authentication method is used to securely connect to a REST/URL connector.
This method involves two steps:
  1. Submitting your credentials to a web service in order to generate a unique authentication key
  2. Using the authentication key in the request URL in order to securely submit your request to that web service.

Required fields

Username Credentials that identify your account
Password Verifies the authenticity of the account
Response Select Text, XML, or JSON
Method Select GET or POST
Parameters For parameters, enter a Name, a Value, and select a Type - Query, Header or Cookie.
Auth URL This URL generates the authentication token or session key that allows you to access the API. This URL may require you to include email, password and api key parameters. For example:
https://pi.pardot.com/api/prospect/version/3/
Token Path This is a regular expression that allows Klipfolio to retrieve the authentication or session key from the response received via the Auth URL. For example:
<api_key>(.*?)</api_key> - This example is specific to Pardot
Logout Method Select GET or POST.
Logout URL This is used if the resource features a lockout for having too many sessions open.

Step-by-step: Using REST/URL

To create a data source using a REST/URL connector, you need to accomplish three tasks:

  • Start the data source creation process in Klipfolio.
  • Write a request URL using developer documentation provided by your service provider.
  • Enter the request URL in Klipfolio.

Step 1: Start the data source creation process

  1. Click the Library link.
  2. Select the Data Sources tab.
  3. Click the Create a New Data Source button.
  4. Select the REST/URL connector option.

Step 2: Write an API query

Begin by going to the REST/URL connector that you would like to retrieve data from.

Some API connection requests are free and open to the public. However, depending on the service provider, you may need to:

  • Have an account with the service provider.
  • Contact the service provider to grant you API request permissions.
  • Contact the service provider to receive an authentication token.
  • Pay an API access fee.

Step 3: Enter the Request URL into Klipfolio 

In the REST/URL connector, ensure that you:

  1. Copy and paste the URL request from the website into Klipfolio.
  2. Choose the appropriate data format (XML,CSV, Excel, or JSON).
  3. Expand the Authentication (OAuth, 2-Step, X-WSSE, or Basic) menu.
  4. Under Type, select the option 2 Step Authentication.

Example

Other authentication methods