---
title: "How to use Azure Data Factory with the Supermetrics API"
slug: "how-to-use-azure-data-factory-with-the-supermetrics-api"
description: "Learn to set up Supermetrics API with Azure Storage for automated data writing. Follow our step-by-step guide for seamless integration and scheduling."
updated: 2026-04-22T11:22:25Z
published: 2026-04-22T11:22:25Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to use Azure Data Factory with the Supermetrics API

This guide will walk you through how to set up a very basic implementation using the Supermetrics API to write data from a single Supermetrics query to an Azure Storage Container on a recurring schedule.

Advanced settings like parameters, alternative authentication types, and alternative sinks aren’t covered in this guide.

![Diagram illustrating data flow between Supermetrics API and Azure Data Factory components.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/supermetrics-api-to-azure-data-factory.png)

## Prerequisites

To set this up, you’ll need:

- [An active Azure subscription](https://docs.microsoft.com/en-us/azure/cloud-adoption-framework/decision-guides/subscriptions/)
- [A resource group](https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/manage-resource-groups-portal#what-is-a-resource-group) within your Azure subscription
- [An Azure Data Factory](https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-portal) (default settings are sufficient — a Git configuration isn't necessary)
- [An Azure Storage account with an Azure Storage Container](https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create?tabs=azure-portal)

## Instructions

### Step 1: Create a query and K-JSON URL

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **API queries** under **Manage**.
2. Click **Select data source**.
3. Select a data source and connection to use.
4. In the sidebar on the left, [build your query](/v1/docs/how-to-use-the-query-manager).We recommend saving working queries into the custom schema, and using the relative time range (e.g., last 7 days) for the incremental load. Smaller and lighter queries help ensure stability, so we recommend using those wherever possible.
5. Click **Run** to test it and review your data in the preview.
6. From the URL format options, select **K-JSON**.
7. Copy the K-JSON URL.

> [!CAUTION]
> Keep the API key safe
> 
> The query URL includes an API key that gives anyone with the URL access to your data. Treat this as you would a password and keep it safe. If you need to share the URL publicly, use the Short URL option that does not display your API key.

### Step 2: Create a REST linked service

To connect Supermetrics to Azure Data Factory, you’ll need a linked service with the REST API. [Learn more about the REST API in Azure’s documentation](https://docs.microsoft.com/en-us/azure/data-factory/quickstart-create-data-factory-rest-api).

1. Open Azure Data Factory Studio.
2. Click **Linked services** under Manage in the sidebar.
3. Click **New** and then select **REST**.
4. Give your data extract a memorable name (e.g. Supermetrics_Facebook_Campaign).
5. Paste the URL you copied from Query Manager into the Base URL field.
6. Select **Anonymous** from the **Authentication type** dropdown menu.
7. Leave all other options as they are and click **Create**.

### Step 3: Create a dataset to use the REST linked service as a source

1. Open the Factory resources tab by clicking **Author** in the sidebar.
2. Under Dataset, select **New dataset**.
3. Choose **REST**, add a meaningful name, and select the Linked Service you created in Step 1.
4. Save the dataset.

### Step 4: Create a linked service for your Storage Container

To write files to an Azure Storage Container, we’ll need to configure another linked service in Data Factory.

1. Click **Linked services** under Manage on the sidebar.
2. Click **New** and then select **Azure Blob Storage**.
3. Give your linked service a memorable name.
4. Select your Azure Subscription and your Azure Storage Account.
5. Optionally test the connection to your bucket. The test will only test access to the bucket, not the subdirectories in the bucket. We’ll define the directory structure later.

### Step 5: Create a dataset for your Storage Container

Now that we’ve connected our Storage Account to Data Factory, we need to create a dataset that we can use in our pipeline operation.

1. Open the Factory resources tab by clicking **Author** on the sidebar.
2. Under Dataset, select **New dataset**.
3. Choose**Azure Blob Storage**.
4. Select **DelimitedText**.
5. Give your dataset a familiar name and select the Linked Service you created in Step 4.
6. Check the First row as header box.
7. Enter the name of your container, any subdirectories you’d like, and the desired name of your output file.
8. Select **None** for Import Schema.
9. Save your dataset and continue on to the next step.

### Step 6: Create a pipeline using your dataset and sink

Create a new pipeline or edit an existing one.

1. Drag a Copy data activity in your pipeline. (This is under the **Move & transform** section.)
2. Click the new Copy activity and click the **Source** tab.
3. Specify the source — this will be the dataset you created in Step 3.
4. Specify your sink — this will be the Dataset you created in Step 5.
5. Use the **Validate** button to ensure your configuration is valid.
6. Use the **Debug** button to simulate a run of your pipeline.
7. You should now see a file in your Azure Container generated from the Supermetrics API.
8. Once you’re satisfied with your file output, publish your changes.

### Step 7: Create a trigger to schedule your pipeline run

1. Once you’ve published your changes from Step 6, open your pipeline and click the **Add trigger** button at the top of the pane.
2. Choose **Add/New,** and then **New**.
3. Leave the Type as “Schedule”, and pick your frequency, timezone, and time of day. (Your frequency is determined by your Supermetrics contract.)
4. Click **OK** to save your trigger. Be sure to publish your changes.