with Acuity Scheduling and Database?
Blocks a specific time slot on your schedule to prevent the scheduling of any appointments during this particular time range. See the documentation
Retrieves existing appointments using the client's information, allowing you to track all the appointments associated with a specific client. See the documentation
Acuity Scheduling API allows you to tap into the functionality of Acuity Scheduling, a cloud-based appointment scheduling software. With this API on Pipedream, you can automate appointment creation, modifications, and cancellations, as well as sync customer data across your tech stack. The API lets you fetch detailed information about schedules, available time slots, and calendar events. Create dynamic, real-time integrations with CRMs, email marketing platforms, or payment gateways to streamline your scheduling and business processes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
acuity_scheduling: {
type: "app",
app: "acuity_scheduling",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://acuityscheduling.com/api/v1/me`,
headers: {
Authorization: `Bearer ${this.acuity_scheduling.$auth.oauth_access_token}`,
},
})
},
})
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.
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;
},
};