How can we help?

PowerMetrics: Basic HTTP authentication (for data source accounts)

 

Our recent redesign simplifies the data transfer experience by combining raw and modelled data sources into a single object - data feeds. We’re gradually releasing this new feature to our customers.
If your account uses data sources, you're in the right place. If you see Data Feeds in the left navigation sidebar, go to this article instead.

 

Highlights

Overview Basic HTTP authentication is an authentication method that requires valid credentials to be passed as part of the API call. In most cases, requesters need to provide a username and password in the URL request. Requesters receive a key in return that is used as either a query or a header parameter.

Required fields

Username Credentials that identify your account
Password Verifies the authenticity of your account
 

Connecting to your data using the REST/URL connector

To connect to your data using the REST/URL connector, you need to:

  1. Write a query (request URL) by referring to the service provider's developer documentation.
  2. Create and save a data source.

Step 1: Write an API query

Begin by going to the developer documentation for the service provider 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 2: Create and save a data source

To create and save a data source:

  1. Click the + button beside Data Sources in the left navigation sidebar.


Note: If you don't see this option, click your Account Name at the bottom of the left navigation sidebar and select Data Sources instead. Then, in your data source library, click Create a New Data Source.

  1. On the Where is your data? page, under Core Services, click the REST/URL tile.
  2. On the Configure your connection page, paste the URL call from the REST/URL into the Query URL field.
  3. Choose the appropriate Data format (XML, CSV, Excel, or JSON).
  4. Expand the Authentication (OAuth, 2-Step, X-WSSE, or Basic) menu.
  5. Under Type, select the option Basic HTTP.
  6. Click Get data.
  7. Ensure this is the data you're looking for and, optionally, select the checkbox to Model your data. Learn more about modelling your data source.
  8. Click Continue.
  9. Name, choose refresh settings, and, optionally, share the data source.
  10. Click Save.
 
Updated
Have more questions? Submit a request