MySQL is an open-source relational database management system.
Emit new event when a new ticket is created. See the docs here
Emit new event when a new unassigned ticket with a due date is created. See the docs
Emit new event when a new unassigned ticket with a scheduled on date is created. See the docs
Emit new event when a new user is created. See the docs here
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);
},
});
Mojo Helpdesk API lets you seamlessly integrate your customer support system into your business workflow. With this API, you can automate ticket creation, update statuses, track ticket progress, manage user accounts, and extract ticket data for analysis. Take advantage of Pipedream's capabilities to connect Mojo Helpdesk with various services, triggering actions based on customer interactions, automating responses, and synchronizing data across platforms to streamline your customer support and enhance the user experience.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
mojo_helpdesk: {
type: "app",
app: "mojo_helpdesk",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://app.mojohelpdesk.com/api/v2/users`,
params: {
access_key: `${this.mojo_helpdesk.$auth.access_key}`,
},
})
},
})