with Microsoft Azure SQL Database and Planview Leankit?
Triggers when a new row is added or an existing row is updated.
Emit new event when a card is created in a specific lane.
Emit new event when a card is created on a board.
Emit new event when a card enters a specific lane.
Executes a SQL query and returns the results. See the documentation
Create a new card type on a board. See the docs here
Create a comment in a card or task. See the docs here
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 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);
},
});
Planview LeanKit API empowers users to automate and integrate their Kanban workflow management. With this API, you can programmatically access boards, cards, and related data to sync with other systems, trigger actions based on board updates, and extract analytics for reporting purposes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
planview_leankit: {
type: "app",
app: "planview_leankit",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.planview_leankit.$auth.domain}.leankit.com/io/scim/v1/Users`,
auth: {
username: `${this.planview_leankit.$auth.username}`,
password: `${this.planview_leankit.$auth.password}`,
},
})
},
})