Build apps that scale with managed and intelligent SQL database in the cloud.
Executes a SQL query and returns the results. See the documentation
Write custom Node.js code and use any of the 400k+ npm packages available. Refer to the Pipedream Node docs to learn more.
Inserts a new row in a table. See the documentation
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.
import sql from "mssql"
export default defineComponent({
props: {
azure_sql: {
type: "app",
app: "azure_sql",
}
},
async run({steps, $}) {
const { host, username, password, port, database, encrypt } = this.azure_sql.$auth
const config = {
user: username,
password,
server: host,
port,
database,
authentication: {
type: 'default'
},
options: {
encrypt
}
}
await sql.connect(config);
return await sql.query`SELECT GETDATE()`
},
})
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:
// 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
},
})