What do you want to automate
with Database and Jobber?
Prompt, edit and deploy AI agents that connect to Database, Jobber and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Database and Jobber Actions#
Generates a new quote for a client's property in Jobber. See the documentation
Creates a new service request for a client's first property within Jobber. See the documentation
Overview of Database#
The Database API on Pipedream allows users to execute SQL commands directly within workflows, enabling rich and dynamic data manipulation and storage. It supports PostgreSQL, MySQL, and SQLite, making it a versatile option for managing data across various database systems. With this API, users can perform tasks such as data insertion, querying, updates, and deletions, directly within their automations, facilitating real-time data processing and integration across multiple platforms.
Connect Database#
import postgresql from "@pipedream/postgresql";
export default {
props: {
postgresql,
sql: {
type: "sql",
auth: {
app: "postgresql",
},
label: "PostreSQL Query",
},
},
async run({ $ }) {
const args = this.postgresql.executeQueryAdapter(this.sql);
const data = await this.postgresql.executeQuery(args);
return data;
},
};
Overview of Jobber#
The Jobber API allows for the automation of service business operations, such as scheduling jobs, managing clients, and invoicing. By pairing it with Pipedream, you can craft powerful serverless workflows that react to events in Jobber or integrate with other services to streamline your business processes. With Pipedream’s ability to connect to hundreds of apps, you can create custom automations without writing a lot of code, handling everything from data transformations to complex logic.
Connect Jobber#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
jobber: {
type: "app",
app: "jobber",
}
},
async run({steps, $}) {
const data = {
"query": `query SampleQuery {
user(id: null){
id
email {
raw
}
}
}`,
}
return await axios($, {
method: "POST",
url: `https://api.getjobber.com/api/graphql`,
headers: {
Authorization: `Bearer ${this.jobber.$auth.oauth_access_token}`,
"X-JOBBER-GRAPHQL-VERSION": `2025-01-20`,
},
data,
})
},
})
Trusted by 1,000,000+ developers from startups to Fortune 500 companies