Open navigation

How to use Alteryx with the Supermetrics API

The Supermetrics API is compatible with Alteryx, a data analytics platform.


Read this article to learn how to connect them.


Instructions

  1. Go to the Supermetrics Hub.
  2. In the sidebar, click API.
  3. Prepare your query endpoint using the Qlik format (.csv). We recommend saving working queries into the custom schema, and using the relative time range (for example, “last 7 days”), to reduce incremental load.

    Keep the API key safe

    This will generate a query URL — treat this as you would a password, and keep it safe. It’ll include an API key that anyone with the URL can use to access your data. We recommend using the Short URL option in Query Manager to avoid displaying the API key.

  4. Open Alteryx.
  5. Drop the following tools into your workflow. If you can’t find them, search for them in the field at the top right corner, and then drag their symbols into your workflow. See the table below for details on the settings for each of these tools.

    Text Input → Download Data → Text to Columns → Text to Columns → Multi-field formula → Dynamic Rename → Select → Browse



  6. Run your workflow.
  7. Click Browse to preview your data output.
  8. Replace "Browse tool" with your destination of choice or ongoing workflow.



Workflow tools

ToolDetails
Text Input
  • Paste the query URL from Query Manager into Field1
Download Data
  • Select Field1 in dropdown
  • Deselect “Encode URL Text” checkbox
Text to Columns (1 — Rows)
  • Column to split: DownloadData
  • Delimiters: /n
  • Select “SplitToRows”
Text to Columns (2 — Columns)
  • Column to split: DownloadData
  • Delimiters: ,
  • Number of columns: Total number of columns being imported
  • Advanced options: Ignore delimiters in quotes
Multi-field Formulas
  • Select “Text Fields” 
  • Select all fields you want to strip quotes from
  • Expression: StripQuotes([_CurrentField_])
Dynamic Rename
  • Rename mode: Take Field Names from First Row of Data (Unselect the Field1, DownloadData and DownloadHeaders)
Select
  • Deselect the first 3 generic columns


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.