---
title: Insert your API Query Manager data into Azure Blob Storage
description: With Dataslayer you can pull a URL directly from our API QM product in JSON format (learn how to do it here). Each URL corresponds to a data table. To enter the information of each URL that you genera
---

[Skip to content](https://support.dataslayer.ai/insert-your-api-query-manager-data-into-azure-blob-storage#main-content)

- [English](https://support.dataslayer.ai/insert-your-api-query-manager-data-into-azure-blob-storage)
- [Español](https://support.dataslayer.ai/es/insertar-tus-datos-de-api-query-manager-en-azure-blob-storage)

English

Show submenu for translations

[![Dataslayer](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?height=35&name=Dataslayer_New_Logo.png)](https://www.dataslayer.ai/)

Open main navigation

Close main navigation

- - [English](https://support.dataslayer.ai/insert-your-api-query-manager-data-into-azure-blob-storage)
    - [Español](https://support.dataslayer.ai/es/insertar-tus-datos-de-api-query-manager-en-azure-blob-storage)

  English
  
  Show submenu for translations

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge base](https://support.dataslayer.ai/?hsLang=en)
2. [API Query Manager](https://support.dataslayer.ai/api-query-manager?hsLang=en)

May 28, 2024

# Insert your API Query Manager data into Azure Blob Storage

> ### Import your data in Microsoft Azure with our API QM product

With Dataslayer you can pull a URL directly from our API QM product in JSON format ([learn how to do it here](https://support.dataslayer.ai/how-to-use-dataslayer-api-query-manager?hsLang=en)). Each URL corresponds to a data table.

To enter the information of each URL that you generate with us to **Azure**, it is as easy as **having a lambda function configured that calls as many URLs as you generate and need**, converts the JSON format to CSV if you wish, and finally, **upload it to your Azure account**. All this can be done by the lambda function.

This is an example of **a lambda function that calls different URLs made with our API QM product to push that URL data into Azure**. In this version of the Lambda function, we use **azure.storage.blob** module to interact with Azure Storage.   
To authenticate the connection, you'll need to get a connection string and container name from your Azure Storage account and provide them in the function. Additionally, we use a **BlobClient** to interact with the Blob objects.

This example is made in Python, but it can be transformed into any programming language you want, and you can also take advantage of lambda to transform the data when saving it to your Azure account.

```
import requestsfrom azure.storage.blob import BlobServiceClientdef lambda_handler(event, context):    urls = [        # Each API Query Manager URL        # ...    ]    # Retrieve the connection string and container name from environment variables    connect_str = '<connection_string>'    container_name = '<container_name>'    # Create a BlobServiceClient object to interact with the Blob storage account    blob_service_client = BlobServiceClient.from_connection_string(connect_str)    for url in urls:        response = requests.get(url)        data = response.json()        # Get a BlobClient object to represent the blob        blob_client = blob_service_client.get_blob_client(container=container_name, blob='<file_name>.json')        # Upload the data to the blob        blob_client.upload_blob(data)    return 'Data stored in Azure Blob storage successfully'
```

 

As always, please contact us via our live chat on our [website](https://dataslayer.ai/) or via [email](mailto:info@dataslayer.ai) if you still have doubts or questions. We are happy to help!

``

- [General](https://support.dataslayer.ai/general?hsLang=en)
- [Billing & Pricing](https://support.dataslayer.ai/billing-pricing?hsLang=en)
- [Data Sources](https://support.dataslayer.ai/data-sources?hsLang=en)
- [Blended Connectors](https://support.dataslayer.ai/blended-connectors?hsLang=en)
- [Google Sheets](https://support.dataslayer.ai/google-sheets?hsLang=en)
- [Microsoft Excel](https://support.dataslayer.ai/microsoft-excel?hsLang=en)
- [Spreadsheets](https://support.dataslayer.ai/spreadsheets?hsLang=en)
- [Looker Studio](https://support.dataslayer.ai/looker-studio?hsLang=en)
- [Big Query](https://support.dataslayer.ai/big-query?hsLang=en)
- [API Query Manager](https://support.dataslayer.ai/api-query-manager?hsLang=en)
- [Power BI](https://support.dataslayer.ai/power-bi?hsLang=en)
- [Amazon S3](https://support.dataslayer.ai/amazon-s3?hsLang=en)
- [Amazon Redshift](https://support.dataslayer.ai/amazon-redshift?hsLang=en)
- [Snowflake](https://support.dataslayer.ai/snowflake?hsLang=en#main-content)

    - [Marketplace](https://support.dataslayer.ai/snowflake?hsLang=en#marketplace)
- [Google Cloud Storage](https://support.dataslayer.ai/google-cloud-storage?hsLang=en)
- [Database](https://support.dataslayer.ai/database?hsLang=en)
- [Azure SQL](https://support.dataslayer.ai/azure-sql?hsLang=en)
- [Azure Storage](https://support.dataslayer.ai/azure-storage?hsLang=en)
- [Dataslayer Atlas](https://support.dataslayer.ai/dataslayer-atlas?hsLang=en)
- [Morpheus](https://support.dataslayer.ai/morpheus?hsLang=en)
- [AI Looker Studio Analyzer](https://support.dataslayer.ai/ai-looker-studio-analyzer?hsLang=en)
- [Dataslayer MCP](https://support.dataslayer.ai/dataslayer-mcp?hsLang=en)
- [Dataslayer GPT](https://support.dataslayer.ai/dataslayer-gpt?hsLang=en)
- [Dataslayer AI Chat](https://support.dataslayer.ai/dataslayer-ai-chat?hsLang=en)

[![Chill listening crop-3](https://support.dataslayer.ai/hs-fs/hubfs/Dataslayer_New_Logo.png?width=142&height=24&name=Dataslayer_New_Logo.png "Chill listening crop-3")](https://dataslayer.ai/)

Dataslayer.ai: Digital Marketing Reporting Made Easy

<https://www.linkedin.com/company/dataslayer/> <https://www.youtube.com/@dataslayers>

Copyright © 2026, DATASLAYER SL