with Wave and MySQL?
Emit new event when you add a new column to a table. See the docs here
Emit new event when you add or modify a new row in a table. See the docs here
Emit new event when you add a new row to a table. See the docs here
Create a customer under a business. See the documentation
Create an invoice for a customer with one product. See the documentation
Adds a new row. See the docs here
Delete an existing row. See the docs here
Wave is a financial software that simplifies accounting, invoicing, and receipt scanning for small businesses. With the Wave API, you can automate various financial tasks directly within Pipedream. You can create invoices, manage customers, process payments, and extract financial reports. Integrating Wave with Pipedream allows you to connect your accounting workflow with other apps, triggering actions based on financial events or scheduling regular financial operations.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
wave: {
type: "app",
app: "wave",
}
},
async run({steps, $}) {
const data = {
"query": `{
user {
id
defaultEmail
}
}`,
}
return await axios($, {
method: "post",
url: `https://gql.waveapps.com/graphql/public`,
headers: {
Authorization: `Bearer ${this.wave.$auth.oauth_access_token}`,
"Content-Type": `application/json`,
},
data,
})
},
})
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);
},
});