Microsoft Azure SQL Database
Build apps that scale with managed and intelligent SQL database in the cloud.
Integrate the Microsoft Azure SQL Database API with the GitHub API
Setup the Microsoft Azure SQL Database API trigger to run a workflow which integrates with the GitHub API. Pipedream's integration platform allows you to integrate Microsoft Azure SQL Database and GitHub remarkably fast. Free for developers.
Popular Ways to Connect Microsoft Azure SQL Database with GitHub#
Popular Microsoft Azure SQL Database and GitHub Triggers#
Triggers when a new row is added or an existing row is updated.
Emit new event when a (classic) project card is created or moved to a specific column. For Projects V2 use New Issue with Status trigger. More information here
Emit new event when a collaborator is added See the documentation
Popular Microsoft Azure SQL Database and GitHub Actions#
Executes a SQL query and returns the results. See the documentation
Find issues and pull requests by state and keyword. See docs here
Inserts a new row in a table. See the documentation
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 GitHub#
The GitHub API is a powerful gateway to interaction with GitHub's vast web of data and services, offering a suite of endpoints to manipulate and retrieve information on repositories, pull requests, issues, and more. Harnessing this API on Pipedream, you can orchestrate automated workflows that respond to events in real-time, manage repository data, streamline collaborative processes, and connect GitHub with other services for a more integrated development lifecycle.
Connect GitHub#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
github: {
type: "app",
app: "github",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.github.com/user`,
headers: {
Authorization: `Bearer ${this.github.$auth.oauth_access_token}`,
"X-GitHub-Api-Version": `2022-11-28`,
},
})
},
})