Integrate the Microsoft Azure SQL Database API with the Node API

Setup the Microsoft Azure SQL Database API trigger to run a workflow which integrates with the Node API. Pipedream's integration platform allows you to integrate Microsoft Azure SQL Database and Node 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 Node#

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

Microsoft Azure SQL Database + Node

Try it

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

Microsoft Azure SQL Database + Node

Try it

Popular Microsoft Azure SQL Database and Node 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 Node Actions#

Execute Query with the Microsoft Azure SQL Database API

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

Try it

Run Node Code with the Node API

Write custom Node.js code and use any of the 400k+ npm packages available. Refer to the Pipedream Node 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 Node#

Develop, run and deploy your Node.js code in Pipedream workflows, using it between no-code steps, with connected accounts, or integrate Data Stores and File Stores.

This includes installing NPM packages, within your code without having to manage a package.json file or running npm install.

Below is an example of installing the axios package in a Pipedream Node.js code step. Pipedream imports the axios package, performs the API request, and shares the response with subsequent workflow steps:

Connect Node#

// To use previous step data, pass the `steps` object to the run() function
export default defineComponent({
  async run({ steps, $ }) {
    // Return data to use it in future steps
    return steps.trigger.event
  },
})

Start for free — no credit card required

Watch a demo