Integrate the Microsoft Azure SQL Database API with the Python API

Setup the Microsoft Azure SQL Database API trigger to run a workflow which integrates with the Python API. Pipedream's integration platform allows you to integrate Microsoft Azure SQL Database and Python remarkably fast. Free for developers.

Start for free — no credit card required

Watch a demo

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Popular Ways to Connect Microsoft Azure SQL Database with Python#

Run Python Code with Python API on New Column from Microsoft Azure SQL Database API

Microsoft Azure SQL Database + Python

Try it

Run Python Code with Python API on New or Updated Row from Microsoft Azure SQL Database API

Microsoft Azure SQL Database + Python

Try it

Popular Microsoft Azure SQL Database and Python Triggers#

New Column from the Microsoft Azure SQL Database API

Triggers when a new column is added to a table.

Try it

New or Updated Row from the Microsoft Azure SQL Database API

Triggers when a new row is added or an existing row is updated.

Try it

Popular Microsoft Azure SQL Database and Python Actions#

Execute Query with the Microsoft Azure SQL Database API

Executes a SQL query and returns the results. See the documentation

Try it

Run Python Code with the Python API

Write Python and use any of the 350k+ PyPi packages available. Refer to the Pipedream Python docs to learn more.

Try it

Execute SQL Query with the Microsoft Azure SQL Database API

Execute a custom SQL query. See our docs to learn more about working with SQL in Pipedream.

Try it

Insert Row with the Microsoft Azure SQL Database API

Inserts a new row in a table. See the documentation

Try it

Query SQL Database with the Microsoft Azure SQL Database API

Execute a SQL Query. See our docs to learn more about working with SQL in Pipedream.

Try it

Overview of Microsoft Azure SQL Database#

The Microsoft Azure SQL Database API allows you to manage and interact with your SQL databases hosted on Azure directly from Pipedream. It provides a serverless way to run SQL queries, manage tables, and handle database management tasks. You can create, read, update, and delete database records, execute stored procedures, and perform a variety of other SQL operations. Leveraging this API on Pipedream enables you to automate workflows, respond to database events in real-time, and integrate with countless other apps and services.

Connect Microsoft Azure SQL Database#

import azure_sql from '@pipedream/azure_sql';

export default defineComponent({
  props: {
    azure_sql,
  },
  async run({ steps, $ }) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/azure_sql

    const queryObj = {
      query: "SELECT GETDATE()",
      values: [],
    };
    return await this.azure_sql.executeQuery(queryObj);
  },
});

Overview of Python#

Develop, run and deploy your Python code in Pipedream workflows. Integrate seamlessly between no-code steps, with connected accounts, or integrate Data Stores and manipulate files within a workflow.

This includes installing PyPI packages, within your code without having to manage a requirements.txt file or running pip.

Below is an example of using Python to access data from the trigger of the workflow, and sharing it with subsequent workflow steps:

Connect Python#

def handler(pd: "pipedream"):
  # Reference data from previous steps
  print(pd.steps["trigger"]["context"]["id"])
  # Return data for use in future steps
  return {"foo": {"test":True}}

Start for free — no credit card required

Watch a demo