Integrate the Microsoft SQL Server API with the Node API

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

Popular Ways to Connect Microsoft SQL Server with Node#

Run Node Code with Node API on New Column from Microsoft SQL Server API

Microsoft SQL Server + Node

Try it

Run Node Code with Node API on New Or Updated Row from Microsoft SQL Server API

Microsoft SQL Server + Node

Try it

Popular Microsoft SQL Server and Node Triggers#

New Column from the Microsoft SQL Server API

Triggers when a new column is added to a table. See the documentation

Try it

New Or Updated Row from the Microsoft SQL Server API

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

Try it

Popular Microsoft SQL Server and Node Actions#

Execute Query with the Microsoft SQL Server 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

Insert Row with the Microsoft SQL Server API

Inserts a new row in a table. See the documentation

Try it

Overview of Microsoft SQL Server#

With the Microsoft SQL Server API on Pipedream, you can automate your database operations and create powerful integrations. This API allows you to execute queries, manage databases, and trigger actions based on data changes. Implementing workflows that react to database events, manipulate data, or synchronize SQL Server data with other services, becomes effortless with Pipedream's serverless platform.

Connect Microsoft SQL Server#

import sql from "mssql"
export default defineComponent({
  props: {
    microsoft_sql_server: {
      type: "app",
      app: "microsoft_sql_server",
    }
  },
  async run({steps, $}) {
    const { host, username, password, port, database } = this.microsoft_sql_server.$auth
    const conn_str = `Server=${host},${port};Database=${database};User Id=${username};Password=${password};Encrypt=true`;
    await sql.connect(conn_str);
    return await sql.query`SELECT GETDATE()`
  },
})

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
  },
})