What do you want to automate
with Database and Cloze?
Prompt, edit and deploy AI agents that connect to Database, Cloze and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Database and Cloze Triggers#
Emit new event when significant changes regarding a company are detected. See the documentation
Emit new event when significant changes happen to a person. See the documentation
Emit new event when a significant change occurs in a project. See the documentation
Popular Database and Cloze Actions#
Create a new company or enhance an existing company within Cloze. Companies can be created with just a domain name or both a name and another unique identifier such as a phone number and email address. See the documentation
Create a new project or merge updates into an existing one. 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 Cloze#
The Cloze API enables you to access and manage your Cloze CRM data programmatically. In Pipedream, you can create powerful, serverless workflows that react to events or run on schedules to automate tasks involving Cloze data. You could synchronize contacts, track communication history, or trigger actions based on updates in Cloze. By leveraging Pipedream's capacity to connect to a myriad of services, you can create multi-step workflows that involve other apps to streamline your business processes and harness the full potential of CRM automation.
Connect Cloze#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
cloze: {
type: "app",
app: "cloze",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.cloze.com/v1/profile`,
headers: {
Authorization: `Bearer ${this.cloze.$auth.oauth_access_token}`,
},
})
},
})
Trusted by 1,000,000+ developers from startups to Fortune 500 companies