MySQL is an open-source relational database management system.
Creates a new page or blog post on Confluence. See the documentation
Removes a blog post from Confluence by its ID. Use with caution, the action is irreversible. See the documentation
The MySQL application on Pipedream enables direct interaction with your MySQL databases, allowing you to perform CRUD operations—create, read, update, delete—on your data with ease. You can leverage these capabilities to automate data synchronization, report generation, and event-based triggers that kick off workflows in other apps. With Pipedream's serverless platform, you can connect MySQL to hundreds of other services without managing infrastructure, crafting complex code, or handling authentication.
import mysql from '@pipedream/mysql';
export default defineComponent({
props: {
mysql,
},
async run({steps, $}) {
// Component source code:
// https://github.com/PipedreamHQ/pipedream/tree/master/components/mysql
const queryObj = {
sql: "SELECT NOW()",
values: [], // Ignored since query does not contain placeholders
};
return await this.mysql.executeQuery(queryObj);
},
});
The Confluence API allows you to harness the collaborative power of Confluence programmatically. With it, you can automate content creation, update pages, manage spaces, and extract data for reporting or integration with other tools. Leveraging this API within Pipedream enables streamlined workflows that can react to events or schedule tasks, interacting with Confluence data and connecting to an array of other apps and services.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
confluence: {
type: "app",
app: "confluence",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.atlassian.com/me`,
headers: {
Authorization: `Bearer ${this.confluence.$auth.oauth_access_token}`,
},
})
},
})